Azure SQL Database is a fully managed database engine (Platform as a Service- PaaS). It helps a user to manage database functions such as upgrading, patching, backups, and monitoring without user involvement. Azure SQL Database runs on the latest version of the SQL Server database engine and patched OS with 99.99% availability. It helps a user to create a highly available and high-performance data storage layer for the applications and solutions in Azure. Azure SQL Database allows provide the latest stable version of the Microsoft SQL Server database engine.
Azure SQL Database provides some deployment options for a database:
- Single database: It represents a fully managed, isolated database.
- Elastic pool: It is a collection of single databases with a shared set of resources.
Purchasing models:
User can purchase the SQL Server on Azure through the following way.
- vCore-based purchasing model
- DTU-based purchasing model
- Serverless model
Azure SQL Database service tiers:
- General Purpose/ Standard model
- Business Critical/ Premium service tier model
- Hyper scale service tier model
Azure SQL Database also provides some additional feature:
- Automatic backup
- Point in time restore
- Active geo replication
- Auto failover group
- Zone redundant database
