What do the SQL Server setup support rules check when you build a cluster? My notes on the 11 Cluster Global Rules, and which ones are critical or optional.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Save and Send Execution Plan Via Email
A reader wanted to send a big graphical execution plan via email to a friend. Here is a quick step by step way to save it, and what to do if it is over 20 MB.
Interview Question of the Week #044 – What is the difference of performance between SELECT and SET?
What is the performance difference between SELECT and SET? SELECT can assign many variables at once, but how each handles rows matters more.
SQL SERVER – How to Suppress SQL Server messages in Application Event Log
A brute force attack on sa flooded the Application Event Log with login failures and alerts. Here is how to suppress SQL Server messages from going there.
SQL SERVER – How to Change SQL Server Product Key or License Key?
How do you change the SQL Server product key or license key on an installed instance? Here is what I learned from senior DBAs who manage 1000s of servers.
MySQL – Different Methods to Know MySQL Version
Three simple ways to find your MySQL version with SQL: @@version, the version() function and SHOW VARIABLES, plus why the server version matters.
Say No at Work Without Burning Bridges When You’re Over-Committed
To say no at work without burning bridges, queue the request instead of refusing it. This post borrows a busy server’s habit of holding requests in line with a clear wait time. You’ll get a short reply format, ways to offer options and a limit for the queue.
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.