Reduce backup success messages in the SQL Server error log with trace flag 3226, verify msdb history, and cycle logs safely.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Hunting Suspicious Objects After a SQL Server Compromise
Investigate a SQL Server compromise by preserving evidence and checking logins, startup procedures, Agent jobs, risky features, and changed objects.
SQL SERVER – Delete Duplicate Rows
Delete Duplicate Rows quickly with a CTE and ROW_NUMBER() in SQL Server 2005 and 2008. A sample table with 7 rows, 3 of them duplicates, shows how it works.
SQLAuthority News – TechEd on Road Ahmedabad June 20, 2009 – An Astounding Success
My recap of TechEd on Road Ahmedabad on June 20, 2009: 200+ attendees, people traveling from all over India, and two back to back SQL sessions.
A Health Check for an Inherited Server
A health check for an inherited server reviews backups, access, configuration, error logs, and jobs before anyone changes the system.
SQL Server – Understanding Table Hints with Examples – 2
A plain guide to understanding table hints in SQL Server: the three kinds of hints, what NOLOCK really means, and a checklist before you use one.
Finding Sleeping Sessions That Still Hold Locks
Find sleeping sessions with open transactions, inspect their locks and last batch, and identify the application owner before ending work.
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.