Tag: SQL Server
26.04.2023
Fixing SQL Server connection errors 64 and 233
In the past couple of weeks I’ve ran into a few situations where users working on development instances…
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…
06.12.2022
PSBlitz – 2.1.0 update
Version 2.1.0 of the PSBlitz SQL Server diagnostics collection and output tool brings bug fixes, quality of life…
15.11.2022
Getting the sysadmin role via trustworthy database
In SQL Server, members of a database’s db_owner role can end up getting membership in the sysadmin server…
28.10.2022
Setting up an Ubuntu VM for SQL Server 2019 and 2022
In this post I’ll outline the process of setting up an Ubuntu Server VM in Oracle VirtualBox for…
20.10.2022
What is dbo, anyway?
The dbo schema and user pair tend to be a source of confusion, especially for people who come…
06.10.2022
Cracking SQL Server login passwords online
In a previous post we’ve looked at offline methods of cracking SQL Server login passwords as a means…
Thank you! Yes, DAC would be a viable alternative to starting the instance in single user mode. The only thing…