Someone changed a setting and nobody admits it. Here is what the SQL Server error log keeps, and what it never records.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – FIX: sp_rename error Msg 15225 – No item by the name of ‘%s’ could be found in the current database
Msg 15225 is a common sp_rename error: No item by the name could be found in the current database. Here is why it happens and the fix.
SQL SERVER – Someone was trying to hack my SQL Server Logins in Azure!
I noticed failed login errors on my Azure VM. Someone was trying to hack my SQL Server logins in Azure. Here is what I found and fixed.
Interview Question of the Week #052 – Print String in Reverse Order
An interview question: how do you print a string in reverse order in SQL Server? Here is how the candidate solved it, with the script.
SQL SERVER – Script: Finding Cumulative IO Per Database File
A simple script to find cumulative IO per database file in SQL Server, and the real scenarios where this number helps you.
SQL SERVER – FIX: SQLServerAgent is not currently running so it cannot be notified of this action. (Microsoft SQL Server, Error: 22022)
Error 22022 says SQLServerAgent is not currently running so it cannot be notified of this action. Here is what causes it and how to fix it.
SQL SERVER – Are You Suffering from Unknown SSAS Performance Challenges? – Notes from the Field #109
Bill Anton explains how to tell if your app suffers from unknown SSAS performance issues, and why Analysis Services need not be a black box. Notes from the Field #109.
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.