Ponderings of PASS Summit 2016

Got back from Summit on Saturday and I’m still totally in the moment. I came back with so many new...

SQL Server Backup Compression

I thought that it would be handy to capture some Perfmon graphs of what happens to backup throughput and CPU...

This Week In Data – Episode 11 (Debunking Popular Cloud Myths)

Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...

Looking Back: #sqldinner at #sqlsummit 2016

Last week was the 2016 Pass Summit, and this was one of the few times that PASS did not provide...

Live 360–SQL in Orlando

I’ll be at the last big SQL Server conference in the US for 2016 this December. VS Live is a...

Why is SQL Server scanning the clustered index when I have an index on the column I am filtering on?

*Originally published in our old blog on January 2009

I ran into a very simple SQL Server performance related question the other day. A puzzled DBA was staring at a...

Why is SQL Server scanning the clustered index when I have an index on the column I am filtering on?

*Originally published in our old blog on January 2009

I ran into a very simple SQL Server performance related question the...

A Data Professional’s Story – PASS Summit 2016

This year is different. Why? I’m not sure yet. There is a lot of reflection going on since my return...

Query Store custom SSMS performance dashboard

As most of you might know, I am a big fan of the Query Store feature inside SQL Server 2016....

New indexes, hypothetically

I saw something like this the other day. My first thought was “Hu, never seen that before.” My second thought...