Rod Colledge

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 is the founder and operator of sqlCrunch.com, 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!

Follow Rod Colledge via

12 May 2010
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
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