Deploying and Delivering SQL Server 2008 Reporting Services Reports

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

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

Expected Duration
120 minutes

This course discusses features and tasks performed by administrators when working with SQL Server 2008 Reporting Services (SSRS) reports and content. After reports have been created and formatted, it is time to make them available to the users that need them. This involves the process of deploying reports and the associated data. This course describes the various methods and processes involved in the deployment and execution of reports. It covers the publishing of reports using the Report Manager web interface and BIDS Report Designer tool. Also discussed is the use and creation of report models; report models are needed to create reports using the user-friendly Report Builder tool. Another key benefit of Reporting Services is interoperability with a range of external applications. This course provides an overview of rendering report data to applications using the Report Server Web Service, Report Viewer controls, and URL access. Also discussed are options that can be configured for the delivery of reports, including the use of report subscriptions, schedules, cached reports, and the use of snapshots. 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.


Deploying SSRS Reports in SQL Server 2008

  • recognize how to deploy a report with SQL Server 2008
  • recognize how report models are used
  • recognize how to integrate with Report Server Web Service
  • recognize how to integrate using URL Access
  • recognize how to use ReportViewer controls

Delivering SSRS Reports in SQL Server 2008

  • create a schedule
  • recognize how to set up subscriptions
  • use report caching
  • recognize how to create a report snapshot
  • create report models
  • create schedules and set up report caching





Multi-license discounts available for Annual and Monthly subscriptions.