Choose Azure SQL Database and Learn What Every Developer Should Know

on YouTube ↗01h 15m

" summary

Shows concrete choices and demos: use Azure.Identity managed identities for passwordless connectivity with one-line GetTokenAsync tokens, enable Microsoft Defender for SQL to detect injection, and rely on Microsoft.Data.SqlClient (or Polly.NET/Tenacity) for built-in retry policies. Describes Hyperscale replicas (up to ~30 named replicas) that spin up compute independent of storage, cites a customer with 1.6 trillion rows served in ~27 ms, contrasts columnstore vs rowstore, and explains optimizer fixes like parameter-sensitive plans and DOP feedback at compat level 160.

AI-written summary · about

" chapters (13)

1. 0:00Start
2. 0:57Agenda
3. 3:47Foundations - Azure SQL family, Azure SQL DB tiers, Azure SQL DB SKUs, programming languages support
4. 8:55Security - Building a secure application, going passwordless, avoiding SQL injection, getting proactive secuirity monitoring via Microsoft Defender
5. 24:36Scalability - Building a scalable application, smart SQL programming, scaling-out the database, connection strings best practices
6. 41:08Query processor, cost-based optimization, DAG and executing plans, Intelligent Query Processing
7. 54:21Indexes - Columnstore and Rowstore indexes, Clustered and Non-clustered index
8. 57:42Mult-Model support - JSON, Graph, Geospatial
9. 1:03:20Retry Logic - Microsoft.Data.SqlClient, Polly.NET, Tenacity
10. 1:05:25Is Azure SQL database a good choice if I have 100 Billions rows to manage?
11. 1:07:20Session Summary
12. 1:08:02Additional resources and books
13. 1:09:05Questions and Answers

" related talks

• 51mThe 10 things every developer must absolutely know about Azure SQLDavide Mauri · SQLBits 2023
• 43mLearn Azure SQL Database through DemosAnna Hoffman · SQL Server Virtual Conference 2021
• 49mFrom the Classroom to the Boardroom – Azure SQL DB through DemosSilvano Coriani, Sanjay Mishra · SQLBits 2023
• 50mDeveloper Best Practices for Azure SQL : Avoiding common pitfalls when using the Cloud DatabaseDavide Mauri · SQL Server Virtual Conference 2021
• 51mAzure SQL Hyperscale Deep DiveDenzil Ribeiro, Paraic Nolan · SQLBits 2020
• 37mSpecialBob Ward, Anna Hoffman, Buck Woody · DEVintersection 2021 Orlando
• 20mChoosing the Right Data Store--An Overview of Azure Data Platform ChoicesJoey D'Antoni · SQLBits 2023
• 50mAchieve peak performance and availability for your SQL Server and Azure SQL workloads with core engiAjay Jagannathan · SQLBits 2022