Updates 1499 Published by

Microsoft has released the June 2010 release of it's SQL Server 2008 R2 Update for Developers Training Kit



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:

Presentations (32)
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
SQL Server 2008 R2: Introducing Application and Multi-Server Management with SQL Server 2008 R2 and Visual Studio 2010
SQL Server 2008 R2: Working with Data Tier Application Projects in Visual Studio 2010
SQL Server 2008 R2: Managing Change in Data Tier Application Projects with Visual Studio 2010 and SQL Server 2008 R2
SQL Server 2008 R2: Introducing SQL Server 2008 R2 StreamInsight
SQL Server 2008 R2: Querying Events in SQL Server 2008 R2 StreamInsight
SQL Server 2008 R2: Designing SQL Server 2008 R2 StreamInsight Event Models and Adapters
SQL Server 2008 R2: Installing, Deploying and Maintaining the SQL Server 2008 R2 StreamInsight Runtime Engine
SQL Server 2008 R2: What's New in SQL Server 2008 R2 Reporting Services
SQL Server 2008 R2: Developing Reports with the New Features of SQL Server 2008 R2 Reporting Services
SQL Server 2008 R2: Visualizing Data with Maps in SQL Server 2008 R2 Reporting Services
SQL Server 2008 R2: Working with Shared Components in SQL Server 2008 R2 Reporting Services
SQL Server 2008 R2: Working with ATOM Data Feeds in SQL Server 2008 R2 Reporting Services
SQL Server 2008 R2: Embedded Reporting in Applications with SQL Server 2008 R2 Reporting Services and Visual Studio 2010
SQL Server 2008 R2: Developing with the Microsoft Chart Controls in Visual Studio 2010
SQL Server 2008 R2: What's New in the Excel 2010 Client
SQL Server 2008 R2: Loading and Preparing Data for Analysis in SQL Server PowerPivot for Excel 2010
SQL Server 2008 R2: Creating Reports with SQL Server PowerPivot for Excel 2010
SQL Server 2008 R2: Defining DAX Calculations with PowerPivot for Excel 2010
SQL Server 2008 R2: Introducing SharePoint 2010 Insights
SQL Server 2008 R2: What's New in SharePoint 2010 Excel Services
SQL Server 2008 R2: What's New in SharePoint 2010 PerformancePoint Services
SQL Server 2008 R2: Developing KPI's and Scorecards with SharePoint 2010 PerformancePoint Services
SQL Server 2008 R2: Developing Reports and Dashboards with SharePoint 2010 PerformancePoint Services
SQL Server 2008 R2: Managing PowerPivot for Excel 2010 Solutions in SharePoint 2010

Demos (39)
SQL Server 2008: AdventureWorks Racing All-Up Demo
SQL Server 2008: Spatial Demo
SQL Server 2008: Spatial Types
SQL Server 2008: Introduction to Filestream
SQL Server 2008: SQL CLR Nullable Types
SQL Server 2008: Programming with Filestream
SQL Server 2008: Reporting Services Web Application Integration
SQL Server 2008: T-SQL Date and Time Support
SQL Server 2008: T-SQL Table-Valued Parameters
SQL Server 2008: T-SQL Row Constructors
SQL Server 2008: T-SQL Grouping Sets
SQL Server 2008: T-SQL Merge
SQL Server 2008 R2: Creating a Utility Control Point
SQL Server 2008 R2: Enrolling a Managed Instance
SQL Server 2008 R2: Creating Data-Tier Applications
SQL Server 2008 R2: Data-Tier Application Deployment
SQL Server 2008 R2: Managing Change in Data Tier Application Projects in Visual Studio 2010
SQL Server 2008 R2: Introducing SQL Server 2008 R2 StreamInsight
SQL Server 2008 R2: Querying Events in SQL Server 2008 R2 StreamInsight
SQL Server 2008 R2: Advanced SQL Server 2008 R2 StreamInsight Event Queries
SQL Server 2008 R2: Working with SQL Server 2008 R2 StreamInsight CTI Events and Advance Time Settings
SQL Server 2008 R2: Creating a SQL Server 2008 R2 StreamInsight Input Adpater
SQL Server 2008 R2: Choosing a SQL Server 2008 R2 StreamInsight Development Model
SQL Server 2008 R2: Using the SQL Server 2008 R2 StreamInsight Event Flow Debugger
SQL Server 2008 R2: Using the New Report Design Features in SQL Server 2008 R2 Reporting Services
SQL Server 2008 R2: Visualizing Data with Maps in SQL Server 2008 R2 Reporting Services
SQL Server 2008 R2: Using Shared Component Libraries in SQL Server 2008 R2 Reporting Services
SQL Server 2008 R2: Using SQL Server 2008 R2 Reporting Services Report Feeds
SQL Server 2008 R2: Using the Visual Studio 2010 Report Viewer Control
SQL Server 2008 R2: What's New in the Excel 2010 Client
SQL Server 2008 R2: Loading and Preparing Data for Analysis in SQL Server PowerPivot for Excel 2010
SQL Server 2008 R2: Creating Reports with SQL Server PowerPivot for Excel 2010
SQL Server 2008 R2: Defining DAX Calculations with SQL Server PowerPivot for Excel 2010
SQL Server 2008 R2: Introducing SharePoint 2010 Insights
SQL Server 2008 R2: What's New in SharePoint 2010 Excel Services
SQL Server 2008 R2: What's New in SharePoint 2010 PerformancePoint Services
SQL Server 2008 R2: Developing KPI's and Scorecards with SharePoint 2010 PerformancePoint Services
SQL Server 2008 R2: Developing Reports and Dashboards with SharePoint 2010 PerformancePoint Services
SQL Server 2008 R2: Managing Excel 2010 PowerPivot Solutions in SharePoint 2010

Hands-on Labs (24)
SQL Server 2008: How to build your first Web Application with SQL Server and ASP.NET
SQL Server 2008: Using Spatial Data in TSQL
SQL Server 2008: Using Spatial Data in Managed Code
SQL Server 2008: Using SQL CLR in SQL Server 2008
SQL Server 2008 R2: Introduction to PowerPivot
SQL Server 2008 R2: Introduction to Reporting Services Improvements
SQL Server 2008 R2: Introduction to StreamInsight and Complex Event Processing
SQL Server 2008 R2: Introduction to Data-tier Applications
SQL Server 2008 R2: Creating and Deploying a Data-Tier Application
SQL Server 2008 R2: Managing Change in Data-Tier Application Projects in Visual Studio 2010
SQL Server 2008 R2: Querying Events in SQL Server 2008 R2 StreamInsight using LINQ
SQL Server 2008 R2: Working with the SQL Server 2008 R2 StreamInsight Samples
SQL Server 2008 R2: Working with the SQL Server 2008 R2 StreamInsight Event Flow Debugger
SQL Server 2008 R2: Visualizing Data with Maps in SQL Server 2008 R2 Reporting Services
SQL Server 2008 R2: Developing and Consuming Report Libraries in SQL Server 2008 R2 Reporting Services
SQL Server 2008 R2: Working with ATOM Data Feeds in SQL Server 2008 R2 Reporting Services
SQL Server 2008 R2: Embedded Reporting in Applications with SQL Server 2008 R2 Reporting Services and Visual Studio 2010
SQL Server 2008 R2: Developing with the Microsoft Chart Controls
SQL Server 2008 R2: Loading and Preparing Data for Analysis in SQL Server PowerPivot for Excel 2010
SQL Server 2008 R2: Creating Reports with SQL Server PowerPivot for Excel 2010
SQL Server 2008 R2: Defining DAX Calculations with Excel 2010 PowerPivot
SQL Server 2008 R2: Developing KPI's and Scorecards with SharePoint 2010 PerformancePoint Services
SQL Server 2008 R2: Developing Reports and Dashboards with SharePoint 2010 PerformancePoint Services
SQL Server 2008 R2: Managing Excel 2010 PowerPivot Solutions in SharePoint 2010

Videos (55)
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
Presentation: Introducing Application and Multi-Server Management with SQL Server 2008 R2 and Visual Studio 2010
Demo: Creating a Utility Control Point
Demo: Enrolling a Managed Instance
Presentation: Working with Data Tier Application Projects in Visual Studio 2010
Demo: Creating Data-Tier Applications
Demo: Data-Tier Application Deployment
Presentation: Managing Change in Data Tier Application Projects with Visual Studio 2010 and SQL Server 2008 R2 (Part I)
Presentation: Managing Change in Data Tier Application Projects with Visual Studio 2010 and SQL Server 2008 R2 (Part II)
Demo: Managing Change in Data Tier Application Projects in Visual Studio 2010
Presentation: Introducing SQL Server 2008 R2 StreamInsight (Part I)
Presentation: Introducing SQL Server 2008 R2 StreamInsight (Part II)
Demo: Introducing SQL Server 2008 R2 StreamInsight
Presentation: Querying Events in SQL Server 2008 R2 StreamInsight (Part I)
Presentation: Querying Events in SQL Server 2008 R2 StreamInsight (Part II)
Demo: Querying SQL Server 2008 R2 StreamInsight Using LINQ
Presentation: Querying Events in SQL Server 2008 R2 StreamInsight (Part III)
Demo: Advanced SQL Server 2008 R2 StreamInsight Event Queries
Presentation: Designing SQL Server 2008 R2 StreamInsight Event Models and Adapters (Part I)
Presentation: Designing SQL Server 2008 R2 StreamInsight Event Models and Adapters (Part II)
Demo: Working with SQL Server 2008 R2 StreamInsight CTI Events and Advance Time Settings
Presentation: Designing SQL Server 2008 R2 StreamInsight Event Models and Adapters (Part III)
Demo: Creating a SQL Server 2008 R2 StreamInsight Input Adapter
Presentation: Installing, Deploying and Maintaining the SQL Server 2008 R2 StreamInsight Runtime Engine (Part I)
Presentation: Installing, Deploying and Maintaining the SQL Server 2008 R2 StreamInsight Runtime Engine (Part II)
Demo: Choosing a SQL Server 2008 R2 StreamInsight Development Model
Presentation: Installing, Deploying and Maintaining the SQL Server 2008 R2 StreamInsight Runtime Engine (Part III)
Demo: Using the SQL Server 2008 R2 StreamInsight Event Flow Debugger
resentation: What's New in SQL Server 2008 R2 Reporting Services
Presentation: Developing Reports with the New Features of SQL Server 2008 R2 Reporting Services
Demo: Using the New Report Design Features in SQL Server 2008 R2 Reporting Services
Presentation: Visualizing Data with Maps in SQL Server 2008 R2 Reporting Services
Demo: Visualizing Data with Maps in SQL Server 2008 R2 Reporting Services
Presentation: Working with Shared Components in SQL Server 2008 R2 Reporting Services
Demo: Using Shared Component Libraries in SQL Server 2008 R2 Reporting Services
Presentation: Working with ATOM Data Feeds in SQL Server 2008 R2 Reporting Services
Demo: Using SQL Server 2008 R2 Reporting Services Report Feeds
Presentation: Embedded Reporting in Applications with SQL Server 2008 R2 Reporting Services and Visual Studio 2010
Demo: Using the Visual Studio 2010 Report Viewer Control
Presentation: Developing with the Microsoft Chart Controls in Visual Studio 2010
Presentation: What's New in the Excel 2010 Client
Demo: What's New in the Excel 2010 Client
Presentation: Loading and Preparing Data for Analysis in SQL Server PowerPivot for Excel 2010
Demo: Loading and Preparing Data for Analysis in SQL Server PowerPivot for Excel 2010
Presentation: Creating Reports with SQL Server PowerPivot for Excel 2010
Demo: Creating Reports with SQL Server PowerPivot for Excel 2010
Presentation: Defining DAX Calculations with PowerPivot for Excel 2010
Demo: Defining DAX Calculations with SQL Server PowerPivot for Excel 2010
Presentation: Introducing SharePoint 2010 Insights
Demo: Introducing SharePoint 2010 Insights
Presentation: What's New in SharePoint 2010 Excel Services
Demo: What's New in SharePoint 2010 Excel Services
Presentation: What's New in SharePoint 2010 PerformancePoint Services
Demo: What's New in SharePoint 2010 PerformancePoint Services
Presentation: Developing KPI's and Scorecards with SharePoint 2010 PerformancePoint Services
Demo: Developing KPI's and Scorecards with SharePoint 2010 PerformancePoint Services
Presentation: Developing Reports and Dashboards with SharePoint 2010 PerformancePoint Services
Demo: Developing Reports and Dashboards with SharePoint 2010 PerformancePoint Services
Presentation: Managing Excel 2010 PowerPivot Solutions in SharePoint 2010
Demo: Managing Excel 2010 PowerPivot Solutions in SharePoint 2010
  SQL Server 2008 R2 Update for Developers Training Kit (June 2010 Update)