Reporting Services Report Server Administration
This course is for server administrators responsible for maintaining Reporting Services and for report developers who need to understand how reports are managed on the report server
What you'll learn
This course explains how to manage reports after the development process is complete and how to manage the reporting environment. It explains how to move reports to the report server and how to configure properties to control report execution behavior. This course also explains how to create and manage report subscriptions, how to secure reports, and options for configuring the report server. The features and demonstrations in this course focus on the SQL Server 2008 R2 release, although most topics with the exception of report server configuration also apply to earlier versions of Reporting Services.
Table of contents
- Introduction 1m
- Deployment 1m
- Project Properties 4m
- Deployment Options 2m
- Demo: Deploying from BIDS 7m
- Demo: Deploying in Report Manager 5m
- RS Utility 2m
- Demo: Deploying Reports with the RS Utility 9m
- Redeployment 1m
- Report Parts 2m
- Demo: Deploying Report Parts 3m
- Demo: Working with Report Parts 7m
- Summary 2m
- Introduction 1m
- Data Source Configuration 2m
- Demo: Configurating a Data Source 3m
- Report Execution 1m
- On Demand Execution 3m
- Caching 3m
- Shared Schedules 2m
- Cache Refresh 1m
- Demo: Caching 9m
- Demo: Working with Shared Schedules 3m
- Snapshots 4m
- Demo: Creating Snapshots 2m
- Demo: Adding Snapshots to Report History 3m
- Summary 2m
- Introduction 1m
- Standard Subscription 1m
- E-mail Subscription 3m
- Demo: Creating an E-mail Subscription 2m
- Windows File Share Subscription 2m
- Demo: Creating a Windows File Share Subscription 1m
- Subscriptions and Parameters 0m
- Other Delivery Extensions 1m
- Data-driven Subscription 1m
- Data-driven Subscription Delivery Options 1m
- Demo: Creating a Data-driven Subscription 2m
- Subscription Management 1m
- Demo: Managing Subscriptions 2m
- Demo: Reviewing E-mail and Windows File Share Subscription Output 1m
- Summary 2m
- Introduction 1m
- Authentication 2m
- Authorization 2m
- Demo: Reviewing Roles on a Native-Mode Report Server 4m
- Item-Level Security 3m
- Demo: Configuring Item-Level Security 4m
- System Roles 2m
- Demo: Assinging Users to System Roles 3m
- Linked Report Security 1m
- Query Parameter Security 1m
- Demo: Using a Query Parameter to Secure Data 5m
- Dataset Filter Security 1m
- Demo: Using a Dataset Filter to Secure Data 3m
- Summary 3m
- Introduction 1m
- Service Account and Web Service URL Configuration 4m
- Database, Report Manager URL, and Email Settings 2m
- Execution Account, Encryption Keys, and Scale-out Deployment 3m
- Demo: Reviewing the Reporting Services Configuration Manager 3m
- RS Utility 1m
- Memory Management 3m
- Demo: Setting Memory Management Thresholds 3m
- Surface Area Reduction 1m
- Demo: Reviewing Settings for Surface Area Reduction 1m
- Server Properties 4m
- Demo: Reviewing Server Properties 2m
- Logs 4m
- Demo: Working with Logs 4m
- Performance Counters 1m
- Demo: Using Performance Counters 3m
- Summary 3m
About the author
Stacia Misner Varga is an instructor, author, and principal consultant of Data Inspirations. Her career spans more than 30 years, with a focus on improving business practices through technology. Since 2000, she has provided consulting and education services for Microsoft’s data platform and authored or co-authored many books covering this topic. In addition, Stacia has been a frequent speaker over the years at technology conferences worldwide.