Managing SSRS Reporting Environments

This course will teach you the critical skills needed to administer a SQL Server Reporting Services (SSRS) system from installation through management and meta reporting.
Course info
Level
Advanced
Updated
Jan 13, 2021
Duration
1h 32m
Table of contents
Description
Course info
Level
Advanced
Updated
Jan 13, 2021
Duration
1h 32m
Description

For on-premises reporting based on Microsoft SQL Server, SSRS is the go-to solution. In this course, Managing SSRS Reporting Environments, you’ll learn the skills needed to be an effective SSRS administrator at Globomantics. First, you'll discover how to install and configure an SSRS instance. Next, you’ll explore how reports are deployed, subscribed to, scheduled, executed, and logged. Finally, you’ll learn how to administer a reporting environment, manage jobs, assemblies, certificates, and more. By the end of this course, you'll know how to effectively deploy and manage an SSRS web portal.

About the author
About the author

Gerald is a multiple-year of the Microsoft MVP award, Gerald has led introductory classes in Python and SQL for industry-sponsored events at Ryerson University, Toronto and the University of Toronto (his alma mater). 

More from the author
SSIS Database Maintenance Playbook
Advanced
1h 10m
Jun 26, 2020
More courses by Gerald Britton
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi everyone. My name is Gerald Britton. Welcome to my course, Managing SSRS Reporting Environments. I'm an IT specialist at a top‑five bank and a Pluralsight author. In this course, we're going to look at SQL Server Reporting Services from an administrator's viewpoint. We will start with a finished report and see how to deploy, update, schedule, and manage it in a production environment. Some of the major topics that we will cover include installing and configuring reporting services on a Windows host, customizing the web portal to match a company brand, setting up report subscriptions and data sources, scheduling report dataset caching and snapshots, and managing jobs and automating deployment. By the end of this course, you'll know how to deploy and manage an SSRS web portal and the reports that it serves. Before beginning the course, you should be familiar with basic report development in Visual Studio and how to use SQL Server Management Studio to run stored procedures and view results. From here, you should feel comfortable diving into other courses in the Pluralsight Building Reports with SSRS path, covering topics such as writing reports, securing access, and developing KPI dashboards. I hope you'll join me on this journey to learn about managing SSRS with the Managing SSRS Reporting Environments course, here at Pluralsight.