Max Server Memory Matrix
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 that we change the Max Server Memory setting to an… Max Server Memory Matrix
Update to Azure Blob Storage Sync and Restore
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 made several improvements, and fixed an outstanding bug. As you… Update to Azure Blob Storage Sync and Restore
Basic Availability Groups in SQL Server 2016
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 Groups, a variation of Availability Groups found in the Enterprise… Basic Availability Groups in SQL Server 2016
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 IMDb credits for me, someone who earns a living as… Filmmaking as a Metaphor for the DBA
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 code? I like a light background with dark text (usually… 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 you prefer tabs or spaces to indent your T-SQL, and… Survey: Tabs or Spaces
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… 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 SQL Server 2016 work. If you have implemented a history… 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 skip it. Otherwise, let’s dive in.) Last week I introduced… 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 decades since then. In 1985, Marty McFly used a DeLorean,… 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. Many of the data professionals in attendance with whom I… 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 why you should be upgrading from SQL Server 2005. The… Time to upgrade your SQL Server 2005 instance
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 easily go over, to talk about how I make SQL… 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 Starter Kit, where I will tell you as much as… Speaking at Calgary SQL PASS User Group on 19 August 2015
How I prepared for my first ever SQLSaturday session
I presented for fifty minutes on 27 June 2015, for my first ever SQLSaturday talk. The amount of time I put into that presentation is easily 200 hours, not counting my experience as a college… How I prepared for my first ever SQLSaturday session