What is Azure SQL Database?
Azure SQL Database is a fully managed cloud relational database service. Built on the SQL Server engine, it offers automatic patching, backup and high availability.
Deployment Models
- Single Database: Isolated database with independent resources
- Elastic Pool: Cost optimization with shared resources
- Managed Instance: SQL Server compatibility with PaaS benefits
- Hyperscale: For databases exceeding 100 TB
Key Features
- Automatic backup (up to 35-day PITR)
- Active geo-replication for DR
- Intelligent Performance tuning
- Advanced Threat Protection
- Transparent Data Encryption
- Serverless compute tier
