SQL Server 2008 R2 Update for Developers Training Kit (May 2011 Update)

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


      File Name:


      Date Published:


      File Size:

      269.0 MB

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