Pluralsight - Reporting Services Report Server Administration

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.

Report Deployment 00:47:00
Introduction 00:41
Deployment 01:03
Project Properties 03:42
Deployment Options 02:25
Demo: Deploying from BIDS 06:36
Demo: Deploying in Report Manager 04:54
RS Utility 01:52
Demo: Deploying Reports with the RS Utility 09:15
Redeployment 01:26
Report Parts 02:07
Demo: Deploying Report Parts 03:19
Demo: Working with Report Parts 07:27
Summary 02:13
Report Administration 00:39:36
Introduction 00:45
Data Source Configuration 02:10
Demo: Configurating a Data Source 03:28
Report Execution 01:26
On Demand Execution 02:29
Caching 03:15
Shared Schedules 01:32
Cache Refresh 01:16
Demo: Caching 08:56
Demo: Working with Shared Schedules 02:50
Snapshots 03:42
Demo: Creating Snapshots 02:29
Demo: Adding Snapshots to Report History 03:06
Summary 02:12
Subscriptions 00:20:16
Introduction 00:33
Standard Subscription 01:06
E-mail Subscription 02:30
Demo: Creating an E-mail Subscription 01:29
Windows File Share Subscription 01:39
Demo: Creating a Windows File Share Subscription 01:19
Subscriptions and Parameters 00:24
Other Delivery Extensions 01:27
Data-driven Subscription 00:49
Data-driven Subscription Delivery Options 01:21
Demo: Creating a Data-driven Subscription 02:13
Subscription Management 00:48
Demo: Managing Subscriptions 01:50
Demo: Reviewing E-mail and Windows File Share Subscription Output 00:50
Summary 01:58
Security 00:34:18
Introduction 00:37
Authentication 01:51
Authorization 01:59
Demo: Reviewing Roles on a Native-Mode Report Server 04:11
Item-Level Security 02:52
Demo: Configuring Item-Level Security 03:37
System Roles 01:50
Demo: Assinging Users to System Roles 03:14
Linked Report Security 01:26
Query Parameter Security 00:48
Demo: Using a Query Parameter to Secure Data 04:35
Dataset Filter Security 00:45
Demo: Using a Dataset Filter to Secure Data 03:12
Summary 03:21
Server Administration 00:42:38
Introduction 01:01
Service Account and Web Service URL Configuration 03:52
Database, Report Manager URL, and Email Settings 01:34
Execution Account, Encryption Keys, and Scale-out Deployment 03:02
Demo: Reviewing the Reporting Services Configuration Manager 02:53
RS Utility 01:26
Memory Management 03:06
Demo: Setting Memory Management Thresholds 03:01
Surface Area Reduction 00:40
Demo: Reviewing Settings for Surface Area Reduction 01:14
Server Properties 03:39
Demo: Reviewing Server Properties 01:32
Logs 03:41
Demo: Working with Logs 04:25
Performance Counters 01:22
Demo: Using Performance Counters 02:58
Summary 03:12