Managing Reporting Services
SQL Server 2014
| Expert
- 14 videos | 1h 20m 55s
- Earns a Badge
For optimal performance and security, you must maintain and monitor SQL Server Reporting Services. Learn how to manage the Report Server, including troubleshooting, and performance tuning, and how to configure security.
WHAT YOU WILL LEARN
-
Describe report server security architecture and site level security
Create server level roles and assign users to the roles to allow report server access
Create item level roles to grant permissions to users
Secure a report using different types of roles
Secure a shared data source
Configure stored credentials to allow access to external data for a report
Configure sharepoint groups and permissions for access to report server item -
Manage encryption keys for reporting services
Create snapshots and add them to report history
Create a report history
Manage a reporting services database, including backup and restore, copying, and managing connections
View reporting services log files
Monitor reporting services with sql profiler
Use windows reliability and performance monitor to monitor a report server
IN THIS COURSE
-
5m 58sUpon completion of this video, you will be able to describe the Report Server security architecture and site level security. FREE ACCESS
-
4m 49sIn this video, find out how to create server level roles and assign users to the roles to allow report server access. FREE ACCESS
-
3. Configuring Item Level Security6m 17sLearn how to create item-level roles to grant permissions to users. FREE ACCESS
-
4. Securing Reports Using Roles4m 7sLearn how to secure a report using different types of roles. FREE ACCESS
-
5. Securing Shared Data Source Items5m 36sIn this video, you will learn how to secure a shared data source. FREE ACCESS
-
6. Configuring Stored Credentials5m 30sIn this video, you will learn how to configure stored credentials to allow access to external data for a report. FREE ACCESS
-
7. Configuring SharePoint Groups and Permissions7m 37sIn this video, find out how to configure SharePoint groups and permissions to access Report Server items. FREE ACCESS
-
8. Managing Encryption Keys4m 54sDuring this video, you will learn how to manage encryption keys for Reporting Services. FREE ACCESS
-
9. Creating and Adding Snapshots5m 57sIn this video, you will learn how to create snapshots and add them to your report history. FREE ACCESS
-
10. Creating a Report History4m 23sIn this video, learn how to create a report history. FREE ACCESS
-
11. Managing a Reporting Services Database6m 57sDuring this video, you will learn how to manage a reporting services database, including how to backup and restore, copy, and manage connections. FREE ACCESS
-
12. Viewing Report Services Log Files5m 54sThis video will show you how to view Reporting Services log files. FREE ACCESS
-
13. Monitoring Reporting Services with SQL Profiler5m 47sIn this video, you will use SQL Profiler to monitor Reporting Services. FREE ACCESS
-
14. Using Reliability and Performance Monitor7m 10sIn this video, you will learn how to use Windows Reliability and Performance Monitor to monitor a report server. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
