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 Algeo 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.