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….
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 BenefitsThe training kit offers the following benefits:
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.