Rod Colledge is an independent SQL Server consultant based in Brisbane, Australia. He’s the author of SQL Server 2008 Administration in Action, was a technical editor on the SQL Server MVP Deep Dives book, writes for Quest and Simple-talk, is a frequent speaker at local SQL Server user groups, and received the SQL Server MVP award in January 2010. Rod blogs here at, is the founder and operator of, and was a highly rated speaker at the 2009 PASS summit in Seattle. He enjoys spending time with his young family, playing golf very badly, and pretending to taste the difference between a Pinot Gris and a Sauvignon Blanc!

12 May 2010

Reliable Storage Systems for SQL Server

By validating the IO path before commissioning the production database system, and performing ongoing validation through page checksums and DBCC checks, you can hopefully avoid data corruption altogether, or at least nip it in the bud. If corruption occurs, then you have to take the right decisions fast to deal with it. Rod Colledge explains how a pessimistic mindset can be an advantag… Read more
16 March 2010

Planning for Disaster

There is a certain paradox in being advised to expect the unexpected, but the DBA must plan and prepare in advance to protect their organisation's data assets in the event of an unexpected crisis, and return them to normal operating conditions. To minimise downtime in such circumstances should be the aim of every effective DBA. To plan for recovery, It pays to have the mindset of a pessimist. … Read more

Join Simple Talk

Join over 200,000 Microsoft professionals, and get full, free access to technical articles, our twice-monthly Simple Talk newsletter, and free SQL tools.

Sign up