Hey there HA/DR Master Class Attendees! 

For you everything I demo'ed is in the VPC. However, the "USB" demo is slightly different in the VPC as you don't use USB drives. You shutdown SQL Server and rename the file to simulate the disaster. And, for the changes that I made to the "inching through the log demo" I've included those in this zip.

If there's something I've missed - please feel free to shoot me an email and I'll find whatever it might be! You can reach me at Kimberly@SQLskills.com.

As for where to find the scripts?

(**1**) The DVD
This is a VPC that requires either Virtual Server, Virtual PC, Hyper-V or VMWare. You can use it in ANY of these virtual environments so you can convert it to whichever one you are more comfortable! However, it's a bit of a resource hog as it requires 16GB of disk space and 1.5GB of dedicated memory. So... it's better on a larger machine!


(**2**) the demo scripts and HOLs
Demo Scripts outside of indexing are in Misc.

And, for some the 3 demos I performed during class - these are found within the following labs (marked with **):
Lab Name

**SQL Server 2008 Data Recovery and Preventative Techniques Hands-on Lab
This lab shows "inching through the log," "ddl triggers," and "tablediff"
      
      SQL Server 2008 Database Mirroring, Part I
      SQL Server 2008 Database Mirroring, Part II
      SQL Server 2008 Database Snapshots Hands-on Lab
      Understanding and Using DMVs Hands-on Lab
      SQL Server 2008 Instant Initialization

**SQL Server 2008 Online Operations Hands-On Lab
This lab shows converting to a partitioned table as an online operation and then what happens when a database has partial disaster with a failed drive.
      
      SQL Server 2008 Peer-to-Peer Replication Hands-On Lab
      SQL Server 2008 Resource Governor Hands-on Lab
      SQL Server 2008 Snapshot Isolation Hands-On Lab
      SQL Server 2008 Table Index & Partitioning Hands-On Lab
      Performance Data Collection in SQL Server 2008
      SQL Server 2008 Policy-based Management
      Understanding Command-line Management with SQLCMD in SQL Server Hands-on Lab
      SQL Server 2008 Service Oriented Database Architecture Hands-On Lab Manual
      SQL Server 2008: Synchronizing a Portable Database
      SQL Server 2008: Understanding Spatial Data Hands-on Lab
      SQL Server 2008: Using LINQ to SQL 
      SQL Server 2008: Using the Entity Data Model and LINQ to Entities
      SQL Server 2008: Using Visual Studio Team System 2008 Database Edition

In addition to the Labs, be sure to check out the "DEMO" directories. There are additional helpful scripts there that can show you features even outside of those we discussed.

For Partitioning - since it's such a challenging topic, here are the resources and the order in which I'd recommend going through them:
  (1) Start with the Partitioning Lab (specifically: SQL Server 2008 Table Index & Partitioning Hands-On Lab). It's nice to get the visual and the example isn't overly complicated.
  (2) Review the Partitioning Whitepapers. Even if you're using 2008, you can start with the 2005 whitepaper here: http://msdn2.microsoft.com/en-us/library/ms345146.aspx. The 2008 whitepaper is here: http://msdn.microsoft.com/en-us/library/dd578580.aspx. Also, don't forget that your VPC has the 2005 whitepaper scripts duplicated but using a RIGHT-based partition function instead of a LEFT-based (as described in the whitepaper).
  (3) After the whitepapers, consider going through the Online Operations Lab (specifically: SQL Server 2008 Online Operations Hands-On Lab).


Outside of that - feel free to shoot me an email if you have any questions or issues!

Enjoy!!
Kimberly