February 2007 - Posts

• CHECKDB, User Groups and .NET Rocks!

  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 2.8TB. Read More... Posted Wednesday, February 28, 2007 6:38 AM by Paul Randal - MSFT | 3 Comments Filed under: General

• SQL Server 2005 Best Practices Analyzer CTP released

  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 Analyzer Read More... Posted Thursday, February 22, 2007 12:44 PM by Paul Randal - MSFT | 1 Comments Filed under: General

• TechEd interview video

  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. Read More... Posted Friday, February 16, 2007 1:25 PM by Paul Randal - MSFT | 1 Comments Filed under: TechEd 2006

• Wow - over 40 blogs from the SQL Product Team

  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 Read More... Posted Wednesday, February 14, 2007 10:47 AM by Paul Randal - MSFT | 8 Comments Filed under: General

• How is Books Online put together?

  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-books-online.aspx Read More... Posted Wednesday, February 14, 2007 9:49 AM by Paul Randal - MSFT | 1 Comments Filed under: General

• How to move databases using detach/attach functions?

  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 Read More... Posted Wednesday, February 14, 2007 5:39 AM by Paul Randal - MSFT | 2 Comments Filed under: General

• How long does *your* CHECKDB take?

  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 Read More... Posted Tuesday, February 13, 2007 4:29 AM by Paul Randal - MSFT | 4 Comments Filed under: DBCC, DBCC CHECKDB Series

• Three upcoming events in March to learn about HA/DR and DB Maintenance

  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, UK Read More... Posted Tuesday, February 13, 2007 2:58 AM by Paul Randal - MSFT | 1 Comments Filed under: Conferences 2007

• CHECKDB (Part 8): Can repair fix everything?

  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 Read More... Posted Sunday, February 04, 2007 4:53 PM by Paul Randal - MSFT | 3 Comments Filed under: DBCC, Disaster Recovery, DBCC CHECKDB Series, On-Disk Structures