SSMS 2008 lets DBAs run one query against many servers from one window. Here is how multi-server queries work, a tip from my TechEd India session.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Effect of Normalization on Index and Performance
Normalization organizes data dependencies, while indexes support access paths. I evaluate their performance effects through the actual workload.
SQL SERVER – 2008 – Customize Toolbar – Remove Debug Button from Toolbar
SQL Server 2008 brought the debugger back, and its button sits right next to Execute. Here is how to customize toolbar buttons and remove the debug button.
No Join Predicate: Verify the Relationship Before Tuning
No join predicate prompts a relationship check. Compare all combinations with exact customer-order pairs before changing indexes or hiding duplicates.
SQL SERVER – Performance Counters from System Views – By Kevin Mckenna
SQL and .NET expert Kevin Mckenna, whom I met on Twitter, shows how to read SQL Server performance counters from system views.
Preventing Overbooking When Two Sessions Grab the Last Seat
Learn preventing overbooking through a last-seat race, an atomic update, update locks, and a database constraint that rejects oversold inventory.
Errors TRY CATCH Cannot Catch: Compile, Name and Severity Errors
Learn which errors TRY CATCH cannot catch, test execution scopes safely, and pair transaction cleanup with caller timeout handling.
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.