Change the color of status bar in SSMS 2008 for each server, so a query meant for development never runs on production by mistake. Step by step with images.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – Time Delay While Running T-SQL Query – WAITFOR Introduction
WAITFOR makes a T-SQL batch pause for a set time, or until a clock time, before the next statement runs. I show both uses with small examples.
SQL SERVER – 2008 – 2005 – Find Longest Running Query – TSQL
My company owner asked which query runs longest and I found no ready script, so I wrote one: the Longest Running Query with its average and maximum time.
Rolling Date Ranges Forward Without Hard-Coded Years
Replace hard-coded years with indexed date ranges for current periods, full months, year-to-date comparisons, and any requested year.
SQLAuthority News – Recap Year 2008 – Two Most Important Event of My Life
Recap year 2008: the two most important events of my life were my SQL Server MVP award and marrying Nupur on December 12. Happy New Year to all.
SQLAuthority Author Visit Report – Tech Meetings – Recession – Job Market – Consolidation of Servers
In this blog post, I will discuss various topics which are related to various DBAs and Developers discussed in the recent market.
Is a Certification Worth It, and What to Study Instead
Decide whether a SQL Server certification supports your next role, then build practical study projects around recovery, security, and tuning.
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.