A common question I get: how do you go about detecting low disk space on SQL Server? Here are two ways, including xp_fixeddrives, and the one I prefer.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
A Crossword Helper in T-SQL: Matching Word Patterns With LIKE
Match word patterns with LIKE and SUBSTRING, build sorted-letter anagram signatures, and use a leading-letter index for crossword searches.
Adding System Versioning to a Table That Already Has Rows
Turning on temporal history for a table that already has data does not rebuild the past. Here is the clean way to do it, and the traps to avoid.
SQL or NoSQL for a New Project
Choose SQL or NoSQL for a new project by testing data shape, consistency needs, query patterns, and the skills the team can operate.
Profitable Blog: How a Technical Blog Pays for Itself
A profitable blog starts with readers who trust the writer. This post shows how a technical blog pays for itself through ads, consulting and books. It ends with a short checklist for your own blog.
Rewriting OR Conditions So the Index Gets Used
Rewrite OR conditions with separate seeks, preserve duplicate and NULL behavior, and compare plans before choosing UNION or recompilation.
SSRS Parameters That Do Not Slow Reports
SSRS parameters work best with selective defaults, compact value lists, and SQL queries that preserve useful indexes under real filters.
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.