SQL Server Removing Duplicates

I know, I know your data could never possibly have duplicates because obviously, you have all the constraints in place...

Do 75% of data breaches really come from “insiders”?

There’s a lot of information out there on data breaches. I’ve written before about one source that I trust — the Verizon Data Breach Report (DBIR). The 2018 DBIR...

AzCopy finally gets a sync option, and all the world rejoices

I consider Blob Storage to be the gateway drug to Azure, because it’s a really easy way to get going...

Make sure your nonclustered indexes are enabled

I know this post might sound obvious. This is a very rare problem. But this actually happened to me, and...

Versions and Patches in SQL Monitor

SQL Monitor has grown from a basic alerting system to an amazing product over the years. From it’s early days...

SQL Homework – January 2019 – Baselines

Happy New Year! Every year for New Years we all make a big deal of coming up with New Years...

Checking your Memory with XE

It is well known and understood that SQL Server requires a substantial amount of memory. SQL Server will also try to consume as much memory as possible from the...

Checking your Memory with XE

It is well known and understood that SQL Server requires a substantial amount of memory. SQL Server will also try...

Visualizing Hash Match Join Internals And Understanding Their Implications

This post is part 3 in a series about physical join operators (be sure to check out part 1 – nested...

Visualizing Hash Match Join Internals And Understanding Their Implications

This post is part 3 in a series about physical join operators (be sure to check out part 1 - nested loops joins, and part 2 - merge joins).

Watch...