A weekly review beats a daily to-do list because it shows seven days of work at once. This post borrows the rolling window from SQL to show how to look back, look ahead and choose up to four outcomes. It ends with a checklist you can try this week.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – What is SQL Server Operating System?
What is the SQL Server Operating System, or SQLOS? An attendee spotted SOS waits after reading my wait stats book, and here is my simple explanation.
SQL SERVER – Understanding SQL Server Setup Support Rules for Cluster Nodes
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 – 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.
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.