Managing Reporting Services

SQL Server 2014
  • 14 Videos | 1h 25m 25s
  • Earns a Badge
Likes 14 Likes 14
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

  • Playable
    1. 
    Understanding Report Server Security Architecture
    5m 58s
    UP NEXT
  • Playable
    2. 
    Configuring Report Server Level Security
    4m 49s
  • Locked
    3. 
    Configuring Item Level Security
    6m 17s
  • Locked
    4. 
    Securing Reports Using Roles
    4m 7s
  • Locked
    5. 
    Securing Shared Data Source Items
    5m 36s
  • Locked
    6. 
    Configuring Stored Credentials
    5m 30s
  • Locked
    7. 
    Configuring SharePoint Groups and Permissions
    7m 37s
  • Locked
    8. 
    Managing Encryption Keys
    4m 54s
  • Locked
    9. 
    Creating and Adding Snapshots
    5m 57s
  • Locked
    10. 
    Creating a Report History
    4m 23s
  • Locked
    11. 
    Managing a Reporting Services Database
    6m 57s
  • Locked
    12. 
    Viewing Report Services Log Files
    5m 54s
  • Locked
    13. 
    Monitoring Reporting Services with SQL Profiler
    5m 47s
  • Locked
    14. 
    Using Reliability and Performance Monitor
    7m 10s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Likes 10 Likes 10  
Likes 4 Likes 4  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 141 Likes 141  
Likes 209 Likes 209  
COURSE SQL Developer
Likes 152 Likes 152