SQL Server 2008 R2 Update for Developers Training Kit (March 2010 Update 2)
- 15 Presentation
- 24 Demo
- 13 Hands-on Labs
- 35 Videos
The training kit includes the following content:
- Presentations (15)
- 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
- Demos (24)
- 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
- Hands-on Labs (13)
- 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
- Videos (35)
- 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
Once again a lot of stuff included for SQL Server 2008 R2.
System Requirements
- Supported
Operating Systems: Windows 7; Windows Server 2008 R2.
- Microsoft SQL Server 2008 R2 November CTP.
- Microsoft Visual Studio 2010 Ultimate 2010 Beta 2.
- AdventureWorks 2008 R2 Sample Databases.
For more info and download you can check here.
Stay Tuned!