June 2007 - Posts

• TechEd session video available...

  The session I gave at TechEd this year on 'Secrets of Fast Detection and Recovery from Database Corruptions' was videotaped as part of the Its Showtime! TechEd program. The video is now available to watch at http://www.microsoft.com/emea/itsshowtime/sessionh.aspx?videoid=549 Read More... Posted Wednesday, June 27, 2007 5:16 PM by Paul Randal - MSFT | 0 Comments Filed under: Disaster Recovery, DBCC CHECKDB Series, Conferences 2007, Service Level Agreements, VLDB Maintenance

• What happens to non-clustered indexes when the table structure is changed?

  Here’s a topic that’s cropped up several times during Q&As at TechEd this year – what happens to non-clustered indexes when changes are made to the underlying table? Are they always rebuilt or not? Before we get into that discussion, I’ll give you Read More... Posted Thursday, June 07, 2007 9:52 AM by Paul Randal - MSFT | 9 Comments Filed under: VLDB Maintenance

• Database mirroring questions from TechEd: failovers and partner timeouts

  This year at TechEd there's been even more interest in database mirroring than last year - Kimberly's Always-On Demo-Fest yesterday had a whole bunch of questions during the first demo on mirroring and 50% of the booth questions I've answered have been Read More... Posted Wednesday, June 06, 2007 12:20 PM by Paul Randal - MSFT | 1 Comments Filed under: Database Mirroring

• Katmai == SQL Server 2008 == available to start playing with!

  Very exciting!!! On Monday at TechEd we announced the official name of the next version of SQL Server - Microsoft SQL Server 2008 and released the first public CTP (Community Technology Preview) of it for people to start playing with and evaluating. Here Read More... Posted Tuesday, June 05, 2007 7:27 AM by Paul Randal - MSFT | 1 Comments Filed under: SQL Server 2008

• SQL Server's 'black-box' flight recorder

  So I learned something about SQL Server at TechEd today. In Kimberly and Bob Beauchemin's pre-con, Kimberly mentioned that SQL Server has a 'black-box' trace, similar to an aircraft flight-recorder, which I'd never heard of. It's an internal trace that Read More... Posted Sunday, June 03, 2007 10:46 AM by Paul Randal - MSFT | 9 Comments Filed under: Disaster Recovery

• The Ins and Outs of Offline Files

  First blog post of the year from TechEd! Well, Kimberly and I arrived a day early hoping to chill out in the sun by the pool but contrary to all expectations the weather sucks today – it’s actually much better in Seattle. Instead we're hibernating in Read More... Posted Saturday, June 02, 2007 12:35 PM by Paul Randal - MSFT | 1 Comments Filed under: Disaster Recovery, Backup, Restore Attachment(s): offlinefile.sql