Legacy Update: Get back online, activate, and install updates on your legacy Windows PC

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:

• 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)

Here is a breakdown of each section and its associated content:

1. Getting Started
   Web Developers: 1 Hands-On Lab, 2 Videos
   BI Developers: 32 Presentations, 27 Demos, 12 Hands-On Labs, 59 Videos
   
2. 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
   
3. 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
   
4. 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

Files

Status: Deleted This download is no longer available on microsoft.com. The downloads below are archives provided by the Internet Archive Wayback Machine from the Microsoft Download Center prior to January 2016.

Files
SQL2008R2UpdateForDevsTrainingKit.Setup.20110505.exe

File sizes and hashes are retrieved from the Wayback Machine’s indexes. They may not match the latest versions of files hosted on Microsoft servers.

• 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.