Plan sharding by customer with a shard map, parameterized routing and synonyms, and account for reports, keys and customer moves.
Writing T-SQL With an AI Assistant: What to Check Before You Run It
Review T-SQL from an AI assistant for real columns, safe writes, index access, date boundaries, isolation, and rollback tests.
Why Opening an MDF File Directly Goes Wrong
Before you attach MDF file copies, check SQL Server versions, service permissions, and missing files, then choose a safer restore or attach path.
AutoRecover Settings in SSMS: Protect Your Unsaved Queries
The AutoRecover settings in SSMS decide how often unsaved work is copied to disk and how long the copies are kept. This post shows where to find the two options, what they can and cannot protect, how to test them once, and which habit still matters more than any setting.
SQL SERVER – UNION ALL and ORDER BY – How to Order Table Separately While Using UNION ALL
Two ORDER BY clauses in a UNION ALL give Msg 156. Here is how to use UNION ALL and ORDER BY together to sort the top and bottom sets separately.
Server Configuration as Code
Configuration as code keeps SQL Server instance settings in reviewed scripts, with environment values, drift checks, and repeatable application.
SQLAuthority News – Who I Am And How I Got Here – True Story as Blog Post
People ask me for the secret to success. At John Sansom’s invitation, I wrote the true story of who I am and how I got here.