SharePoint in a SQL Server environment

A few weeks back I kicked off a survey asking whether you have SharePoint in your SQL Server environment at all. Here are the results:   The "Other" responses were: 3 x "Not now but I did in a previous role." 3 x "Yes, but the dbas do not manage their servers." 2 x "SharePoint 2007 […]

Survey: do you have SharePoint in your SQL environment?

This question came up on the #sqlhelp tag on Twitter today, and it's something I'm interested in too: what percentage of SQL Server environments include SharePoint somewhere too? This is interesting because it has implications for standardization of SQL Server maintenance and HA/DR procedures across your company. If you don't have SharePoint, please take 5 […]

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 […]

TechNet Magazine: March 2011 SQL Q&A column

The March edition of TechNet Magazine is available on the web now and has the latest installment of my regular SQL Q&A column. This month's topics are: Using I/O and wait statistics Missing index analysis Smoothing relations between DBA and dev teams Page splits, fill factor and SharePoint  Check it out at

Paul and Kimberly interview from MVP Summit

For about 6 months we'd bee trying to hook up online with SharePoint MVP Hilton Geisenow for an interview but unfortunately the bandwidth to South Africa is pretty limited so we decided to wait until the recent MVP Summit in Redmond, WA. We managed to hook up and record an interview for Hilton and he's just published […]

Measuring ‘churn’ in a SharePoint content database using SQL Server

After teaching some of the MCM-SharePoint class last week, one of the attendees pointed me at a blog post about measuring churn in SharePoint databases. The poster gave code to measure how large full backups are, which really only measures how much data there is in the database, not whether existing data has changed. If […]

Microsoft Certified Master – Database AND Sharepoint

As you may know, Kimberly and I teach (and wrote) the first week of the 3-week Microsoft Certified Master – Database qualification. From next week onwards, we'll each also be teaching a day of the Microsoft Certified Master – Sharepoint certification too, as SQL experts. As such, we'll be learning a lot about how SQL […]

Couple of LOB corruption bugs fixed in the latest CUs for 2005

Both 2005 SP3 CU2 and 2005 SP2 CU12 contain fixes for two bugs that cause corruption in LOB data. The first bug may happen when a column type is converted to varbinary(max), change the large-value-types-out-of-row option to true, insert a row, and then try to update it – described in KB 961648. The second bug […]