Hey there Chicago IE2 attendees from 24-28 October 2011!

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.

I thought I'd put together a few notes to help you navigate, etc. 

1) the DVD
This is the 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! It requires 16GB of disk space and 1.5GB of dedicated memory. So... it's better on a larger machine. Here's a link for the online reference for VHDs: http://www.sqlskills.com/BLOGS/KIMBERLY/post/VHD_Online_Reference_Guide.aspx. 

2) the demo scripts and HOLs
For many topics 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

3) For Partitioning:
	(3.1) I'd go through the lab: SQL Server 2008 Table Index & Partitioning Hands-On Lab
	(3.2) I'd go through the SQL Server 2005 whitepaper on Partitioning: http://msdn.microsoft.com/en-US/library/ms345146(v=SQL.90).aspx
	(3.3) I'd go through the SQL Server 2008 whitepaper on Partitioning: http://download.microsoft.com/download/D/B/D/DBDE7972-1EB9-470A-BA18-58849DB3EB3B/PartTableAndIndexStrat.docx
	(3.4) Finally, go through the lab: SQL Server 2008 Online Operations Hands-On Lab

4) The Index Internals scripts from the title: SQL Server 2008 Internals here: http://www.amazon.com/Microsoft%C2%AE-SQL-Server%C2%AE-2008-Internals/dp/0735626243/ref=sr_1_1?ie=UTF8&qid=1305063427&sr=8-1 
And, specifically, the demo scripts from Chapter 6 are here: http://www.sqlskills.com/BLOGS/KIMBERLY/post/Companion-content-for-Chapter-6-(Index-Internals)-of-SQL-Server-2008-Internals.aspx 

5) Kimberly's Demos -> Module 11's DMV demo scripts (Parts 1-4) can be found in the PlanCache&Procs.zip. The IndexingDMV scripts (Part 5) are in IndexDMVsDemoScripts.zip

These specific demo scripts are NOT in the VPC. They are in these zip files (as zips themselves). These can be used on a standalone instance of SQL Server OR within the VPC. These require the credit database and you can install it on your standalone instance OR use the credit database backup that's already included inside the VPC (in the SQLskills directory). 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. If you want to access the credit backup from our website - check out our script resources page here: http://www.sqlskills.com/PastConferences.asp. 

6) Paul's demos are in PaulsDemos.zip. 
7) Jon's demos are in JonsDemos.zip

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

Enjoy!!
Kimberly