Roger Doherty's Windows Azure Blog

Work blog for Roger Doherty, Sr. Program Manger, SQL Server Customer Experience Team

Announcing the SQL Server 2008 R2 Update for Developers Training Kit

Announcing the SQL Server 2008 R2 Update for Developers Training Kit

Rate This
  • Comments 2

I’m pleased to announce that the first release of the SQL Server 2008 R2 Update for Developers Training Kit is available as a free download from the Microsoft Download center, so download your copy today at the following URL:

http://go.microsoft.com/?linkid=9710868

We’ll be shipping a new release every two weeks or so until launch with new content, so stay tuned for more!

Read on for more details….

SQL08r2_h_rgb

SQL Server 2008 R2 offers an impressive array of capabilities for developers that build upon key innovations introduced in SQL Server 2008. The SQL Server 2008 R2 Update for Developers Training Kit is ideal for developers who want to understand how to take advantage of the key improvements introduced in SQL Server 2008 and SQL Server 2008 R2 in their applications, as well as for developers who are new to SQL Server. The training kit is brought to you by Microsoft Developer and Platform Evangelism.

Overview and Benefits
The training kit offers the following benefits:

  • Learn how to build applications that exploit the unique features and capabilities of SQL Server 2008 and SQL Server 2008 R2.
  • Provides a comprehensive set of videos, presentations, demos and hands-on labs.
  • Contains new content for developers who are new to SQL Server.
  • Contains new content for SQL Server 2008 R2.
  • Contains all of the existing content from the SQL Server 2008 Developer Training Kit.
  • Easy to download and install.

Intended Audience
The training kit is designed for the following technical roles:
  • Developers who build applications for the Microsoft platform.
  • Microsoft evangelists, technical specialists and consultants.

Contents
The training kit includes the following content:
  • Videos (8)
    • SQL Server 2008 R2 Update for Developers Overview Part I - SQL Server 2008 Review
    • SQL Server 2008 R2 Update for Developers Overview Part II - Introducing SQL Server 2008 R2
    • Introducing SQL Server 2008 R2 StreamInsight
    • Demo: Real Time Analytics with SQL Server 2008 R2 StreamInsight
    • Introducing SQL Server 2008 R2 Application and Multi-Server Management
    • Introducing SQL Server 2008 R2 Reporting Services
    • Introduction To SQL Server 2008 R2 StreamInsight and Complex Event Processing
    • Introducing PowerPivot for Excel 2010 and SharePoint 2010
  • Presentations (8)
    • SQL Server 2008 R2 Update for Developers Overview Part I - SQL Server 2008 Review
    • SQL Server 2008 R2 Update for Developers Overview Part II - Introducing SQL Server 2008 R2
    • SQL Server 2008 Filestream
    • SQL Server 2008 Spatial
    • SQL Server 2008 T-SQL
    • SQL Server 2008 Date and Time Types
    • SQL SErver 2008 SQLCLR
    • SQL Server 2008 Reporting Services
  • Demos (13)
    • AdventureWorks Racing All-Up SQL Server 2008 Demo
    • SQL Server 2008 All-Up Spatial Demo
    • SQL Server 2008 Spatial Types Demo
    • Intro to SQL Server 2008 Filestream Demo
    • SQL Server 2008 SQL CLR Nullable Types Demo
    • Programming with SQL Server 2008 Filestream Demo
    • SQL Server 2008 Reporting Services Web Application Integration Demo
    • Date and Time Support in SQL Server 2008 Demo
    • SQL Server 2008 T-SQL Table-Valued Parameters Demo
    • SQL Server 2008 T-SQL Row Constructors Demo
    • SQL Server 2008 T-SQL Grouping Sets Demo
    • SQL Server 2008 T-SQL Merge Demo
  • Hands-on Labs (8)
    • How to build your first Web Application with SQL Server and ASP.NET
    • Using SQL Server 2008 Spatial Data in TSQL
    • Using SQL Server 2008 Spatial Data in Managed Code
    • Using SQL CLR in SQL Server 2008
    • PowerPivot in SQL Server 2008 R2
    • Using the New Features of Reporting Services 2008 R2
    • Introduction To SQL Server 2008 R2 StreamInsight and Complex Event Processing
    • Data-tier Applications in SQL Server 2008 R2 and Visual Studio 2010
  • Where is the prefered feed back location

      SQL Server 2008R2 Setup and Upgrade

      http://social.msdn.microsoft.com/Forums/en-US/sqlkjsetupandupgrade

      SQL Server Samples and Community Projects

      http://social.msdn.microsoft.com/Forums/en-US/sqlserversamples

    Connect

    http://Connect.microsoft.com

    As I have a question  with the dependacy script under the reporting services labs

    Using the default install path of "C:\SQL2008R2TrainingKit" running the script

    C:\SQL2008R2TrainingKit\Labs\SQL10R2UPD00-HOL-01\Source\Setup\setup

    Uses this configuration xml

         <dependency

                         value=".\scripts\Dependencies\Check\CheckAdventureWorksDW2008R2DB.ps1"

                         enabled="true"

                         optional="false"

                         required="true"

                         title="SQL Server AdventureWorksDW2008R2 2008 Sample Database"

                         explanation="This hands-on lab requires SQL Server AdventureWorksDW2008R2 Sample Database"

                         scriptName=""

                         downloadUrl="http://msftdbprodsamples.codeplex.com/Release/ProjectReleases.aspx" />

    The power shell script CheckAdventureWorksDW2008R2DB.ps1 uses an alias

    $resultAWDW2008R2 = Invoke-Expression "SQLCMD -S SQLServerTrainingKitAlias -Q ""use [AdventureWorksDW2008R2]"" -b";

    $resultAWDW2008R2 = ($lastexitcode -eq 0);

    $resultAW2008R2 = Invoke-Expression "SQLCMD -S SQLServerTrainingKitAlias -Q ""use [AdventureWorks2008R2]"" -b"

    $resultAW2008R2 = ($lastexitcode -eq 0);

    return $resultAWDW2008R2 -and $resultAW2008R2;

    At no point have I been given the choice of picking which server\instance require so the dependance fails

    If I change the dependancy XML to read

                         optional ="true"

                         required ="false"

    I then get past the dependance checker and offered the chance to configure a named pipes alias.

    Was it indended the report developer should be given this ejoyable  challenge. or is this a bug ?

  • Hi Robert, you can send feedback to the sqldevx@microsoft.com alias.  As far as your problem, you need to run the master dependency checker for the training kit first before running the dependency checker for an individual lab.  The default installation directory for the master dependency checker is located at C:\SQL2008R2TrainingKit\Assets\setup.cmd.  This will create a server alias called SqlServerTrainingKitAlias that maps to whatever instance name you specifify.  Thanks for downloading the training kit and for your interest in SQL Server 2008 R2.

Page 1 of 1 (2 items)
Leave a Comment
  • Please add 7 and 2 and type the answer here:
  • Post