What is Azure SQL?
Azure SQL is Microsoft's cloud-based SQL database platform built on the SQL Server engine. It provides familiar T-SQL capabilities while reducing the infrastructure and operational management required from DBAs.
The main Azure SQL options are:
Service | Best suited for |
|---|---|
Azure SQL Database | Cloud-native applications and individual databases |
Azure SQL Managed Instance | SQL Server migrations requiring high compatibility |
SQL Server on Azure VMs | Workloads requiring full SQL Server and OS control |
The choice depends mainly on how much control you need versus how much infrastructure management you want Microsoft Azure to handle.
Azure SQL Database
Azure SQL Database is a fully managed database platform-as-a-service (PaaS).
Microsoft manages much of the underlying infrastructure, including:
Operating system
Database software patching
Hardware
Storage infrastructure
High availability infrastructure
Automated backups
This allows DBAs to focus more on database performance, security, availability, and application workloads rather than server administration.
A typical architecture might look like:
Application
|
v
Azure Application Service
|
v
Azure SQL Database
|
+---- Azure Backup / Point-in-Time Restore
|
+---- Microsoft Entra ID
|
+---- Azure MonitorAzure SQL Managed Instance
Azure SQL Managed Instance provides a higher level of SQL Server compatibility while still providing a managed PaaS experience.
It is particularly useful when migrating existing SQL Server applications to Azure where changing the application or database architecture is difficult.
Managed Instance supports many SQL Server features that may not be available in Azure SQL Database.
For DBAs, it can provide a useful middle ground:
SQL Server compatibility + managed Azure infrastructure
SQL Server on Azure Virtual Machines
SQL Server on Azure VMs provides the greatest level of control.
Here, the DBA manages the SQL Server installation running on an Azure virtual machine.
This means you are responsible for areas such as:
Windows/Linux operating system management
SQL Server installation and patching
SQL Server configuration
Storage configuration
Backup strategy
Monitoring
Security hardening
The advantage is flexibility. The disadvantage is that more DBA and infrastructure administration is required.
Azure SQL Security
Security is a major component of Azure SQL architecture.
Common security capabilities include:
Microsoft Entra authentication
Firewall rules
Private endpoints
Transparent Data Encryption (TDE)
Always Encrypted
Dynamic Data Masking
Microsoft Defender for SQL
Auditing
Vulnerability assessment
Role-based access control (RBAC)
A common enterprise architecture is:
Users / Applications
|
v
Microsoft Entra ID
|
v
Private Endpoint
|
v
Azure SQL
|
+---- Microsoft Defender for SQL
|
+---- Azure Monitor
|
+---- Log AnalyticsAzure SQL Performance Monitoring
From a DBA perspective, monitoring remains important even though Azure manages much of the infrastructure.
Important metrics include:
Join the conversation! Your thoughts help the community grow.