~/talk

A to Z Azure SQL Security Concepts

Talkat SQLBits 2023 · 2023-03-14..03-18· [security]
slides:none on file

Covers concrete Azure SQL controls: four network layers from allow Azure services to private endpoint (demonstrates client_net_address 10.0.0.7 matching VM), RBAC roles (Owner/Contributor/Reader) and requirement that Azure AD server admin creates database users, TLS minimum-version enforcement, TDE with Service‑Managed vs customer managed key using Key Vault (key versions and expiration), enclave-based encryption-in-use, Dynamic Data Masking, Microsoft Defender vulnerability scans (six initial findings shown), and auditing into Log Analytics with queryable dashboards.

AI-written summary · about

  1. 0:00Introduction and context
  2. 1:54Defense in depth analogy
  3. 5:54Network security layers
  4. 13:59Identity and access management
  5. 20:24Data encryption methods
  6. 28:57Data in use and masking
  7. 31:28Threat protection and auditing
  8. 39:01Data governance and closing
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.