SSMS keyboard shortcuts for execution, comments, results, and Object Explorer remove repeated clicks while keeping query context visible.
Idempotent Deployment Scripts: Safe to Run Twice
Build idempotent deployment scripts with guarded schema changes, versioned data fixes, and repeat-run checks for the intended state.
SQL SERVER – Virtualized SQL Server Performance and Storage System – Notes from the Field #013
Tuned everything in a VM and still slow? In Notes from the Field #013, David Klee explains Virtualized SQL Server Performance and the storage behind it.
Comparing Data Between Two Tables
Comparing data between two tables uses EXCEPT, full joins, and hashes, with explicit NULL and duplicate rules for trustworthy results.
Stopping Duplicate API Requests With an Idempotency Key Table
Store an idempotency key with its order in one transaction, return the committed result on retries, and define key reuse and expiry rules.
DOP Feedback: Letting SQL Server Lower Parallelism by Itself
Configure DOP feedback in SQL Server 2022, check Query Store evidence, and compare parallelism changes with your workload and MAXDOP limits.
SQL SERVER – Rename a Table Name Containing [ or ] Identifier in the Name – Part 2
Part 2 shows another way to rename a table name that contains [ or ] identifiers, after sp_rename fails with a Msg 15253 syntax error.
SQL SERVER – Rename a Table Name Containing [ or ] in the Name – Identifier in the Table Name
My colleague renamed a table to [] by accident and sp_rename failed. Here is how to rename a table name containing [ or ] characters.
Case-Insensitive and Multiline Regex Flags in SQL Server 2025
Your pattern passed the test string and then missed rows in the table. The flags and the line endings are the usual reason.









![SQL SERVER - Rename a Table Name Containing [ or ] in the Name - Identifier in the Table Name](https://blog.sqlauthority.com/wp-content/uploads/2014/01/renameerror2-600x200.jpg)
