Availability & Configuration

SQL Server 2014    |    Expert
  • 13 Videos | 1h 26m 55s
  • Includes Assessment
  • Earns a Badge
Likes 9 Likes 9
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

  • Playable
    1. 
    Authentication Mechanisms
    6m 47s
    UP NEXT
  • Playable
    2. 
    Configuring SSAS to Allow for Impersonation
    5m 13s
  • Locked
    3. 
    Configuring SSAS for Trusted Delegation
    6m
    FREE ACCESS
  • Locked
    4. 
    Testing for Impersonated or Delegated Identity
    3m 45s
    FREE ACCESS
  • Locked
    5. 
    Configuring External Access to SSAS (Part 1)
    4m 32s
    FREE ACCESS
  • Locked
    6. 
    Configuring External Access to SSAS (Part 2)
    6m 34s
    FREE ACCESS
  • Locked
    7. 
    Configuring External Access to SSAS (Part 3)
    8m 8s
    FREE ACCESS
  • Locked
    8. 
    Implementing Dynamic Dimension Security
    9m 12s
    FREE ACCESS
  • Locked
    9. 
    Creating Roles for Access at Different Levels
    5m 43s
    FREE ACCESS
  • Locked
    10. 
    SQL Server High Availability Solutions
    6m 43s
    FREE ACCESS
  • Locked
    11. 
    Designing an AlwaysON Failover Cluster Instance
    6m 32s
    FREE ACCESS
  • Locked
    12. 
    Designing AlwaysON Availability Groups
    5m 58s
    FREE ACCESS
  • Locked
    13. 
    AlwaysON Availability  Groups and Interoperability
    5m 19s
    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 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

COURSE Designing BI Infrastructure
Likes 121 Likes 121  
COURSE Microsoft Azure Architect Technologies: Deploying Azure Database Solutions
Likes 30 Likes 30  
BOOK Pro Power BI Architecture: Sharing, Security, and Deployment Options for Microsoft Power BI Solutions

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Designing BI Data Models
Likes 37 Likes 37  
COURSE Data Warehouse Essential: Concepts
Likes 144 Likes 144  
COURSE Advanced SQL Queries
Likes 209 Likes 209