Photographs from my wedding day on December 12, 2008, the same day as my 800th article. Meet Nupur, whom one reader kindly called Mrs. SQLAuthority.
SQL Server emergency? Email pinal@sqlauthority.com with URGENT in the subject line.
Which SSMS Version Can Connect to Which SQL Server Version
Choose an SSMS version for your SQL Server targets, check client and engine builds, and handle newer encryption defaults.
Percent Change Between Rows: Handling Zero and NULL Safely
One zero month can kill a revenue report. Here is how to get percent change without errors or lies.
Breaking Ties Deterministically: Why ORDER BY Needs a Tie-Breaker
Tied scores can come back in any order, which breaks paging. Here is the one column that fixes it.
Updating a Large Table in Batches With a Moving Key Range
Walk the clustered key a slice at a time, log each batch, and learn why stopping at the first empty batch quietly leaves rows behind.
An Upgrade Checklist That Fits on One Page
An upgrade checklist that fits on one page keeps before, during, and after checks visible, including backups, logins, jobs, clients, and rollback.
Designing a Database for Multiple Customers
A database for multiple customers can share tables, split schemas, or split databases; the choice balances isolation and operating cost.
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.