The 10 things every developer must absolutely know about Azure SQL

on YouTube ↗51m

" summary

Azure SQL is SQL Server and demos show exact behaviors: the optimizer pushes predicates into nested queries, implicit conversions disable indexes, and SET XACT_ABORT (or TRY/CATCH with table variables) controls transaction rollback. Live demos compare rowstore vs columnstore (55s to 4s on a 2‑vCore TPCH run) and graph+columnstore (29s to 3s on 50M likes). Coverage includes read committed snapshot on for versioning and hyperscale named replicas for fast read scale‑out.

AI-written summary · about

" chapters (5)

1. 0:00Start
2. 11:54Beware the (implicit) conversions!
3. 41:27Graph Models
4. 46:16Azure SQL DB Hyperscale
5. 49:13Database Scaleoutability

" related talks

• 01h 15mChoose Azure SQL Database and Learn What Every Developer Should KnowBob Ward, Davide Mauri · Visual Studio Live! Microsoft HQ 2022
• 49mPerformance Features in SQL Server and Azure SQLJavier Villegas · SQL Server Virtual Conference 2021
• 43mLearn Azure SQL Database through DemosAnna Hoffman · SQL Server Virtual Conference 2021
• 50mDeveloper Best Practices for Azure SQL : Avoiding common pitfalls when using the Cloud DatabaseDavide Mauri · SQL Server Virtual Conference 2021
• 50mAchieve peak performance and availability for your SQL Server and Azure SQL workloads with core engiAjay Jagannathan · SQLBits 2022
• 50mAchieve peak performance and availability for your SQL Server and Azure SQL workloads with core engiAjay Jagannathan · SQLBits 2024
• 50mSQL Server to Azure SQL: Performance and AvailabilityBob Ward, Anna Hoffman · SQLBits 2020
• 01h 01mLatest Innovations for SQL and Operational Databases for DevelopersPeter Carlin · Visual Studio Live! Microsoft HQ 2022