The top 5 new features of SQL Server Management Studio 2008, the tool that replaced Enterprise Manager and Query Analyzer, with upgrades DBAs asked for.
A Health Check for an Inherited Server
A health check for an inherited server reviews backups, access, configuration, error logs, and jobs before anyone changes the system.
Finding Sleeping Sessions That Still Hold Locks
Find sleeping sessions with open transactions, inspect their locks and last batch, and identify the application owner before ending work.
SQL SERVER – Clustered Index on Separate Drive From Table Location
A Jr. developer asked if a clustered index can live on a separate Drive from its table. The answer is no, and the clustered vs non clustered difference shows why.
SQL SERVER – Effect of Normalization on Index and Performance
Normalization organizes data dependencies, while indexes support access paths. I evaluate their performance effects through the actual workload.
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.
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.