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 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 47sAfter completing this video, you will be able to describe the different authentication mechanisms supported by SSAS. FREE ACCESS
-
5m 13sLearn how to configure SSAS to allow impersonation using Kerberos. FREE ACCESS
-
3. Configuring SSAS for Trusted Delegation6mIn this video, learn how to configure SSAS for trusted delegation using Kerberos. FREE ACCESS
-
4. Testing for Impersonated or Delegated Identity3m 45sLearn how to use SQL Server Profiler to test for impersonation or delegation of identity. FREE ACCESS
-
5. Configuring External Access to SSAS (Part 1)4m 32sUpon 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
-
6. Configuring External Access to SSAS (Part 2)6m 34sIn 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
-
7. Configuring External Access to SSAS (Part 3)8m 8sLearn how to configure external access to SSAS using HTTP by granting data access permissions and then testing the configuration. FREE ACCESS
-
8. Implementing Dynamic Dimension Security9m 12sFind out how to implement Dynamic Dimension Security within a cube. FREE ACCESS
-
9. Creating Roles for Access at Different Levels5m 43sDuring this video, you will learn how to create roles and define permissions to grant access at different levels for multidimensional models. FREE ACCESS
-
10. SQL Server High Availability Solutions6m 43sUpon completion of this video, you will be able to describe the high availability solutions that SQL Server can use. FREE ACCESS
-
11. Designing an AlwaysON Failover Cluster Instance6m 32sUpon 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
-
12. Designing AlwaysON Availability Groups5m 58sAfter 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
-
13. AlwaysON Availability Groups and Interoperability5m 19sUpon 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.
