Availability & Configuration
SQL Server 2014
| Expert
- 13 Videos | 1h 20m 25s
- Includes Assessment
- Earns a Badge
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 SSASconfigure SSAS to allow for impersonation using Kerberosconfigure SSAS for trusted delegation using Kerberosuse SQL Server Profiler to test for impersonated or delegated identitydescribe granting access to external users using HTTP and verify the prerequisites in IISconfigure external access to SSAS using HTTP by creating the application pool, virtual directory in IIS, and configure IIS authenticationconfigure external access to SSAS using HTTP by granting data access permissions and then testing the configuration
-
implement Dynamic Dimension Security within a cubecreate roles and define permissions to grant access at different levels for multidimensional modelsdescribe the high availability solutions that can be used by SQL Serverdescribe how AlwaysON Failover Cluster Instances can be used to ensure high availability for a SQL Server instancedescribe how AlwaysON Availability Groups can be used for high availability for a SQL Server instancedescribe how AlwaysON Availability Groups can be used with SSAS and SSRS
IN THIS COURSE
-
1.Authentication Mechanisms6m 47sUP NEXT
-
2.Configuring SSAS to Allow for Impersonation5m 13s
-
3.Configuring SSAS for Trusted Delegation6m
-
4.Testing for Impersonated or Delegated Identity3m 45s
-
5.Configuring External Access to SSAS (Part 1)4m 32s
-
6.Configuring External Access to SSAS (Part 2)6m 34s
-
7.Configuring External Access to SSAS (Part 3)8m 8s
-
8.Implementing Dynamic Dimension Security9m 12s
-
9.Creating Roles for Access at Different Levels5m 43s
-
10.SQL Server High Availability Solutions6m 43s
-
11.Designing an AlwaysON Failover Cluster Instance6m 32s
-
12.Designing AlwaysON Availability Groups5m 58s
-
13.AlwaysON Availability Groups and Interoperability5m 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.