Store an idempotency key with its order in one transaction, return the committed result on retries, and define key reuse and expiry rules.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
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 – Query Plan Analysis of Pivot and Unpivot with Profiler of dbForge Studio for SQL Server
The VALUES clause does much more since SQL Server 2008. Here is a Query Plan Analysis of PIVOT and UNPIVOT queries using the profiler in dbForge Studio.
SQL SERVER – Tools for Proactive DBAs – Policy Based Management – Notes from the Field #012
Worried about your database while on vacation? John Sterrett shows how Policy Based Management helps a proactive DBA catch unwanted changes.
SQL Server slow? Let's fix it together in about four hours.
In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.
You keep every script, and the know-how to fix it yourself next time.
Want your whole team to learn it?
My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.
Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.