Monthly Archives: October 2011

Which DMV should I use?

Ever wondered which dynamic management view gives you information about xxxxx? e.g. you know that you want to find out which processes are currently blocking other processes (which was handled by the “blocked” column of “sysprocesses” in older SQL versions) … Continue reading

Posted in Developer stuff, SQL Stuff | Tagged , , , , , | Leave a comment

SQL Server Disaster Recovery

It’s all gone horribly wrong! You probably backup your system databases at least once a day and you doubtless test your user databases by restoring them elsewhere but do you test your system backups. You should but many people seem … Continue reading

Posted in SQL Stuff | Tagged , , , , , , , | Leave a comment