Migrate Databases to the Cloud - Why, How and Best Practices

on YouTube ↗56m

" summary

Covers moving on‑premise OLTP to Azure SQL Database with concrete limits and steps: 500 GB max per database and database throughput unit (DTU) quotas (example: Standard_0 ≈ 10 DTUs) drive vertical vs horizontal designs, use SQL Database Migration Wizard to detect incompatibilities, deploy schema with SSDT or BACPAC then load data with BCP (use -m -n, large batch sizes, parallel streams) or import/export, implement sharding via Elastic Scale for TBs, expect 99.99% SLA, instant tier scaling, and note read committed snapshot is enforced by default.

AI-written summary · about

" chapters (36)

1. 0:00Introduction
2. 1:20Agenda
3. 2:00Why
4. 5:25Private Cloud
5. 6:45Visual Subscription
6. 10:30Behind the Scenes
7. 15:00Maximum Size
8. 15:50Availability
9. 16:20Business Continuity
10. 16:35Scale and Performance
11. 18:30Database throughput unit
12. 19:40Scale
13. 20:55Upgrade
14. 22:00Flexibility
15. 22:50Scalability
16. 23:10Horizontal Scale
17. 25:10Elastic Scale
18. 25:55Backups
19. 26:45Microsoft Data Center
20. 27:50Database Rates
21. 28:55Standard vs Premium
22. 29:55Agile secret
23. 30:40Compliance
24. 33:25How to move data
25. 34:55Database complexity
26. 36:25Database migration wizard
27. 39:25Twist the scenario
28. 40:25Best Practices
29. 41:25Transparent Data Encryption
30. 42:25Optimistic Concurrency
31. 44:25Create Database Projects
32. 46:25Snapshot Feature
33. 50:25Identify which tables change
34. 52:25Change Data Capture
35. 54:25Choosing the Right Tool
36. 55:25Call to Action

" related talks

• 50mMigrating data solutions to the cloud - a checklist.Kristina Mishra · SQLBits 2019
• 50mSQL Modernization Journey with Tools, Assets & Migration Best PracticesDes FitzGerald, Ajith Krishnan, Neel Ball · SQLBits 2024
• 50mSQL Server to Azure SQL: Performance and AvailabilityBob Ward, Anna Hoffman · SQLBits 2020
• 54mAzure Best Practices for Lift and ShiftMichael Wall · Global Azure 2021
• 57mDe-risk Your Azure SQL Migration: 5 Critical ConsiderationsKevin Kline, Dustin Dorsey, Denis McDowell · SQLBits 2020
• 20mChoosing the Right Data Store--An Overview of Azure Data Platform ChoicesJoey D'Antoni · SQLBits 2023
• 25mMigrating VLDBs from Oracle to Azure Database for PostgreSQLAdithya Kumaranchath · POSETTE: An Event for Postgres 2026
• 49mWhat to look out for when migrating your data to the cloud; is it REALLY the right choice?Emanuele Meazzo · SQLBits 2024