Managing Reporting Services

SQL Server 2014    |    Expert
  • 14 videos | 1h 20m 55s
  • Earns a Badge
Rating 4.4 of 11 users Rating 4.4 of 11 users (11)
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 58s
    Upon completion of this video, you will be able to describe the Report Server security architecture and site level security. FREE ACCESS
  • 4m 49s
    In this video, find out how to create server level roles and assign users to the roles to allow report server access. FREE ACCESS
  • Locked
    3.  Configuring Item Level Security
    6m 17s
    Learn how to create item-level roles to grant permissions to users. FREE ACCESS
  • Locked
    4.  Securing Reports Using Roles
    4m 7s
    Learn how to secure a report using different types of roles. FREE ACCESS
  • Locked
    5.  Securing Shared Data Source Items
    5m 36s
    In this video, you will learn how to secure a shared data source. FREE ACCESS
  • Locked
    6.  Configuring Stored Credentials
    5m 30s
    In this video, you will learn how to configure stored credentials to allow access to external data for a report. FREE ACCESS
  • Locked
    7.  Configuring SharePoint Groups and Permissions
    7m 37s
    In this video, find out how to configure SharePoint groups and permissions to access Report Server items. FREE ACCESS
  • Locked
    8.  Managing Encryption Keys
    4m 54s
    During this video, you will learn how to manage encryption keys for Reporting Services. FREE ACCESS
  • Locked
    9.  Creating and Adding Snapshots
    5m 57s
    In this video, you will learn how to create snapshots and add them to your report history. FREE ACCESS
  • Locked
    10.  Creating a Report History
    4m 23s
    In this video, learn how to create a report history. FREE ACCESS
  • Locked
    11.  Managing a Reporting Services Database
    6m 57s
    During this video, you will learn how to manage a reporting services database, including how to backup and restore, copy, and manage connections. FREE ACCESS
  • Locked
    12.  Viewing Report Services Log Files
    5m 54s
    This video will show you how to view Reporting Services log files. FREE ACCESS
  • Locked
    13.  Monitoring Reporting Services with SQL Profiler
    5m 47s
    In this video, you will use SQL Profiler to monitor Reporting Services. FREE ACCESS
  • Locked
    14.  Using Reliability and Performance Monitor
    7m 10s
    In 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.

YOU MIGHT ALSO LIKE

Course Working with Google Cloud SQL: An Introduction to Cloud SQL
Rating 4.7 of 37 users Rating 4.7 of 37 users (37)
Course CompTIA Cloud+: Cloud Logging, Monitoring, Alerting & Optimization
Rating 4.7 of 47 users Rating 4.7 of 47 users (47)
Course CompTIA Cloud+: Cloud Security Controls
Rating 4.6 of 86 users Rating 4.6 of 86 users (86)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Analyzing Query Plans
Rating 4.6 of 44 users Rating 4.6 of 44 users (44)
Course Database Design
Rating 4.3 of 224 users Rating 4.3 of 224 users (224)
Course Objects & Retrieving Data
Rating 4.6 of 164 users Rating 4.6 of 164 users (164)