Navigating Modern Authentication in SQL

on YouTube ↗51m

" summary

Overview of concrete steps and outcomes for replacing passwords with Entra-based auth for Azure SQL and Arc‑enabled SQL Server: shows Defender for cloud vulnerability scans flagging SQL authentication and open public endpoints, demos enabling a group as Entra administrator, connecting from an Azure VM with managed identities (system and user‑assigned), and enforcing Entra‑only auth to disable sa; covers SQL Server 2022 + Azure Arc requirements, Microsoft Data SQL client/driver versions, and using Conditional Access and Single Sign‑On to require MFA and centralize access.

AI-written summary · about

" chapters (13)

1. 0:00Modern SQL authentication intro
2. 1:16Passwords security risk
3. 6:15Microsoft Entra ID
4. 17:48Entra ID with SQL
5. 27:17SQL security principles
6. 29:56Logins and users with Entra ID
7. 31:45Demo: Entra auth in SQL
8. 37:54Managed identities connection
9. 39:02Enforcing Entra-only auth
10. 41:12Programmatic Entra connections
11. 43:00SQL access with Entra policies
12. 47:19Single sign-on with Entra Connect
13. 50:13Why adopt Entra ID

" related talks

• 48mAn in-depth review of the latest advancements in authentication for Azure SQL and SQL Server 2022Jakub Szymaszek · SQLBits 2023
• 45mSecure your Intelligent Applications with Microsoft EntraPamela Fox, Anthony Shaw, James Casey, Den Delimarsky, Matt Gotteiner, Josh Oh · Microsoft Build 2024
• 13mSecretless access to Azure SQL server using Managed IdentityHallstein Brøtan · NDC Oslo 2022
• 45mA to Z Azure SQL Security ConceptsDeepthi Goguri · SQLBits 2023
• 48mProtecting the confidentiality and integrity of your high value data with Azure SQL and SQL Server 2Jakub Szymaszek · SQLBits 2023
• 32mDesigning secure Azure SQL Database solutionsMichael Howard · Microsoft Build 2023
• 11mBuild identity into your apps within minutes!Levent Besik · Microsoft Build 2024
• 46mUnderstanding Azure Active Directory for Data ProfessionalsJoey D'Antoni · SQLBits 2020