Azure SQL Database
Fully managed, intelligent SQL in the cloud
★ 4.4
Azure SQL Database is a fully managed relational database-as-a-service built on the Microsoft SQL Server engine. It provides built-in intelligence for performance tuning and threat detection, with 99.99% SLA, automated backups, geo-replication, and serverless auto-scaling options.
Fonctionnalités
✓ Fully managed with automated patching and updates
✓ Automatic backups with point-in-time recovery (up to 10 years)
✓ 99.99% SLA with zone redundancy option (99.995%)
✓ Active geo-replication with up to 4 readable secondaries
✓ Serverless compute with auto-pause and auto-scale
✓ Hyperscale tier supporting up to 100 TB
✓ Built-in AI for performance tuning and threat detection
✓ Full SQL Server T-SQL compatibility
Avantages
- + Full SQL Server compatibility - easy migration from on-premises
- + Deep Azure ecosystem integration (Functions, App Service, Power BI)
- + Enterprise-grade security with comprehensive compliance certifications
- + Flexible scaling with DTU or vCore pricing and serverless options
- + Built-in disaster recovery with geo-replication and auto-failover
Inconvénients
- − Complex pricing structure - DTU vs vCore can be confusing
- − Azure vendor lock-in makes multi-cloud difficult
- − Less configuration control than self-hosted SQL Server
- − Learning curve for Azure networking and portal
- − Costs can grow quickly beyond free tier