A few things to cover with the first cup of coffee this morning before doing a meatier post or two later today. First off - I've had a bunch of good responses to my CHECKDB runtime survey and I've got data on 66 databases ranging from 10.5GB up to...

Folks, The much-anticipated SQL Server 2005 Best Practices Analyzer has been released for on the Microsoft Download Center. There are a ton of things in there, including some checks around backup and CHECKDB frequency. SQL Server 2005 Best Practices...

Here 's a video of Adam Machanic interviewing me at TechEd in Boston last year - thanks to Chuck Boyce for filming and editing. (Hey - only 12 responses so far to the CHECKDB questions I asked in this post - I've got plenty of Hands-On labs DVDs left...

Seeing the new blog from the doc team inspired me to ping the extended SQL team to see what active blogs there are. Here's the list I've compiled of active (or "I'm working on content right now") blogs run by members of the SQL team - grouped by area...

One of the Technical Writers in the SQL Product Group, Buck Woody, has started a blog about SQL documentation. His first post is an overview of how Books Online is created. Check it out at http://blogs.msdn.com/buckwoody/archive/2007/02/14/sql-server...

Quickie post this morning. I was in a review of customer support cases yesterday lunchtime and noticed a trend of cases where people get into trouble moving databases around. There is a good KB article ( http://support.microsoft.com/kb/224071/ ) which...

Following on from my post a couple of weeks ago ( https://blogs.msdn.com/sqlserverstorageengine/archive/2007/01/24/how-long-will-checkdb-take-to-run.aspx ), I'm very interested to know how long it takes for your CHECKDBs to run, so I can get an idea of...

Things start early this year! I'm doing three events in March where I'll be speaking on HA/DR, internals and database maintenance, mostly partnering with Kimberly Tripp . Hope to see you at one of these! Tuesday March 6th One-day class in Reading...

I was teaching at a Microsoft-internal class last week and there was a discussion on what corruptions can't be repaired using DBCC. At the same time, several threads popped up on forums and newsgroups with people hitting some of this unrepairable corruptions...