A Travel Milestone: Two Keystones

I used to travel a lot. Last year I flew over 140,000 miles in the air, drive another 1000 or so on vacation, and visited numerous countries. It’s hectic...

Database DevOps – Where do I start?

By now you have most likely heard the term DevOps and you are most likely working for a company that has implemented DevOps is some manner, that could be...

Using LAST_QUERY_PLAN_STATS in SQL Server 2019

In my opinion, SQL Server 2019 is one of the greatest releases of the product that Microsoft has ever produced.  The amount of improvements across the platform really allows...

Using LAST_QUERY_PLAN_STATS in SQL Server 2019

In my opinion, SQL Server 2019 is one of the greatest releases of the product that Microsoft has ever produced.  The amount of improvements across the platform really allows...

Daily Coping 17 Jul 2020

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

SQL Server and Docker Compose

I used to think that Docker Compose was used solely to spin up multiple containers, in fact I blogged about doing just that here. That opinion changed when I...

Everything I Never Wanted to Know About Collation (14 minute video/podcast episode)

I'm not an expert on collation in SQL Server, but there are a few important facts which I've had to learn the hard way.

In this episode I share...

Do More, With Less

Next week, July 22 and 23, I’ll be presenting at Redgate Summit. Summt is our smaller, focused sessions. This one is about the concept of how DevOps, or, more...

Daily Coping 16 Jul 2020

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

Comparing SSIS and Azure Data Factory

For the better part of 15 years, SQL Server Integration Services (SSIS) has been the go-to enterprise extract-transform-load (ETL) tool for shops running on Microsoft SQL Server. More recently,...