This training kit is a great resource for developers, trainers, consultants and evangelists who need to understand SQL Server 2008 and SQL Server 2008 R2 improvements from a developer perspective. It contains a rich set of presentations, demos, hands-on labs and videos that are perfect for self-paced learning or for conducting your own training.
The May 2011 update provides support for Windows 7 SP1, Windows Server 2008 R2 SP1 and Visual Studio 2010 SP1.
Additionally, any demos or hands-on labs that no longer have a Visual Studio 2008 dependency were updated to
Visual Studio 2010.
The easiest way to get started with the training kit is to download it, install it, open default.htm and browse the kit
for the content that you are most interested in. Many of the presentations and demos in the training kit include a video
that you can watch to familiarize yourself with the content. When you are ready for some hands-on experience, try installing
one of the demos or hands-on labs. Each of them includes a configuration wizard that simplifies installation.
What's In the Training Kit
The training kit is divided into four sections:
Here is a breakdown of each section and its associated content:
- Getting Started (for Web and BI developers who are new to SQL Server)
- SQL Server 2008 (for experienced SQL Server developers who want to understand what's new in 2008)
- SQL Server 2008 R2 (for experienced SQL Server developers who want to understand what's new in 2008 R2)
- Office 2010 (for experienced BI developers who want to understand what's new in 2008 R2 and Office 2010)
- Getting Started
Web Developers: 1 Hands-On Lab, 2 Videos
BI Developers: 32 Presentations, 27 Demos, 12 Hands-On Labs, 59 Videos
- SQL Server 2008
Overview: 1 Presentation, 1 Video
Date and Time Data Types: 1 Presentation, 1 Demo
Spatial Data Types: 1 Presentation, 2 Demos, 2 Hands-On Labs
FILESTREAM Blob Storage: 1 Presentation, 2 Demos
Transact-SQL Improvements: 1 Presentation, 4 Demos
.NET CLR Integration: 1 Presentation, 2 Demos, 1 Hands-On Lab
Reporting Services: 1 Presentation, 1 Demo
AdventureWorks Racing All-Up SQL Server 2008 Demo: 1 Presentation, 1 Demo
- SQL Server 2008 R2
Overview: 2 Presentations, 4 Hands-On Labs, 8 Videos
Data-tier Application Framework: 3 Presentations, 5 Demos, 2 Hands-On Labs, 9 Videos
StreamInsight: 4 Presentations, 7 Demos, 3 Hands-On Labs, 17 Videos
Reporting Services: 7 Prsentations, 5 Demos, 5 Hands-On Labs, 12 Videos
- Office 2010
Excel 2010 and PowerPivot: 4 Presentations, 4 Demos, 3 Hands-On Labs, 8 Videos
SharePoint 2010, PerformancePoint Services and PowerPivot: 6 Presentations, 6 Demos, 3 Hands-On Labs, 12 Videos
Supported Operating System
Windows 7, Windows Server 2008 R2
- Microsoft SQL Server 2008 R2
- Microsoft Visual Studio 2010
- AdventureWorks 2008 R2 Sample Databases
Download and run the self-extracting EXE. Open the default.htm file in the installation directory to browse the content in the training kit.