Tag: T-SQL
31.01.2023
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…
17.01.2023
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…
20.12.2022
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…
09.12.2022
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…
02.03.2021
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.
Latest Posts
Categories
Archives
Latest Comments
Good stuff! Also, I think that accessing the server through DAC , would have worked
Sorry for the late reply. I took a break from the blog for a couple of months. Can you please…
Not sure what I did wrong but when I executed the Powershell .\psblitzl.ps1 wsfpv02342\mstqip05 -checkdb hgxcore I got the following…
Hi Leo, Thank you for your input! Regarding exporting and importing settings: It's doable, and that's why I change the…
Thank you! Yes, DAC would be a viable alternative to starting the instance in single user mode. The only thing…