An UPDATE without WHERE clause changed 8,432 salaries. When ROLLBACK can help, and how to check the affected row count before COMMIT.
Ten AI Phrases We Use Too Often
In 2013 I wrote a small list of phrases developers used too often. Twelve years later, here are ten AI phrases I hear every week, and what each one means.
NOLOCK: Why It Counts Some Rows Twice and Misses Others
Everybody knows NOLOCK can show uncommitted data. Far fewer know why it counts some rows twice and misses others, with nothing rolled back. Let me show you.
Tech Conferences: Five Questions About the Money
I said tech conferences are worth every hour and the sessions are not. Nobody argued about the sessions. They wrote about money instead, and five questions arrived.
Finding the Root Cause of Slow Queries
Finding the root cause of slow queries starts by separating work from waits, then testing theories against plans and history.
Emoji Are Obsolete
Emoji are obsolete. There, I have written it. I do not entirely believe it.
A few days ago I wrote to a client: “We need to talk about the index strategy.”
The Job That Was Never There
The job that was never there is the hardest loss to explain. It came in messages from people who looked back and realised they had never quite had one.
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.