SQL Server 2008 R2 Update for Developers Training Kit (June 2010 Update)

Das Data Platform Evangelism Team von Microsoft hat eine neue, stark überarbeitete Version dieses Entwickler Kits veröffentlicht, das sicherlich auch für Nichtentwickler eine Menge an Neuigkeiten für Anwender des SQL Servers 2008 und 2008 R2 bereithält. Alle neuen Elemente im Vergleich zur vorhergehenden Version (vom April) sind rot gekennzeichnet.

https://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=fffaad6a-0153-4d41-b289-a3ed1d637c0d

Die folgenden Punkte enthalten die minimalen Voraussetzungen zur Verwendung dieses Kits:

• .NET Framework 3.5 SP1
• Windows Powershell
• Microsoft Office PowerPoint Viewer 2007
• Additional Requisites

Für die Demos und Hands On Labs (HOLs) benötigen Sie ein entsprechendes System mit folgenden Voraussetzungen:

• Microsoft SQL Server 2008 R2
• Microsoft SQL Server 2008 R2 AdventureWorks Sample Database
• Microsoft Visual Web Developer 2008 Express Edition (or Microsoft Visual Studio 2008)
  Microsoft Visual Web Developer 2008 or Microsoft Visual Studio 2008 is required to run some of the training kit demos.
• Microsoft Visual C# 2008 Express or (Microsoft Visual Studio 2008 with Visual C# feature)
  Microsoft Visual C# 2008 Express or Microsoft Visual Studio 2008 is required in some of the labs.
• Microsoft Visual Studio 2010 Professional, Premium or Ultimate
  Microsoft Visual Studio 2010 (Professional, Premium or Ultimate) is required in the Data-tier Applications lab.
• Microsoft SQL Server 2008 Reporting Services Samples
  The SSRS Demo requires AdventureWorks 2008 Report Samples.
• Microsoft SQL Server 2008 R2 Report Builder 3.0
  The SSRS Lab and Demo requires Microsoft Report Builder 3.0.
• Microsoft SQL Server 2008 R2 StreamInsight
  The StreamInsight Lab requires Microsoft SQL Server 2008 R2 StreamInsight.
• Microsoft Office 2010 Excel
  The PowerPivot Lab requires Microsoft Office 2010 Excel.
• Microsoft SharePoint Server 2010
  Some of the exercises in the PowerPivot and SSRS Labs require Microsoft SharePoint Server 2010.

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

Außer dem Kit vom SQL Server bietet Ihnen Microsoft eine Reihe weiterer entsprechender Trainings- bzw. Entwicklerkits an:

• Visual Studio 2010 and .NET Framework 4 Training Kit - February Release
• SharePoint 2010 Beta Developer Training Kit
• Office 2010 Beta Developer Training Kit
• Windows Server 2008 R2 Developer Training
• Windows 7 Training Kit For Developers
• Windows Azure Platform Training Kit - December Update
• Identity Developer Training Kit (March 2010)
• Windows Phone 7 Series Developer Training Kit