Administering SSRS 2017
The course will teach an administrator how to use the features of SQL Server Reporting Services (SSRS) to manage a service and portal for deployment of reports through security, caching, and scheduled jobs.
What you'll learn
Administrating SQL Server Report Services or SSRS involves many aspects in the reporting portal as well as on the service level. In this course, Administering SSRS 2017, you will learn how to use SSRS portal for creating, maintaining, and monitoring user’s permissions for deploying and viewing reports. First, you will discover the portal which will assist you in creating and managing the scheduled jobs to execute reports for end users. Next, you will learn how to create triggers based on data-driven reports. Finally, you will see the steps needed for customizing the portal with branding, extensions, and adding Power BI reports to dazzle the end users and business. When you are finished with this course, you will have the skills to efficiently manage and lock down a SQL Server Reporting Services system.
Table of contents
- Reporting Credential 3m
- Demo: Administrator Navigation in the Portal 5m
- SSRS Roles and Permissions 3m
- Demo: Manage Folder Permissions 4m
- Data Source Credentials 3m
- Demo: Data Source Credentials 5m
- Controlling Options in the Portal 2m
- Demo: Removing Portal Download Menu 2m
- Summarizing Security and Credentials 1m
About the author
Thomas LeBlanc (Microsoft Data Platform MVP) is a Data Enthusiast in Baton Rouge, La. He started his IT career as a COBOL programmer in 1989 while at LSU. Since then he has spent years as a developer, DBA and Data Warehousing/Business Intelligence Architect. Community involve includes the local SQL Server and Analytics User Groups as well as SQLSaturday. Speaking engagements have been a blessing at SQL Pass Summit, Live 360, VSLive and IT Dev Connections.