Training

 

 

Popular Courses

Browse Our Free Resources

  • whitepapers
  • whitepapers
  • webinars
  • blogs

Our Locations

Training Centres

Vancouver, BC
Calgary, AB
Edmonton, AB
Toronto, ON
Ottawa, ON
Montreal, QC
Hunt Valley
Columbia

locations map

Calgary

550 6th Av SW
Suite 475
Calgary, AB
T2P 0S2

Toronto

821A Bloor Street West
Toronto, ON
M6G 1M1

Vancouver

409 Granville St
Suite 902
Vancouver, BC
V6C 1T2

U.S. Office

436 York Road
Suite 1
Jenkintown, PA
19046

Other Locations

Dallas, TX
Miami, FL

Home > Training > DBA > Microsoft SQL Server 2008 R2: What's New Training

Microsoft SQL Server 2008 R2: What's New Training

Course#: WA1960

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.

Duration

2 Days

Outline of WA1960 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.
*Your name:

*Your e-mail:

*Phone:

*Company name:

Additional notes:

We have received your message. A sales representative will contact you soon.

Thank you!.

more details
buy this course

Register for a courseware sample

It's simple, and free.

 

Thank You!

You will receive an email shortly containing a link to download the requested sample of the labs for this course.