SQLskills.com | Immerse Yourself In SQL Server


	Home

	Events
	Current Events
	Upcoming Events
	Past Events
	SQL Immersion Events
	Event Log

	Services
	Consulting/Auditing
	Training/Custom Courses

	Resources
	Articles
	Blogs
	Books
	Event Resources
	Interviews
	Knowledge Base Articles
	Q & A
	SQL Scripts
	Useful Links
	Whitepapers

	Partners

	Communications

	Contact Us

Upcoming Events \| Past Events \| Event Log

2009 \| 2008 \| 2007 \| 2006 \| 2005 \| 2004 \| 2003 \| Pre-2003

Webcasts
	The webcasts page has links to Kimberly's 10-part MSDN series A Primer to Proper SQL Server Development and her 11-part TechNet series SQL Server 2005 for the IT Professional. It also has links to other recorded webcasts that are available.
Sample Databases
	As used in most conference sessions, these two sample databases are useful for learning and reproducing the behavior of most demos. Credit is used in many performance-related demos. SalesDB is used in many "online operations" demos. Unzip and restore (possibly, WITH MOVE) to use.
	Credit Sample Database (48MB zip/155MB backup/700MB restore)
	2008 Credit Sample Database (52MB zip/53MB compressed backup/700MB restore)
	Sales Sample Database (18MB zip/196MB backup/240MB restore)

Sample Corrupt Databases
	This zip file contains the six common corrupt databases that Paul used in the Corruption Survival Techniques and DBCC CHECKDB sessions during 2008. These databases are all from SQL Server 2005. For instructions, see this blog post for details. Unzip and restore (possibly, WITH MOVE) to use.
	Sample Corrupt Databases (36MB zip/~400MB restored)



SQL Connections, Fall 2009
November 9 - 13, 2009 - Las Vegas, USA
Pre-conference Session (November 9) (Paul & Kimberly):
-	SQL Server 2005/2008: Database Maintenance Best Practices
	Kimberly's Demo Scripts
	Paul's Demo Scripts
Post-conference Session (November 13) (Kimberly):
-	SQL Server 2005/2008: Indexing for Performance
	Indexing: companion content from SQL Server 2008 Internals Ch6 (Indexing) is here. Class demos:
	Demo Scripts
Conference Sessions:
-	SDB303: Understanding Logging and Recovery in SQL Server (Paul)
	Demo Scripts
-	SDB305: Building the Right Backup Strategy (Paul)
	Demo Scripts
-	SDV307: SQL Server Covering: Concepts, Concerns, & Costs (Kimberly)
	Demo Scripts
-	SDV308: SQL Server 2008 Sparse Columns: Structures, Storage, Speed (Kimberly)
	Demo scripts
-	SDV309: Follow the Rabbit: Interactive Q & A on... Everything! (Paul & Kimberly)


Microsoft TechEd Europe 2009
November 9 - 13, 2009 - Berlin, Germany
	Presented by Microsoft Corporation
Conference Sessions, presented by Bob Beauchemin:
-	DAT401: Auditing and Compliance Features in SQL Server 2008
	Code Samples
-	DAT405: Peeking into the plan cache with SQL Server 2008
	Code Samples

-	DAT03-IS: Filtered Indexes and Statistics in SQL Server 2008
	Code Samples


SQL PASS Community Summit, 2009
November 2 - 6, 2009 - Seattle, USA
Pre-conference Session (November 2) (Kimberly):
-	SQL Server 2005/2008: Indexing for Performance
	Indexing: companion content from SQL Server 2008 Internals Ch6 (Indexing) is here. Class demos:
	Demo Scripts
Post-conference Session (November 6) (Paul):
-	Disaster Recovery: Tips, Tricks, and Techniques
	Demo Scripts
Spotlight Sessions:
-	Understanding Logging and Recovery in SQL Server (Paul)
	Demo Scripts
-	SQL Server Covering: Concepts, Concerns, & Costs (Kimberly)
	Demo Scripts


SQL Immersion Event, Melbourne, Australia
October 19 - 22, 2009
SQL Server 2005/2008: Performance Tuning: From Design to Indexing to Optimizing Procedural Code:
-	Indexing: companion content from SQL Server 2008 Internals Ch6 (Indexing) is here. Class demos:
	Demo Scripts
SQL Server 2005/2008: Database Maintenance and Availability: From Performance to Disaster Recovery:
-	Demos for all modules:
	Demo Scripts


SQL Immersion Event, Dublin, Ireland
September 21 - 25, 2009 - Microsoft EPCD2, Dublin, Ireland
Kimberly's Modules:
-	Partitioning: demos are on the DVD we gave out, whitepaper is here.
-	Indexing: companion content from SQL Server 2008 Internals Ch6 (Indexing) is here. Class demos:
	Demo Scripts
Paul's Modules:
-	Demos for all modules:
	Demo Scripts


SQL Connections, Spring 2009
March 22 - 26, 2009 - Orlando, USA
Pre-conference Session (March 21) (Bob):
-	A Day of SQL Server 2008 Spatial Data and Location-Aware Applications
	Demo Scripts
Pre-conference Session (March 22) (Paul & Kimberly):
-	SQL Server 2005/2008 Indexes from Every Angle - Internals, Statistics and Fragmentation
	Demo Scripts (~5MB)
Post-conference Session (March 26) (Paul & Kimberly):
-	SQL Server 2005/2008 Indexes from Every Angle - Are Your Indexing Strategies Working?
	Demo Scripts (~5MB)
Conference Sessions:
-	SDV302: Programming Filestreams in SQL Server 2008 (Bob)
	Demo Scripts
-	SDB304: Essential Database Maintenance (Paul & Kimberly)
	Demo Scripts (we didn't do any, but these scripts are applicable)
-	SDV308: Indexing for Performance (Kimberly)
	Demo Scripts
-	SDB310: Corruption Survival Techniques (Paul)
	Demo scripts (see this blog post for details)
-	SDV314: Practical SQL Server Security for Architects and Developers (Bob)
	Demo Scripts
-	SDB316: Scripting SQL Server 2008 Policies and Data Collection with PowerShell and SMO (Bob)
	Demo Scripts
-	SDV320: SQL Server 2008 Sparse Columns and Filtered Indexes (Kimberly)
	Demo Scripts(and the big database is here (~54MB)
-	SDB322: Follow the Rabbit: Interactive Q&A on Database Maintenance (Paul & Kimberly)