Securing Azure-Arc Enabled Data Services

This course provides an overview of security for Azure Arc-enabled data services, focusing on authentication and authorization for Arc-enabled SQL Managed Instance. Demonstrations cover Active Directory integration, customer- and system-managed keytabs, Azure Key Vault, deployment permissions, and SQL logins and groups.

Syllabus

Introduction.
Mélony Qin, Program Manager, Microsoft Azure Data.
Security features comparisons between Azure versus a traditional SQL server.
How Azure ensures proper Deployment Permissions.
Certifications that should be used.
What authentications and authorizations are used?.
SQL Linux containers auth with Keytab file.
Arcenabled SQL Managed Instance.
Enable Active Directory (AD) Authentication.
Demo; Deploying Arcenabled SQL Managed Instance in Active Directory (AD) with customer managed keytab (CMK) .
Demo; Reading keytab information from Azure Key Vault (AKV).
Demo; Deploying Arcenabled SQL Managed Instance in Active Directory (AD) with system managed keytab .
Authorization; Can users and groups be created like any other version of SQL?.