Azure supports different flavors of SQL/NoSQL and Graph databases. In this article, let's explore different database options supported by Azure.
The following image describes different database services supported by Azure.
1. Azure SQL
Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement. Azure SQL Database is always running on the latest stable version of the SQL Server database engine and patched OS with 99.99% availability. Azure offers different services of SQL databases. Users can choose any of those services that match their requirements.
Basically, Azure SQL databases are classified into three categories.
- SQL Database: Azure SQL Database is a relational database-as-a-service (DBaaS). Here the user doesn't need to take care of the underlying platform or anything.
- SQL Managed Instances: Azure SQL Managed Instance falls into the industry category of Platform-as-a-Service (PaaS) and is best for most migrations to the cloud.
- SQL Virtual Machines: SQL Server on Azure VM falls into the industry category Infrastructure-as-a-Service (IaaS) and allows you to run SQL Server inside a fully managed virtual machine (VM) in Azure.
Next, let's find out each of the above services in detail.
1.1. SQL Database
When using SQL Database, you pay-as-you-go with options to scale up or out for greater power without interruption. It is a fully managed SQL Server database engine based on the latest stable Enterprise Edition of SQL Server.
There are different deployment options supported by SQL databases. those are.
Single Database: The single database resource type creates a database in Azure…