Web Age Solutions Inc
Providing Technology Training and Mentoring For Modern Technology Adoption
Web Age Aniversary Logo
US Inquiries / 1.877.517.6540
Canadian Inquiries / 1.877.812.8887
Course #:WA1960

Microsoft SQL Server 2008 R2: What's New Training

SQL Server 2008 brought many changes to the SQL platform and the R2 release added many more. This course will help to bring you up to speed on these changes and how they will affect how you work with SQL Server. You will see what is new with installation and security, see its support for managing data-tier applications and a multi-server environment, and learn about PowerPivot, which Microsoft calls “managed self-service business intelligence” that gets BI data in the hands of users who need it. Next you will learn about the new StreamInsight feature that lets you query high-volume data streams for useful nuggets of information and emerging trends. Reporting Services probably received by far the most enhancements in R2 and you will learn about the new expression language and data visualization features. Report Manager and Viewer received major overhauls, and you’ll see how to put them to good use, as well as exploring how to put Report Builder to use creating great reports.


2 Days

Outline of 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
We regularly offer classes in these and other cities. Atlanta, Austin, Baltimore, Calgary, Chicago, Cleveland, Dallas, Denver, Detroit, Houston, Jacksonville, Miami, Montreal, New York City, Orlando, Ottawa, Philadelphia, Phoenix, Pittsburgh, Seattle, Toronto, Vancouver, Washington DC.
US Inquiries / 1.877.517.6540
Canadian Inquiries / 1.877.812.8887