Your index rebuild maintenance plan runs every Sunday night, takes four hours, fills your transaction log, delays your backup, and may be buying you a great deal less than everybody assumes.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
AI Execution Plan Analysis: I Gave It My Plan and Asked What Was Wrong
I handed AI a plan with no warnings, where every number looked healthy and the query read five million rows to return seventeen. That is the real test of AI execution plan analysis.
Y2K: The Work Behind “Nothing Happened”
Y2K did not end in worldwide disaster. Its repairs, failures, and recoveries show why, and what database teams can learn about proving maintenance matters.
Fermat Left a Note in a Margin. Other People Spent 358 Years Finishing It.
That note kept mathematicians busy for the next three and a half centuries. Let us talk about what Fermat left in a margine.
Every Database Has These Seven Tables
You can walk into any company on earth, open the production database, and find the same seven tables. Different industry, different continent, different decade. The same seven tables.
NOLOCK Can Miss Rows: The Order That Was Never Missing
A row can vanish from your report while it is sitting safely in the table. Nobody deleted it. Nothing rolled back. The NOLOCK read simply walked past it.
Everyone Expected AI to Come From the Big Companies
Everyone expected AI to come from the big companies. They had the money, the data, the researchers and a twenty year head start. The research came out of those labs. The products did not, and the reason has very little to do with talent or budget.
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.