SharePoint 2010 database maintenance whitepaper

As you may know, I've been teaching the SQL Server portion of the SharePoint MCM since it started. The old database maintenance whitepaper for SharePoint 2007 had all kinds of things wrong with it and the publishing of the updated whitepaper for SharePoint 2010 was eagerly awaited by the community. Unfortunately it too had a bunch of problems so I offered to get involved and comprehensively review and rewrite it, and did so just before the summer.

It's finally been republished with all my revisions and you can download it from:


Myths and misconceptions: 60-page PDF of blog posts

Back when I did the DBA-Myth-A-Day series in April, many people asked for the 30 blog posts to be collected up into a document for easy printing/reading/etc. I promised, but never got around to it, until I had an email from a blog reader, Peter Maloof, who had very kindly done all the work of producing a Word doc with everything collected together. I’ve prettified the doc and produced a PDF which you can print out and redistribute as you see fit.

You can download the PDF once you sign up for our bi-weekly newsletter here (no advertizing or other nonsense), and once you’ve signed up, you can always get it from the past newsletters page (link in every newsletter). Note: some people get confused: when you complete the sign-up process, the final welcome email you get has the link to the prior newsletters and the PDF.

Make sure to also check out my 4-hour online training course on Pluralsight: SQL Server Myths and Misconceptions.


Whitepaper on high-availability architectures published

The 20-page whitepaper I wrote this Spring for the SQL team has just been published. This whitepaper is titled Proven SQL Server Architectures for High Availability and Disaster Recovery and ties in with the longer whitepaper I wrote last year on High Availability with SQL Server 2008 (see here).

This new whitepaper describes the five most commonly deployed high-availability and disaster-recovery architectures deployed by customers, along with a case study of each. It covers:

  • Failover Clustering for High Availability with Database Mirroring for Disaster Recovery
  • Database Mirroring for High Availability and Disaster Recovery
  • Geo-Clustering for High Availability and Disaster Recovery
  • Failover Clustering for High Availability Combined with SAN-Based Replication for Disaster Recovery
  • Peer-to-Peer Replication for High Availability and Disaster Recovery

You can get it from this link.


PS Checkout our 5-day class in Bellevue, WA in August – see here.