Overview of DML Operations – SQL Delete

This article on the SQL Delete is a part of the SQL essential series on key statements, functions and operations...

Query Store and Plan Cache Plans Compared

Query Store plans and the plans in cache are identical, right? There won’t be differences because the plan that is...

Running SQL Server with Docker on the Mac

(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...

SHUTDOWN SQL Server

I explore the question of if it is possible to reboot the server from within SQL Server or even simply shut down the entire server. Well, you can certainly...

SQL Homework – December 2018 – Configure SSMS

I’ve committed to posting a piece of homework for you to do each month. I post at the beginning of...

Three tips to help your database team avoid burn out this holiday season

As you’re enjoying the festivities this month, spare a thought for your database administrators and IT teams. It’s one of the busiest and most stressful times of the year...

Three tips to help your database team avoid burn out this holiday season

As you’re enjoying the festivities this month, spare a thought for your database administrators and IT teams. It’s one of...

Updating SSMS to 17.9.1

I went to download the SSMS v17.9.1 package the other day and saw this:

I remember some issues with a C++...

Where do data breaches come from?

I recently did a bit of research on the source of data breaches. In this post, I’ll talk a bit about my current favorite source for breach information, and...

Failovers can’t serve two masters

As I’m sure you’re aware, the career path for a SQL Server DBA is a wonderful journey of growing your catalog of knowledge through unexpected lessons. For example: Did...