Revisiting an Azure Managed Instance
If you’re considering moving to Azure from an on-prem SQL Server and need a complete SQL PasS offering, a Managed ...
Read more
Planting a Debug Flag in T-SQL
Are you looking for a way to debug stored procedures in SQL Server? Keep reading for a technique that’s worked ...
Read more
Required SQL Indexes
If you talk to any data professionals about query performance, they’ll bring up indexes in the first few minutes. For ...
Read more
Delete Duplicate Rows in T-SQL
We don’t live in a perfect world, which means duplicate rows occasionally show up. Sometimes you just need to delete ...
Read more
Storing Big Ugly Tables
Have you ever had a big ugly table? A table with millions or even billions of rows. Perhaps you wanted ...
Read more
Did You Google That?
One of my first jobs out of college was working in tech support. Comparable to retail, but customers were often ...
Read more