Learn Azure SQL Database through Demos
summary
Live demos show Azure SQL deployed from the portal with choices: general purpose, business critical or hyperscale (supports up to 100 terabytes and up to 4 readable replicas). Networking compares public endpoint leakage vs private endpoint DNS hides region. Security demos use auditing to blob/storage and Log Analytics, built-in data discovery/classification, dynamic masking with grant unmask/revoke unmask and Azure Defender catching a simulated SQL injection immediately. Performance uses Query Store, dm_db_resource_stats and ALTER DATABASE to scale from 2 vCores to 8 vCores cutting a 1m43s workload roughly in half. High-availability shows business critical failing over almost instantly while general purpose takes a few extra seconds; auto-failover groups preserve endpoints for app continuity.
AI-written summary · about
chapters (11)
- 0:00Start
- 6:25select your networking options
- 6:51use the public endpoint
- 10:26configure azure defender
- 11:43create an azure active directory
- 12:30configure long-term retention
- 18:47merge the audit files
- 24:13set an initial baseline
- 25:34take a look at some performance topics
- 30:53the performance dashboard
- 38:11set up an auto failover group
related talks
49mFrom the Classroom to the Boardroom – Azure SQL DB through Demos
01h 15mChoose Azure SQL Database and Learn What Every Developer Should Know
47mPerfecting business continuity for Azure SQL DB
01h 01mAzure SQL Database-Business Continuity During Disaster
53mOptimizing your Azure SQL Database workloads
51mThe 10 things every developer must absolutely know about Azure SQL
50mSQL Server to Azure SQL: Performance and Availability
19mAzure SQL MI End-to-end Demo Party for DBAs and Devs