What is SQL Azure? A simple introduction to Microsoft’s cloud database, why it is mostly a branding change, and why it appeals to SQL Server users.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
SQL SERVER – SQL Server Express – A Complete Reference Guide
A complete reference guide to SQL Server Express: what it costs (it is free), when to use it over the full version, and its maximum database size.
ISO Week Numbers vs DATEPART(week): Grouping Sales by Week
Group sales by ISO week and ISO year, compare DATEPART week behavior, and avoid New Year errors caused by session settings.
SQL SERVER – Index Seek vs. Index Scan – Difference and Usage – A Simple Note
Index seek vs. index scan: the two ways SQL Server reads data through an index, how they differ, and when each one is used. A simple note.
Raising a Database Compatibility Level Safely
Raise a compatibility level safely by capturing a Query Store baseline, changing one database, comparing plans, and keeping a tested reversal.
sys.objects, sys.all_objects and sys.system_objects
Compare sys.objects, sys.all_objects and sys.system_objects to find SQL Server user objects, system objects, and metadata visibility gaps.
SQL SERVER – Get Query Plan Along with Query Text and Execution Count
A handy script that shows each query’s text, its execution count and its query plan, so you can see what runs most often on your server.
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.