Duration

2 Days

Outline for Microsoft SQL Server 2008 R2: What's New Training

1. Introduction to SQL Server 2008 R2

  • What is the R2 Release?
  • Installation Enhancements
  • Security Enhancements
  • Feature Only a DBZ Could Love

2. Multi-Server and Application Management

  • Multi-Server Management
  • Data-Tier Applications (DAC)
  • Working with DAC's

3. Business Intelligence for the Power User

  • PowerPivot for Excel and SharePoint
  • Working with the PowerPivot Excel Add-In

4. Querying Real Time Data Streams

  • Introduction to StreamInsight
  • Working with StreamInsight Data
  • Querying a Data Stream

5. Reporting Services in R2

  • Reporting Services Enhancements
  • Lookup Functions to Join Datasets
  • Aggregates of Aggregates
  • Control Output Formatting with RenderFormat
  • Report as a Data Source

6. New Data Visualization Features in R2

  • Shared Datasets
  • Data Bars and Sparklines
  • Indicators
  • Map-Based Data

7. Report Manager and Viewer in R2

  • Making Reporting Services More Widely Usable
  • Report Manager
  • Report Viewer

8. Report Builder 3.0

  • Creating and Using Report Models
  • Creating Reports
  • Saving and Deploying Reports