Filmmaking as a Metaphor for the DBA
I worked on four films in 2015, three shorts and one feature-length movie, all shot in Calgary where I live. That has resulted in seven… Read More »Filmmaking as a Metaphor for the DBA
Happy New Year
Instead of a survey or a technical post, I will take this opportunity to wish everyone a happy new year. 2015 was a good year for… Read More »Happy New Year
Survey: Light or Dark
This week I am continuing with the simple survey series. Today my question is, do you prefer using a dark or light background when writing… Read More »Survey: Light or Dark
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… Read More »Survey: Tabs or Spaces
Survey: Join Predicate Order
It’s a quiet month as we look forward to 2016, so I’m asking a series of survey questions for the next few posts. My first… Read More »Survey: Join Predicate Order
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.… Read More »Temporal Tables – When To Use Them
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… Read More »Modifying Temporal Tables – A Primer
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… Read More »Temporal Tables Under The Covers
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… Read More »An Introduction to Temporal Tables in SQL Server 2016 using 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.… Read More »The SQL Server Family
Time to upgrade your SQL Server 2005 instance
Last edited on 17 November 2016. As you know, SQL Server 2005 is now over ten years old. Microsoft has helpfully provided a list of ten reasons… Read More »Time to upgrade your SQL Server 2005 instance
The SQL Server Performance Starter Kit
I received some good feedback on my talk this Wednesday for the Calgary PASS Chapter. This has led me to consider transposing the content from… Read More »The SQL Server Performance Starter Kit
Are You Sure?
I make a lot of assumptions in my day-to-day life, as well as in my job as an IT consultant. To mitigate the inherent arrogance… Read More »Are You Sure?
I’m speaking tomorrow
The local SQL PASS chapter in Calgary is hosting yours truly as the speaker for this month. I only have an hour, which I will… Read More »I’m speaking tomorrow
Speaking at Calgary SQL PASS User Group on 19 August 2015
As the title says, I’ll be speaking at the Calgary SQL PASS User Group on 19 August 2015. My topic is SQL Server Performance Tuning… Read More »Speaking at Calgary SQL PASS User Group on 19 August 2015