Compare index vs unique constraint behavior, test filtered uniqueness and NULLs, inspect catalog flags, and remove each object correctly.
SQL SERVER – Trick – Running SSMS With Different Windows Account
Many admins have a regular and an admin login. Instead of logging off, here is a trick for running SSMS with a different Windows account on the same desktop.
SQL SERVER – Database Testing and Waitfor Delay – Notes from the Field #099
Kevin Hazzard shows how WAITFOR DELAY helps with database testing, like mocking procedures that simulate client data for ETL. Notes from the Field #099.
SQL SERVER – Why Should You Not to Use Old Style JOIN?
You can join tables with ANSI INNER JOIN or the old style JOIN in the WHERE clause. Here is an example that shows why you should avoid the old style JOIN.
SQL SERVER – SSMS Query Command(s) completed successfully without ANY Results – Part 2
Every query in SSMS showed Command(s) completed successfully but no results. Here is the SSMS option I had changed that caused it, in part 2 of this story.
Backup to Azure Storage in SQL Server: Steps With a Container SAS
Backup to Azure Storage uses BACKUP TO URL to write a SQL Server backup straight to a blob. My original example used a storage account key. This version uses a container SAS and block blobs, with a new blob name for every backup, and I tested the local steps on SQL Server 2025.
SQL SERVER – Creating a Database Administrator Group Using User-Defined Server Roles
Can you give someone near DBA rights without full sysadmin access? Here is how to create a database administrator group using user-defined server roles.