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 rodcolledge.com, 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!
Whilst it may be more exciting as a DBA to rush around fixing broken databases, it is far better to forestall problems by making sure that your servers conform with best-practices. It is even better if you can also manage your servers centrally, and monitor that they are all adhering to company policies.… Read more
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
Rod Colledge turns his pessimistic mindset to storage systems, and describes the best way to configure the storage systems of SQL Servers for both performance and reliability. Even Rod gets a glint in his eye when he then goes on to describe the dazzling speed of solid-state storage, though he is quick to identify the risks.… Read more
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