Working from home, consulting with companies all over the world, has changed how I interact with customers. The last time I was physically on site… Read More »Professionalism doesn’t mean a collared shirt and tie
When we perform diagnostics on an existing SQL Server instance, or if we are setting up a new machine, it’s very important to make sure… Read More »Max Server Memory Matrix
Microsoft Azure and Amazon Web Services are taking over. Last week, a client approached me to migrate their complex environment in two phases from two… Read More »Forecast: Azure Skies Over the Amazon
Blob Storage Sync tool updated During a SQL Server migration this month, I found some inconsistencies in my Azure Blob Storage Sync tool, so I… Read More »Update to Azure Blob Storage Sync and Restore
One of the new features in SQL Server 2016 Standard Edition, which may appeal to users of the deprecated Database Mirroring feature, is Basic Availability… Read More »Basic Availability Groups in SQL Server 2016
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
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
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
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
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
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
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
(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
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
(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