Hey there Chicago IE1 attendees:

I've put together all of the scripts that we're going to discuss 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) Review the MCM videos on Partitioning
	(3.3) Read the SQL Server 2005 whitepaper on Partitioning: http://msdn.microsoft.com/en-US/library/ms345146(v=SQL.90).aspx
	(3.4) Read the SQL Server 2008 whitepaper on Partitioning: http://download.microsoft.com/download/D/B/D/DBDE7972-1EB9-470A-BA18-58849DB3EB3B/PartTableAndIndexStrat.docx
	(3.5) 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) In addition to the items above, many of our specific demo scripts are NOT in the VPC. These are in attached 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. Demo scripts included:
	Locking & BLocking
	Indexing for Performance
	Pauls Demos

The names of the zips are pretty obvious :)

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

Enjoy!!
Kimberly