A software vendor shipped SQL Express with Windows-only login by mistake. Here is how to change the authentication mode to mixed mode with a T-SQL query.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
HADRAG Error: Did Not Find the Instance to Connect in SqlInstToNodeMap Key
The HADRAG error ‘Did not find the instance to connect in SqlInstToNodeMap key’ kept an Always On availability group offline after unexpected failovers. The cluster log pointed to a metadata mismatch. Dropping the group on the secondary and recreating it brought it back.
SQL SERVER – Timeout Occurred While Waiting for Latch: Class FGCB_ADD_REMOVE
Latch FGCB_ADD_REMOVE timeouts mean a data file is growing slowly. Measured on SQL Server 2025: 4 GB of data in 98 ms, 4 GB of log in 2.3 seconds.
Comparing Old and New Values in a Trigger With inserted and deleted
Build a small audit trigger that joins inserted and deleted, handles NULL changes correctly and ignores saves that change nothing.
SQL SERVER – SQL Server Management Studio Crash While Using Backup to URL or Connecting to Storage
During an urgent restore, SSMS crashed each time my client picked URL to restore from Azure Blob Storage. Here is how to fix the crash when connecting to storage.
SQL SERVER – Event ID: 2004 – Resource Exhaustion Diagnosis Events
A client with SQL Server memory issues saw Event ID 2004, Resource Exhaustion Diagnosis Events, naming sqlservr.exe for low virtual memory. Here is what it means.
How to Change Language for SSMS? – Interview Question of the Week #194
How do you change language for SSMS? A workshop attendee asked me and I had to research it, but the steps are simple and start in the Tools menu.
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.