Developer Best Practices for Azure SQL : Avoiding common pitfalls when using the Cloud Database

on YouTube ↗50m

" summary

Covers concrete fixes and demos: implement retry logic and microsoft.data.sqlclient auto-reconnect for transient disconnects, prefer opening connections only for a single query, and use Poly/tenacity where available; send sets not chatty single-row calls (TVPs, JSON, BULK) — a 1,000-row upload goes from 34s -> 0.8s bulk copy in the demo; rely on read committed snapshot default for nonblocking reads, use OUTPUT to return deleted/updated rows in one statement, and use partition switching/truncate partitions to drop large ranges quickly.

AI-written summary · about

" chapters (13)

1. 0:00Start
2. 1:27Resilient Connection
3. 3:18Sqlclient
4. 4:01Demo
5. 22:18Network Latency
6. 26:20Using the Recommitted Snapshot
7. 26:40Read Committed Snapshot
8. 30:47Accelerated Data Recovery
9. 31:32Accelerated Database Recovery
10. 32:12Avoid Very Long Transaction
11. 37:33Load Data into Azure Sql
12. 41:28Read the Json File
13. 46:54Truncate Table

" related talks

• 51mThe 10 things every developer must absolutely know about Azure SQLDavide Mauri · SQLBits 2023
• 01h 15mChoose Azure SQL Database and Learn What Every Developer Should KnowBob Ward, Davide Mauri · Visual Studio Live! Microsoft HQ 2022
• 53mOptimizing your Azure SQL Database workloadsSanjay Mishra, Denzil Ribeiro, Dimitri Furman · SQLBits 2020
• 50mSQL Server to Azure SQL: Performance and AvailabilityBob Ward, Anna Hoffman · SQLBits 2020
• 56mMigrate Databases to the Cloud - Why, How and Best PracticesAmit Bansal · Great Indian Developer Summit 2015
• 49mFrom the Classroom to the Boardroom – Azure SQL DB through DemosSilvano Coriani, Sanjay Mishra · SQLBits 2023
• 58mFixing poor performance patterns in Azure SQL Database applicationsMartin Cairney · NDC Sydney 2020
• 59mLessons Learned from the Trenches: Connectivity and Performance Tips&TricksJose Manuel Jurado Diaz · NDC London 2021