A blog post about writing blog posts
I recently wrote about how I teach, in response to a T-SQL Tuesday post from 2010. This is a continuation of that theme, suggested by my own editor. Thanks, Pete. “Tricks to get your mojo…
Survey: Tabs or Spaces
This is my second survey for the month of December. Last week I asked about join predicate order. This week, it’s a simple question: Do you prefer tabs or spaces to indent your T-SQL, and…
Temporal Tables – When To Use Them
Last edited on 18 December 2019. This is the final part of my Temporal Table series. You can read parts one, two and three here. Last week I demonstrated how to modify temporal tables in…
Modifying Temporal Tables – A Primer
This is part three of the Temporal Tables series. You can read parts one and two here. Last week I demonstrated how temporal tables in SQL Server 2016 work. If you have implemented a history…
Temporal Tables Under The Covers
(This is a more technical post than last week. If you are not familiar with SQL Server internals, I will not be upset if you skip it. Otherwise, let’s dive in.) Last week I introduced…
An Introduction to Temporal Tables in SQL Server 2016 using a DeLorean
In 1983, Cyndi Lauper recorded the Billboard chart-topping single, Time After Time, which went on to win the hearts of many lovers in the three decades since then. In 1985, Marty McFly used a DeLorean,…
The SQL Server Family
(This is a non-technical post, and is part of the #SQLNewBlogger Challenge.) This year was my second PASS Summit, and my favourite one so far. Many of the data professionals in attendance with whom I…
Total Recall
This is the final entry in my #SQLNewBlogger challenge. You can read the previous entries here: Part 1: The Intersection of Art and Science Part 2: The Art of Improvisation Part 3: What Motivates You?…
What motivates you?
In this, the third part of my series on the intersection of art and science, I hit that crossroad. I can cross over into the creative, art side, where this post has been written, or…
The Art of Improvisation
This is the second post in my four part series for the #SQLNewBlogger Challenge. You can read the first part here. On Saturday, 28 March 2015, I moved three servers and various networking equipment from…
The Intersection of Art and Science
This is the first post in a series of four, where Ed Leighton-Dick, via Brent Ozar, is proposing that we SQL Server folks participate in the #SQLNewBlogger Challenge. I write a fair number of words…