Adaptive Joins

I was surprised to find out that a lot people hadn’t heard about the new join type, Adaptive join. So,...

GDPR: Your Hair Is Not On Fire

Along with a lot of other people, I’ve been attempting to call people’s attentions to the new General Data Protection...

Building Culture

The origins of PASS have shaped its culture for years. Are you doing the same in your organization?

Wait Statistics on a Query

Wait statistics are a vital part of understanding what is causing your system to run slowly. Capturing them can be...

Database Fundamentals #16: Removing Data With T-SQL

Deleting data from a table using T-SQL works quite a lot like the UPDATE statement.

How it Works
In the same way...

Youtube Channel Update

Hello,
I just wanted to take a moment to promote the work I’ve been doing with the YouTube Channel.
I’ve published four...

Getting Started in a SQL Server 2017 VM in Azure

You say you’re ready to dip your toes in the Azure ocean? Come on in, the water’s fine!
Oh, you want...

You Need a New Hobby

Not sure who this is that is attempting to hack into my blog so desperately, but seriously, time for a...

It's an Exciting Time

I read a lot of history (as you no doubt notice from my other editorials). I’m currently reading an excellent book on the air war in World War One, Marked for Death: The First War in the Air. One of the fascinating aspects of the war is just how fast the technology shifted. At the […]

Statistics Use, Extended Events and Execution Plans

Query tuning ain’t easy.
Figuring out which index is getting used is one step, and generally simple, look at the execution...