Diagnose connection pool exhaustion by grouping SQL Server sessions, finding sleeping open transactions, and reading their last command.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Error 3241 on Restore: Newer Version or Damaged Backup File
Error 3241 only says SQL Server could not read the file as a backup. Here are three broken files, three different messages, and the checks to run first.
SQL SERVER – Bad Practice of Using Keywords as an Object Name – Avoid Using Keywords as an Object
Why using keywords as an object name is a bad practice: a stored procedure named GO runs with EXEC GO, and the result can surprise you.
SQL SERVER – Error: Deleting Offline Database and Creating the Same Name
Deleted an offline database but the disk is still full, or you get an error creating a database with the same name? Here is why, and what to do.
Statement Terminators: Where T-SQL Requires a Semicolon
Most T-SQL statements run fine without a semicolon, but a pasted CTE, THROW or MERGE will not. Here is how to read the error and fix the line above it.
What a Junior DBA Should Learn First
Build junior DBA skills around restores, permissions, blocking, and safe investigation, with a practical learning order and useful SQL checks.
Partitioned Views: Splitting a Table Without Table Partitioning
A view over yearly tables only skips the years it does not need while the CHECK constraints are trusted. Here is how to see it, break it and fix it.
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.