AS

Relational Databases

Azure SQL Database

azure.microsoft.com · checked 14 Oct 2026

A managed cloud relational database built on the Microsoft SQL Server engine.

How it plugs in

—Public API
NoOpen source
YesFree tier

Signal on Relational Databases6.7#4 of 38

Microsoft provides Azure SQL Database as a managed cloud database for relational workloads. The service covers provisioning, patches, backups, monitoring, and availability while supporting transactional and analytical use. Developers work with standard T-SQL, Microsoft tools, client libraries, JSON, and API options. A monthly free allowance is available, while paid use depends on compute, storage, backup, and service tier.

Azure SQL Database home page

Review

In a line

Built on SQL Server, Azure SQL Database delivers relational database capabilities as a fully managed cloud PaaS. Microsoft runs the database service operations instead of requiring customers to maintain its servers.

What it does

Transactional and analytical applications can use the service, which supports most standard SQL language, query-processing, and management features. Serverless tiers vary compute for intermittent or unpredictable workloads, and elastic pools allow multiple databases to share resources.

With Hyperscale, compute and storage scale independently, while scale-out supports as many as 30 named replicas. Native vector search connects with Azure OpenAI and Azure AI Search for AI application development.

Backups remain available from 1 to 35 days, defaulting to seven; long-term retention extends full-backup storage to as much as 10 years. The service also provides high availability, disaster recovery, and snapshot backups for fast restoration.

How it connects

You can administer servers and databases through the Azure portal, SQL Server Management Studio, Visual Studio Code’s MSSQL extension, PowerShell, Azure CLI, REST API, or Transact-SQL. Client libraries are documented for .NET, Go, Node.js, PHP, Python, and Ruby across Windows, Linux, and macOS.

Native JSON and REST are supported, while Data API builder provides REST and GraphQL APIs. Azure Functions can connect to the service, and SQL data can be replicated into Microsoft Fabric for near-real-time analysis. Applications may sign in with SQL logins or Microsoft Entra ID.

This is proprietary Microsoft cloud software, not open source.

Good fit

Azure SQL Database suits teams building modern applications or running important workloads that need Microsoft-managed operations. Microsoft takes care of provisioning, patching, backups, monitoring, and high availability.

It is a practical match for organizations already using Azure services, SQL Server tools, or standard T-SQL. Serverless, elastic-pool, and Hyperscale options address different workload patterns, including AI-oriented architectures.

Watch for

The service is cloud-only, so it is not the self-hosted SQL Server option. Network firewalls block access until specific IP addresses or virtual-network traffic are allowed.

Costs may be difficult to predict as compute, storage, backup, and service tiers change. Once a database uses its monthly free quota, it can pause until the following month or continue running with excess consumption billed at the normal General Purpose serverless rates.

According to the feature comparison, the ceiling is 192 vCores and 128 TB of storage. Check workload limits, cross-database needs, and expected usage before moving from the free allowance.

Pricing

Azure provides a subscription-lifetime free allowance. Each subscription can cover as many as 10 General Purpose databases, each receiving 100,000 serverless vCore-seconds plus 32 GB of data and 32 GB of backup storage per month. There is no free trial.

Pay-as-you-go pricing has no listed rate. Charges are usage-based, with compute, storage, and backup billed separately according to service tier and provisioned resources.

Verdict

Azure SQL Database is a fit when Microsoft-managed maintenance and SQL Server compatibility are priorities in a cloud service. It is especially suitable for Azure-based applications, variable workloads, and projects that can use the free monthly allowance.

Consider alternatives if you need open-source software, self-hosting, or a simple fixed bill. Buyers with small budgets or heavy input/output workloads should model usage carefully because paid costs vary by tier and resource consumption.

Our take

Azure SQL Database suits organizations seeking relational SQL capabilities without managing server upkeep. Managed backups, patching, availability, familiar Microsoft tools, and Azure connections reduce operational work. The monthly free allowance can support small projects but has per-database limits and may pause or generate usage charges afterward. Paid consumption pricing separates compute, storage, backup, and tier costs, so estimate those needs before committing. It is not intended for open-source or self-hosted deployments.

  • Microsoft takes responsibility for provisioning, patching, backups, monitoring, and high availability.
  • Supports standard T-SQL and common Microsoft management tools.
  • The monthly free allowance supports up to 10 databases.
  • Provides serverless compute, elastic pools, and Hyperscale scaling.
  • The service includes high availability, disaster recovery, and selectable backup-retention periods.
  • Free databases may pause or incur overage after monthly limits.
  • It is proprietary Microsoft cloud software rather than open source.
  • Cloud delivery requires firewall and network access setup.
  • The feature comparison gives a ceiling of 192 vCores and 128 TB of storage.
  • Pick it ifAzure applications needing managed relational SQL; Teams using SQL Server tools and T-SQL; Variable workloads that fit serverless or elastic pools
  • Skip it ifYou need an open-source database or self-managed deployment.; You require a simple fixed price for unpredictable usage.; Your design depends on needs beyond the listed resource ceiling.

Pricing

The subscription-lifetime free offer covers up to 10 General Purpose databases, each with monthly vCore-second, data-storage, and backup-storage limits. Paid consumption bills compute, storage, and backup separately; no rate is listed.

  • Free offer100,000 vCore seconds · 32 GB data storage · 32 GB backup storage · 10 databases per subscriptionFree
  • Azure SQL Database free offerMonthly for the life of the subscription · Up to 10 databases · 100,000 serverless vCore-seconds per database · 32 GB storage per databaseFree
  • Azure SQL Database free tierMonthly free allowance for the life of the Azure subscription · Up to 10 General Purpose databases per subscription · 100,000 vCore seconds per database · 32 GB data storage and 32 GB backup storage per databaseFree
  • Azure SQL Database pay-as-you-goHourly/usage based · Single databases or elastic pools · DTU or vCore purchasing · Compute, storage and backup billed separatelyOn request
  • Pay as you goUsage-based; pay only for what you use, with no long-term commitment or upfront payment · Price depends on service tier, provisioned compute and storage, and backup storage; pricing page displays rates as "$-"On request

As learn.microsoft.com lists them, checked 22 Sept 2026.

Questions

Is Azure SQL Database open source?

No. Microsoft offers it as a proprietary cloud service.

Does Azure SQL Database have a free plan?

Yes. For the subscription’s lifetime, up to 10 General Purpose databases receive monthly usage and storage allowances.

What happens after the free allowance is used?

It may stop until the next month, or keep operating while usage above the allowance is billed at standard General Purpose serverless rates.

Which programming languages can connect to it?

Microsoft documents connections from .NET, Go, Node.js, PHP, Python, and Ruby applications on Windows, Linux, and macOS.

Can it expose APIs?

Native JSON and REST are available, and Data API builder adds REST and GraphQL APIs.

How long are backups retained?

Standard retention is 1 to 35 days, with seven days as the default; full backups can be kept for up to 10 years through long-term retention.

Does it run on my own server?

No. Azure SQL Database is Microsoft’s cloud PaaS offering; self-managed SQL Server containers and virtual machines are separate options.