Understanding Azure Active Directory for Data Professionals

on YouTube ↗46m

" summary

Explains how Azure Active Directory differs from on‑prem AD (LDAP/Kerberos vs SAML/OAuth), shows AD Connect syncing choices, and demos logging into Azure SQL Database and Managed Instance using Azure Data Studio and SSMS with MFA. Covers using service principal identities for automation (required to add AAD users to Azure SQL), guest access across tenants, device join for Windows 10, app proxy for publishing on‑prem apps, advanced threat detection, and which premium features need per‑user licensing.

AI-written summary · about

" chapters (21)

1. 0:00Introduction
2. 3:10What is Azure Active Directory
3. 5:34Shared Responsibility
4. 6:29Main Users
5. 12:28Azure AD Terms
6. 19:20Azure AD Integration
7. 21:18Azure AD Connect Demo
8. 25:17Applications Supported
9. 28:33Microsoft Authenticator
10. 29:28Multifactor Authentication
11. 31:25Azure Managed Instance
12. 33:25Azure SQL Demo
13. 37:14Identity Challenges
14. 38:04Join Windows 10 Machines
15. 39:16Single Identity Access Management
16. 40:14Identity Driven Security
17. 42:00Advanced Threat Detection
18. 43:15Threat Analytics
19. 44:01Platform for Development
20. 44:47Graph API
21. 45:17Summary

" related talks

• 48mAn in-depth review of the latest advancements in authentication for Azure SQL and SQL Server 2022Jakub Szymaszek · SQLBits 2023
• 50mManaging Enterprise and Consumer Identity with Azure Active DirectoryNick Pinheiro · NDC Sydney 2016
• 55mOffensive Azure SecuritySergey Chubarov · Global Azure Virtual 2021
• 13mSecretless access to Azure SQL server using Managed IdentityHallstein Brøtan · NDC Oslo 2022
• 45mA to Z Azure SQL Security ConceptsDeepthi Goguri · SQLBits 2023
• 50mAttacking and Defending the Microsoft Cloud (Office 365 & Azure AD)Sean Metcalf, Mark Morowczynski · Black Hat USA 2019
• 51mIntroduction to Azure Data PlatformJavier Villegas · AzConf 2020
• 50mHybrid Active Directory Attacks: Anatomy and DefensesDerek Melber · RSA Conference 2023