Watch the tempdb version store with per-database space DMVs, find transactions that delay cleanup, and plan capacity from trends.
Correlated Columns and Multi-Column Statistics in SQL Server
Investigate multi-column statistics with correlated city and state values, density vectors, and plans before expecting better estimates.
SQL Server Cheat Sheet
This is a post about a SQL Server cheat sheet, but not yet. First comes the history of the cheat sheet, from the first cave wall to the recipe card that cheats you, and the five laws every cheat sheet obeys. Then the new 2025 edition.
How to Give a Technical Demo That Doesn’t Break
A Technical Demo fails for a few predictable reasons, and most of them can be fixed before you start. This guide covers rehearsing on the exact machine, numbered scripts with a reset file, readable screens, an early room check, a recorded backup and what to say when something breaks live.
SQLAuthority News – Meeting with Allen Bailochan Tuladhar – An Unlimited Experience
My 9-day trip to Nepal with Allen Bailochan Tuladhar, who keeps Nepal’s tech community moving. Every day was a new lesson, truly an unlimited experience.
SQLAuthority News – Author Visit Review – TechMela Nepal – March 29-30, 2010
My review of TechMela Nepal in Kathmandu, March 29 to 30, 2010: around 500 students, hundreds of tech professionals and nine great days with Allen Tuladhar.
SQLAuthority News – Milestone of 1300th Post and A Few Updates
My 1300th post looks back at how SQLAuthority began as a list of personal bookmarks and scripts, and shares a few updates about the blog.