Startup stored procedures run every time SQL Server starts, which makes them useful and easy to forget. This post covers good uses, the risks, a wait that gives up instead of looping forever, and how to list and remove the startup stored procedures already on a server. The setup steps are in a separate post.
How Old Version of SQL Server Running on Server? – Interview Question of the Week #183
Is your server on an old version of SQL Server? Run SELECT @@VERSION to see the build and the date the patch was created, a check I often run during a Health Check.
SQL SERVER – Backup to URL – Script to Generate Credential and Backup using Shared Access Signature (SAS)
Backup to URL can connect to Azure storage with a SAS token. I share a script that generates the credential and the backup command using a Shared Access Signature.
SQL SERVER – Execution Plan Ignores Tabs, Spaces and Comments
Many teams skip comments in stored procedures, fearing bigger execution plans. My demo shows SQL Server ignores tabs, spaces and comments when it builds a plan.
SQL SERVER – Puzzle – Why Such a Complicated Execution Plan for a Single Row, Single Table Query?
A simple puzzle: why does SQL Server show such a complicated execution plan for a single row, single table query on WideWorldImporters? Try to solve it.





