Give a developer lock-wait data without handing over a server-wide permission. A signed procedure carries the authority, and an edit takes it away.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Checking for SQL Server Dump Files After a Crash
Did the server really crash, or just restart? Here is how to list dump files, read the error log and protect the evidence before anyone cleans up.
Where a Business Rule Should Actually Live
Place the business rules database applications depend on in constraints, procedures, triggers, or application code according to their guarantees.
Learning from People: Conferences, Meetups and Mentors
Learning from people is how a craft travels. Conferences, local meetups and mentors teach what no course can: questions, mistakes and the hallway conversations between sessions. Here is how to get real value from each one.
SQLAuthority News – Milestone – 1900th Post and 31 Million Views – Thank You!
My 1900th Post and 31 million views in almost 5 years. To celebrate, a fun FAQ my wife Nupur wrote, like why I started this blog and what it was first called.
Spotting tempdb Contention
Spot tempdb contention through PAGELATCH waits and allocation pages, then review file layout and current server settings before changing files.
Blocking DELETE Without a WHERE Clause Using a Trigger
A trigger cannot read your statement, but it can count the rows that vanish. Here is a guard that stops a runaway delete, and where it falls short.
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.