My SQL Server Management Studio 19 configuration
Since SQL Server Management Studio 19 has just been released last week, I’ve figured I’d take this opportunity…
Save execution plan files via PowerShell
In this post I’ll demo how to use PowerShell to retrieve execution plan files from a SQL Server…
Using ChatGPT to write T-SQL
I figured I might get ChatGPT to write T-SQL, test out the results, and see how it compares…
Getting away with multiple NULLs in a unique constraint
In this post I’ll go over the relationship between unique constraints and NULLs in SQL Server, and how…
T-SQL script to kill multiple sessions in one go
Ever needed a script to kill multiple sessions on your SQL Server instance, but still required some level of control over what was being targeted?
This script might come in handy.
Thank you! Yes, DAC would be a viable alternative to starting the instance in single user mode. The only thing…