Search Engine Q&A #21: File header pages, and file header corruption

Following on from my previous post on boot pages and boot page corruption, I’ve been asked about file header pages – and I was already planning this post as the next in the series. So what’s a file header page? Every data file in a database has the very first 8kb page (i.e. page 0 […]

TechEd Online Panel Video: Building a Solid High-Availability Strategy

While we were at TechEd in June, Kimberly and I participated in an hour-long discussion panel (Leveraging SQL Server Technologies to Build a Solid High-Availability Strategy) that was video-taped by the TechEd Online folks. It’s now been edited and is available for download/viewing. We cover everything from requirements analysis to technology details in SQL Server […]

Search Engine Q&A #20: Boot pages, and boot page corruption

Now that I've done all the business-related blog posts, back to the good stuff to stop people complaining! Something that's cropped up a few times over the summer so far is people trying to repair boot page corruptions. First off, what's a boot page? Every database has a single page that stores critical information about […]

We’re writing a book – finally!

Well, almost… Kimberly and I have agreed to co-author the upcoming SQL Server 2008 Internals book with our good friend Kalen Delaney. This is the 2008 evolution of Kalen’s Inside SQL Server series of books and will be published by MS Press around February 2009. The other authors are (also our good friends) Adam Machanic […]

2008 Conferences: TechEd EMEA, SQL Connections, PASS Community Summit

  September, October, and November are going to be a whirlwind this year – after 3 weeks in the UK and Ireland in September, teaching and the San Francisco Power Workshop in October, we have three back-to-back conference weeks in Barcelona, Las Vegas, and back to Seattle! Hey – who booked that schedule?!?!?! Well, at least it helps us keep our […]

Dev Connections SQL Power Workshop on SQL Server 2008, October, San Francisco

People have been complaining that I’ve stopped blogging so much – vacation folks, vacation! Today I’ve got a few class and conference posts to get through and then I’ll get back to the technical posts. We’re doing a 2.5 day public class based on the SQL Server 2008 material we developed earlier this year. This will […]

TechNet Magazine: Effective Database Maintenance article and August SQL Q&A column

Well, we’re just back from vacation (photo blog post to follow) and I’ve heard that the feature article on Effective Database Maintenance I wrote for the August issue of TechNet Magazine is live on the web. It also includes a 5 minute long screencast I recorded where I demo the effect of database shrink on index […]