A DBA friend wanted to see the trace flags enabled on his production servers. Here is how to find them easily, and a word of caution about using them.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Why my Database is in Restoring Mode After Taking Backup?
Pepper, a SharePoint consultant, asked why her database is in restoring mode after taking a backup. Here is the story and the answer.
Database Maintenance Checklist: Daily, Weekly and Monthly
A database maintenance checklist keeps the dull checks from slipping. This post lists what to check daily, weekly and monthly in SQL Server, with one small read-only query for backups, errors, free space, CHECKDB, statistics, growth, logins and patch level.
SQL SERVER – Answer to Puzzle – ISNUMERIC and Unexpected Results
The answer to my ISNUMERIC and Unexpected Results puzzle: I passed a TAB character and it returned 1. Here is what readers and MSDN say about it.
SQL SERVER – Beginning Table Valued Constructors – Notes from the Field #052
Kathi Kellenberger explains Table Valued Constructors, a relatively unknown topic, in the 52nd episode of my Notes from the Field series.
ISNUMERIC Puzzle: SQL in Sixty Seconds #076
The ISNUMERIC puzzle hides a tab character. Tests on SQL Server 2025 show which strings pass ISNUMERIC but fail TRY_CONVERT, how an empty string and a lone minus sign convert to 0, and how to find control characters in imported data with a short query.
Audit Triggers That Record the Real User Behind EXECUTE AS
Your audit table says dbo for every change, and nobody can tell who really did it. Here is how to capture the person behind EXECUTE AS.
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.