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.
Site feedback

What category would you like to give web site feedback on?

Rate your level of satisfaction with this web page today: