Availability & Configuration

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

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 25 Likes 25  
Likes 49 Likes 49  
Likes 36 Likes 36  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 209 Likes 209  
Likes 267 Likes 267  
COURSE T-SQL Queries
Likes 112 Likes 112