Course Details

Previous Page


Maintaining SQL Server 2008 Reporting Services


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



Overview/Description
Administration and maintenance of Microsoft SQL Server 2008 Reporting Services and its components is key in providing customers and clients access to the Business Intelligence information they need. This course outlines the tools used and tasks involved in managing and maintaining access to Reporting Services and corresponding data. It covers the authentication subsystem and role-based authorization model used by Reporting Services, as well as the configuration of system-level and item-level role-based security. SQL Server 2008 also provides the ability to deploy and manage the report server and content using the Report Server Web Service and command-line tools. This course describes how to use these tools to automate administrative tasks and manage reports remotely through the web interface. It also outlines the options for monitoring server performance, report activities, and statistics using performance counters and the use of log files in evaluating server status and performance. This course is one of a series in the SkillSoft learning path that covers the objectives for the Microsoft exam: 70-448 TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance. Passing this exam will earn the learner Microsoft Certified Technology Specialist (MCTS): SQL Server 2008, Business Intelligence Development and Maintenance certification.

Target Audience
IT professionals working to develop and maintain Microsoft SQL Server 2008 business intelligence solutions or those pursuing a career as a database administrator or developer

Prerequisites
Familiarity with Microsoft .NET Framework; experience with SQL Server 2005 or SQL Server 2008 business intelligence components; experience in performing queries on relational databases and using SQL Server Management Studio and Business Intelligence Development Studio

Expected Duration (hours)
1.5

Lesson Objectives

Maintaining SQL Server 2008 Reporting Services

  • recognize how to configure SSRS
  • recognize how to perform administration and maintenance of SSRS
  • recognize the features of SSRS Security
  • recognize how to create a new role
  • recognize how to automate SSRS administration
  • manage reporting services in SQL Server 2008
  • recognize how to monitor and maintain SSRS performance
  • Course Number:
    md_mqbm_a06_it_enus