Precons in Richmond, Philadelphia and New York

I love when I get the opportunity to present at SQLSaturday events. Even more than that, I love when I...

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...

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...

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...

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...

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...

Updated YouTube Channel

Hello all,
I’ve recently updated my YouTube channel. I’m going to be posting a lot more videos up there. If you...

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...

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...