A Twitter DM asked me the effect of normalization on indexes and performance in 140 characters. My one tweet answer, and a longer look at what it means.
SQL SERVER – 2008 – Customize Toolbar – Remove Debug Button from Toolbar
SQL Server 2008 brought the debugger back, and its button sits right next to Execute. Here is how to customize toolbar buttons and remove the debug button.
SQLAuthority News – Registration and Competition – TechEd on Road – Ahmedabad – June 20, 2009 Saturday
Join TechEd on Road in Ahmedabad on June 20, 2009, a free event to learn and network with tech lovers, plus a fun contest with gifts to win.
SQL SERVER – Performance Counters from System Views – By Kevin Mckenna
SQL and .NET expert Kevin Mckenna, whom I met on Twitter, shows how to read SQL Server performance counters from system views.
Preventing Overbooking When Two Sessions Grab the Last Seat
Learn preventing overbooking through a last-seat race, an atomic update, update locks, and a database constraint that rejects oversold inventory.
Errors TRY CATCH Cannot Catch: Compile, Name and Severity Errors
Learn which errors TRY CATCH cannot catch, test execution scopes safely, and pair transaction cleanup with caller timeout handling.
Your First Extended Events Session
Build your first Extended Events session for slow SQL calls, choose a bounded ring buffer or file target, and read the captured result.