Restore a backup from an older SQL Server into a test database, read the upgrade messages, and check compatibility and integrity.
Keeping Personal Data Out of Test Databases
Keeping personal data out of test databases requires synthetic records or masking during refresh, plus verification before access.
SQLAuthority News – Author Visit – South Asia MVP Open Day 2008 – Goa – Group Photo
MVP Open Day 2008 in Goa: the group photograph shared by Allen Bailochan Tuladhar and memories of meeting friends in the MVP community. 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.
SQLAuthority News – 5 Millions Visitors – 2 Anniversary – Authors Note on Economy Slow Down and Job Opportunity – SQL Server
SQLAuthority.com crossed 5 million visitors and turned 2 years old. I also share my note on the economy slow down and job opportunity for SQL Server folks.
SQL SERVER – Clear Drop Down List of Recent Connection From SQL Server Management Studio
Is the SSMS connect drop down list full of old server names? Delete the mru.dat file for SQL Server 2005 or 2008 to clear it and start fresh.
Tracking Job Failures Across Servers
Tracking job failures across servers takes a daily msdb report, a central instance list, and notifications that reach someone who can act.