MVP Open Day 2008 in Goa, Day 2: technical sessions, Community Buzz, a river cruise, and photographs with fellow MVPs. Read the original account and follow the rest of the Goa event series.
SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Day 1
MVP Open Day 2008 in Goa, Day 1: the journey, Windows 7 demonstration, Goan-themed evening, and photographs from Hotel Kenilworth Resort. Read the original account and follow the rest of the Goa event series.
SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Link List
South Asia MVP Open Day 2008 in Goa: the November 15 to 17 agenda, technical sessions, community activities, and links to all seven event posts. Read the original account and follow the rest of the Goa event series.
SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa
South Asia MVP Open Day 2008 in Goa: my first Open Day after the MVP award, plans for the visit, and a chance to meet fellow community members. Read the original account and follow the rest of the Goa event series.
Reading the Default Trace
Reading the default trace can reveal recent object and configuration changes while its rolling files still retain the evidence.
Baselines: Knowing What Normal Looks Like
Build a SQL Server baseline with timestamped workload, wait, and IO samples so you can compare a slowdown with a similar period of normal work.
SQL SERVER – Delete Backup History – Cleanup Backup History
SQL Server keeps backup history in msdb forever. Use sp_delete_backuphistory to delete backup history older than 30 days, or any number you pick.