Hey there Immersion Event Attendees! 

I've put together all of the scripts we discussed over our lectures. 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 what I've included and how to use them?

(**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 topics (especially partitioning) there are demo scripts and/or labs on the VPC. The labs are titled as follows:
Lab Name
     SQL Server 2008 Data Recovery and Preventative Techniques Hands-on Lab
     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
     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. Evne 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).

	
(**3**) the Indexing demo scripts (use the solution: IndexingForPerformance.ssmssln)
These specific demo scripts are NOT in the VPC. They are zipped up in this directory structure. These can be used on a standalone instance of SQL Server OR within the VPC. These require the credit database (for which there is a link in the directory) and you can install it on your standalone instance OR use the credit database backup that's already included inside the VPC. In fact, all of the "restore credit" scripts are setup to work perfectly within the VPC. If you use them with your own installed instance of SQL Server then you'll need to make sure that all of the paths are setup correctly, etc.

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

Enjoy!!
Kimberly