What to record before tuning a slow query starts with the original execution. Keep its SQL, inputs, connection settings, measurements, and plan together before testing a change.
Interview Question of the Week #043 – What is the Difference Between EXCEPT operator vs. NOT IN
Compare EXCEPT operator vs. NOT IN using NULL and duplicate examples, add NOT EXISTS, and inspect actual SQL Server anti-join plans.
SQL SERVER – To Find Events Mapped to Channels in Extended Events
How exhaustive are Extended Events compared to Profiler? A DBA asked me, so here is how to find events mapped to channels in Extended Events.
Backup to Azure Storage in SQL Server: Steps With a Container SAS
Backup to Azure Storage uses BACKUP TO URL to write a SQL Server backup straight to a blob. My original example used a storage account key. This version uses a container SAS and block blobs, with a new blob name for every backup, and I tested the local steps on SQL Server 2025.
Putting a Database Under Source Control
Putting a database under source control starts with state or migration scripts, consistent object files, and a reviewable first commit.







