Availability & Configuration

SQL Server 2014    |    Expert
  • 13 videos | 1h 20m 25s
  • Includes Assessment
  • Earns a Badge
Rating 4.4 of 16 users Rating 4.4 of 16 users (16)
For an effective BI solution, users must be able to access the data they require, when they require it. Learn how to design and implement strategies to secure your data and provide high availability in a BI infrastructure.

WHAT YOU WILL LEARN

  • Describe the different authentication mechanisms supported by ssas
    Configure ssas to allow for impersonation using kerberos
    Configure ssas for trusted delegation using kerberos
    Use sql server profiler to test for impersonated or delegated identity
    Describe granting access to external users using http and verify the prerequisites in iis
    Configure external access to ssas using http by creating the application pool, virtual directory in iis, and configure iis authentication
    Configure external access to ssas using http by granting data access permissions and then testing the configuration
  • Implement dynamic dimension security within a cube
    Create roles and define permissions to grant access at different levels for multidimensional models
    Describe the high availability solutions that can be used by sql server
    Describe how alwayson failover cluster instances can be used to ensure high availability for a sql server instance
    Describe how alwayson availability groups can be used for high availability for a sql server instance
    Describe how alwayson availability groups can be used with ssas and ssrs

IN THIS COURSE

  • 6m 47s
    After completing this video, you will be able to describe the different authentication mechanisms supported by SSAS. FREE ACCESS
  • 5m 13s
    Learn how to configure SSAS to allow impersonation using Kerberos. FREE ACCESS
  • Locked
    3.  Configuring SSAS for Trusted Delegation
    6m
    In this video, learn how to configure SSAS for trusted delegation using Kerberos. FREE ACCESS
  • Locked
    4.  Testing for Impersonated or Delegated Identity
    3m 45s
    Learn how to use SQL Server Profiler to test for impersonation or delegation of identity. FREE ACCESS
  • Locked
    5.  Configuring External Access to SSAS (Part 1)
    4m 32s
    Upon completion of this video, you will be able to describe how to grant access to external users using HTTP and verify the prerequisites in IIS. FREE ACCESS
  • Locked
    6.  Configuring External Access to SSAS (Part 2)
    6m 34s
    In this video, you will configure external access to SSAS using HTTP by creating the application pool and virtual directory in IIS, and configuring IIS authentication. FREE ACCESS
  • Locked
    7.  Configuring External Access to SSAS (Part 3)
    8m 8s
    Learn how to configure external access to SSAS using HTTP by granting data access permissions and then testing the configuration. FREE ACCESS
  • Locked
    8.  Implementing Dynamic Dimension Security
    9m 12s
    Find out how to implement Dynamic Dimension Security within a cube. FREE ACCESS
  • Locked
    9.  Creating Roles for Access at Different Levels
    5m 43s
    During this video, you will learn how to create roles and define permissions to grant access at different levels for multidimensional models. FREE ACCESS
  • Locked
    10.  SQL Server High Availability Solutions
    6m 43s
    Upon completion of this video, you will be able to describe the high availability solutions that SQL Server can use. FREE ACCESS
  • Locked
    11.  Designing an AlwaysON Failover Cluster Instance
    6m 32s
    Upon completion of this video, you will be able to describe how AlwaysON Failover Cluster Instances can be used to ensure high availability for a SQL Server instance. FREE ACCESS
  • Locked
    12.  Designing AlwaysON Availability Groups
    5m 58s
    After completing this video, you will be able to describe how AlwaysON Availability Groups can be used for high availability for a SQL Server instance. FREE ACCESS
  • Locked
    13.  AlwaysON Availability  Groups and Interoperability
    5m 19s
    Upon completion of this video, you will be able to describe how AlwaysON Availability Groups can be used with SSAS and SSRS. 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

Channel Database Business Intelligence
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Course Data Loading & Visualization in Power BI: Loading Data from Databases
Rating 5.0 of 4 users Rating 5.0 of 4 users (4)
Book Beginning Power BI for Business Users: Learning to Turn Data into Insights

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Extract, Transform, & Load
Rating 4.5 of 71 users Rating 4.5 of 71 users (71)
Course Professional in Human Resources: Organizational Development
Rating 4.5 of 202 users Rating 4.5 of 202 users (202)
Course Data Quality Projects
Rating 4.5 of 18 users Rating 4.5 of 18 users (18)