A visual walk through to configure Management Data Collection in a few quick steps and get default reports on CPU, memory and disk for your server.
Watching the tempdb Version Store
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.