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 [...]
Paul S. Randal
In Recovery...
SharePoint 2010 database maintenance whitepaper
Posted on: July 26, 2011 8:52 am
Myths and misconceptions: 60-page PDF of blog posts
Posted on: October 19, 2010 5:39 am
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 [...]
Whitepaper on high-availability architectures published
Posted on: June 4, 2010 11:00 am
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 [...]
SQL Server 2008 High Availability whitepaper published on MSDN
Posted on: September 28, 2009 12:42 pm
The 35-page whitepaper on high availability I wrote for the SQL team over the summer has been published on MSDN. It's a 2-300 level whitepaper that describes the various high-availability technologies in SQL Server 2008 and how they can be used to mitigate disasters. It's chock-full of links to other whitepapers, technical articles and Books [...]
New whitepaper on SQL Server 2008 failover clustering
Posted on: July 23, 2009 5:04 pm
The SQLCAT team has published a very detailed (and very long) whitepaper on implementing failover clustering with SQL Server 2008. There are some major differences from 2000 and 2005 related to setup and SP/CU installs so this is worth reading even if you're experienced with 2005 failover clusters. You can download it from http://download.microsoft.com/download/6/9/D/69D1FEA7-5B42-437A-B3BA-A4AD13E34EF6/SQLServer2008FailoverCluster.docx and the link's [...]
SQL Server 2008 Data Compression whitepaper published
Posted on: May 29, 2009 12:59 pm
The SQLCAT team have published another excellent whitepaper – this time the long-awaited one on the SQL Server 2008 data compression feature. Thirteen people inside and outside Microsoft (including me) provided technical reviews and the authors (Sanjay Mishra along with Marcel van der Holst, Peter Carlin, and Sunil Agarwal) did a great job. I remember [...]
Are your disk partition offsets, RAID stripe sizes, and NTFS allocation units set correctly?
Posted on: May 13, 2009 4:29 pm
I've just been setting up some of our new hardware, and wanted to do some background reading to ensure I use the correct disk partition offset, RAID stripe size, and NTFS allocation unit size to enable the best possible performance for the volumes I'm creating. You may not of heard about this (or your disk [...]
Updated whitepaper: Troubleshooting Performance Problems in SQL Server 2008
Posted on: April 15, 2009 11:49 pm
Microsoft's popular performance troubleshooting whitepaper has been updated for SQL Server 2008. You can download Troubleshooting Performance Problems in SQL Server 2008 at http://download.microsoft.com/download/D/B/D/DBDE7972-1EB9-470A-BA18-58849DB3EB3B/TShootPerfProbs2008.docx. I've also added it to our whitepaper-links collection page at http://www.sqlskills.com/whitepapers.asp.
New whitepaper on tuning Change Data Capture performance
Posted on: February 15, 2009 2:12 pm
Microsoft’s Steffen Krause has written an excellent whitepaper on Tuning the Performance of Change Data Capture in SQL Server 2008, that I technically reviewed, and it was published late last year. To get an overview of Change Data Capture (CDC) before reading the whitepaper, see the TechNet Magazine article I wrote for the November issue, [...]
New whitepaper on database snapshots
Posted on: February 15, 2009 1:57 pm
Well, it was released a year ago but I only just found out about it last week. The SQL CAT team published a whitepaper last year called Database Snapshot Performance Considerations under I/O-Intensive Workloads. For a variety of workloads and with different numbers of concurrent database snapshots, it covers: How much time does it take to create a [...]
SQL Server 2008 FILESTREAM whitepaper published on MSDN
Posted on: October 10, 2008 4:35 pm
Just found out that the 25-page FILESTREAM whitepaper I wrote recently for the SQL team has been published on MSDN. You can get it at http://msdn.microsoft.com/en-us/library/cc949109.aspx. Enjoy! Here's the table of contents. Introduction Choices for BLOB Storage Overview of FILESTREAM Dual Programming Model Access to BLOB Data When to Use FILESTREAM Configuring Windows for FILESTREAM [...]
SQL Server2008: New whitepaper on combining transactional replication and database mirroring
Posted on: September 2, 2008 8:05 pm
I just heard today that the first whitepaper I’ve written for Microsoft has been published! The abstract is: SQL Server Replication: Providing High-Availability using Database Mirroring This white paper describes how to use database mirroring to increase the availability of the replication stream in a transactional environment. It covers setting up replication in a mirrored [...]
