Azure SQL Database
azure.microsoft.com
- Free plan
- Windows
- macOS
- Linux
- Web
- iPhone and iPad
- Android
- API
What Azure SQL Database is
Azure SQL Database is a cloud-native relational database service built on the SQL Server engine and delivered as a fully managed cloud platform. Microsoft handles provisioning, patching, backups, monitoring, and high availability. Developers can use standard T-SQL through the Azure portal, SQL Server Management Studio, Visual Studio Code's MSSQL extension, and compatible application frameworks. Native JSON support is available, and Data API builder provides REST and GraphQL APIs. The Hyperscale tier scales compute and storage independently and supports scale-out with up to 30 named replicas. AI-oriented applications can use native vector search plus connections to Azure OpenAI and Azure AI Search. The service connects with Azure Functions and can replicate SQL data into Microsoft Fabric for near-real-time querying and analysis. Security and governance use a multilayered approach that includes Microsoft Defender for SQL. High availability, disaster recovery, and snapshot-based backups support recovery and quick restores. The free offer allows up to 10 General Purpose databases per subscription, each with monthly allowances for compute, data storage, and backup storage. When a database reaches those limits, it can auto-pause or continue running with usage billed at standard General Purpose serverless rates.
Who it suits
Azure SQL Database suits application teams that want a managed SQL Server-based database for modern, mission-critical, or AI-ready workloads. It also fits developers needing T-SQL, JSON, REST or GraphQL access, Azure integrations, and managed availability without operating database infrastructure.
Good to know, and what to watch
- Fully managed provisioning, patching, backups, and monitoring
- High availability, disaster recovery, and snapshot-based restores
- Hyperscale supports independent compute and storage scaling
- Up to 30 named replicas in Hyperscale
- Native vector search and Azure AI connections
- REST and GraphQL APIs through Data API builder
- Free tier limits compute, data, and backup storage
- Only 10 General Purpose databases per subscription on the free offer
- Usage beyond free limits can incur serverless charges
- Pay-as-you-go pricing depends on selected resources
Plans
Every plan and priceFree offer
Azure SQL Database pay-as-you-go
Pay as you go
Azure SQL Database free offer
Free plan
Getting started
- Open the Azure SQL Database product page
- Start the free offer or choose the pay-as-you-go plan
- Create a General Purpose database in Azure
- Connect with the Azure portal, SQL Server Management Studio, or Visual Studio Code's MSSQL extension
- Use T-SQL or expose data through Data API builder
- Connect Azure services such as Azure Functions if needed
Limits to check
The free offer covers up to 10 General Purpose databases per subscription. Each database receives 100,000 vCore seconds, 32 GB of data storage, and 32 GB of backup storage monthly; reaching the limits can pause the database or trigger standard serverless billing if it remains online.
The Club's review
Azure SQL Database is a Microsoft-managed relational database service running on the SQL Server engine. It is a strong fit for application teams that already use T-SQL and Azure, especially when reducing database operations work matters more than controlling the underlying server.
Its managed resilience, scaling options, and AI integrations make it suitable from prototypes to demanding production systems, but free-tier quotas and usage-based pricing require active cost management.
Overview
Azure SQL Database is a cloud PaaS: Microsoft handles provisioning, patching, backups, monitoring, and high availability. That removes much of the routine administration involved in running SQL Server yourself. You still need to select an appropriate service tier and monitor consumption, particularly when a workload can outgrow the free allowance.
The service is aimed at modern application development, mission-critical workloads, and AI-oriented architectures. Standard T-SQL and familiar Microsoft tooling make migration and development more straightforward for SQL Server teams. Conversely, organizations that require direct server control or a non-relational model should consider another type of database.
Key features
Managed resilience
High availability, disaster recovery, and snapshot-based backups provide a solid operational baseline. Snapshot restores are useful when a recent recovery point matters, while Microsoft-managed monitoring and patching reduce the staffing burden of keeping a database service healthy. Backup retention is 7 days, so longer retention requirements need separate planning.
Scaling and replicas
The Hyperscale tier independently scales compute and storage and supports scale-out with up to 30 named replicas. That is a meaningful option for applications whose data volume and processing demand grow at different rates. Read replicas are supported, although the tier and provisioned resources still determine what the deployment costs.
Development and integration
Teams can work through the Azure portal, SQL Server Management Studio, or Visual Studio Code's MSSQL extension, and use compatible application frameworks with standard T-SQL. Native JSON support broadens its usefulness for mixed data shapes. Data API builder provides REST and GraphQL APIs, while integrations with Azure Functions and Microsoft Fabric support event-driven applications and near-real-time analysis.
AI and security
Native vector search, plus connections to Azure OpenAI and Azure AI Search, gives developers a direct route to AI-enabled applications without abandoning a relational core. Microsoft Defender for SQL contributes a multilayered security and governance approach, which is most valuable for teams already standardizing on Azure controls.
Pricing
Free offer
The Free offer costs nothing and includes up to 10 General Purpose databases per subscription. Each database receives 100,000 vCore seconds, 32 GB of data storage, and 32 GB of backup storage per month. The Azure SQL Database free tier costs nothing with the same monthly allowance for the life of the Azure subscription. It suits experiments, small applications, and low-volume development, not workloads that regularly exceed those caps.
When a database reaches its monthly free limits, it can auto-pause until the next month. Alternatively, it can remain online, with usage beyond the allowance billed at standard General Purpose serverless rates. That choice trades continuity for potentially unexpected charges.
Pay as you go
Pay as you go has custom pricing rather than a published fixed price. It is usage-based, with no long-term commitment or upfront payment, and the bill depends on service tier, provisioned compute and storage, and backup storage. This flexibility suits variable workloads, but budgeting requires estimating resource consumption instead of relying on a single subscription price.
Platforms
Azure SQL Database is delivered as a cloud service and supports Android, iOS, Linux, macOS, web, and Windows clients, along with API access. Its maximum connections figure is 30, so applications with connection-heavy designs should account for that constraint when choosing an architecture.
Who it's for
Choose it for Azure-based application teams, SQL Server developers using T-SQL, and organizations that want Microsoft to operate availability, backups, patching, and recovery. It also fits projects combining relational transactions with vector search, Azure AI services, Functions, or Fabric analytics.
It is a weaker choice for teams needing self-hosted control, a permanently free database with no usage ceilings, or predictable fixed pricing. The free tier is best for modest workloads, and pay-as-you-go requires disciplined resource and quota monitoring.
Pros and cons
Pros
- Managed operations: Microsoft runs provisioning, patching, monitoring, backups, and high availability.
- Resilience built in: Disaster recovery and snapshot backups support quick restores.
- Growth path: Hyperscale separates compute and storage scaling and supports up to 30 named replicas.
- AI-ready interfaces: Vector search and Azure OpenAI and Azure AI Search connections support current AI application patterns.
- Useful tooling: T-SQL, SSMS, Visual Studio Code's MSSQL extension, REST, and GraphQL cover common development workflows.
Cons
- Free-tier ceilings: Ten databases per subscription and 100,000 vCore seconds, 32 GB data, and 32 GB backup per database each month limit sustained workloads.
- Overage risk: Staying online after a quota is reached incurs serverless charges.
- Variable budgeting: Pay-as-you-go cost changes with tier and provisioned resources.
- Connection limit: A 30-connection maximum can constrain connection-intensive designs.
Alternatives
For a broader database comparison, see Database Software, Relational Databases, or Spatial Databases.
- MySQL is a freemium, GPL-licensed option for SQL and NoSQL applications with replication and high-availability components, available on self-hosted systems as well as major desktop and Linux platforms.
- Amazon DynamoDB suits teams wanting a managed NoSQL service with a free tier of 25 WCUs, 25 RCUs, 25 GB storage, and 25 replicated WCUs per region and payer account.
- Microsoft SQL Server is preferable when you need SQL Server editions such as Enterprise or Standard per core rather than a fully managed Azure database.
- Firestore fits document-oriented applications, with standard-edition allowances including 50,000 document reads and 20,000 document writes per day.
- Amazon RDS is the alternative for managed relational databases on AWS, including a free tier that can last up to 12 months for eligible accounts.
- SQLite is the better choice for a free, embedded engine with no separate server process or license requirement.
- Azure Cosmos DB for NoSQL is suited to API-first NoSQL workloads with a free tier of 1,000 RU/s and 25 GB storage.
- MarkLogic is an alternative for teams seeking a document database with a noncommercial Developer plan.
Verdict
Choose Azure SQL Database when you want Microsoft-managed SQL Server capabilities with built-in availability, recovery, Azure integrations, and AI features. It is strongest for Azure-centered teams that value operational simplicity and T-SQL compatibility. Look elsewhere if your usage regularly exceeds the free quotas, if you need self-hosted control, or if a fixed, predictable price is essential.
The verdict
Choose Azure SQL Database when you want Microsoft-managed SQL Server capabilities with built-in availability, recovery, Azure integrations, and AI features. The free offer is useful for limited workloads within its monthly allowances. Look elsewhere if your usage regularly exceeds those quotas or if you need a fixed price; pay-as-you-go cost varies by tier and provisioned resources.
Questions people ask
Is there a free plan?
Yes. The free offer is free and includes a monthly allowance for the life of the Azure subscription.
What does the free offer include?
It covers up to 10 General Purpose databases per subscription, with 100,000 vCore seconds, 32 GB of data storage, and 32 GB of backup storage per database each month.
What happens after free limits are reached?
A database can auto-pause until the next month or stay online with usage beyond the allowance billed at standard General Purpose serverless rates.
Which interfaces can connect to the service?
Azure SQL Database supports standard T-SQL through the Azure portal, SQL Server Management Studio, Visual Studio Code's MSSQL extension, and compatible application frameworks.
Does it support APIs and AI workloads?
It supports native JSON, REST and GraphQL APIs through Data API builder, native vector search, and connections to Azure OpenAI and Azure AI Search.
Is a paid plan available?
Yes. Pay as you go uses usage-based billing with no long-term commitment or upfront payment; rates depend on service tier, compute, storage, and backup storage.
What the maker publishes
- AI capabilities
- The product supports native vector search and connections to Azure OpenAI and Azure AI Search for building AI applications. source
- APIs and data models
- The product supports native JSON and REST and GraphQL APIs through Data API builder. source
- Authentication
- Applications can authenticate with SQL logins or Microsoft Entra ID, formerly Azure Active Directory. source
- Availability and recovery
- The platform includes high availability, disaster recovery, and snapshot-based backups for quick restores. source
- Backup retention
- Backups are retained for 1 to 35 days, with seven days configured by default, and long-term retention can keep full backups for up to 10 years. source
- Compliance
- Microsoft states that Azure has more than 100 compliance certifications, including over 50 for specific regions and countries. source
- Developer languages
- Microsoft documents client connectivity for .NET, Go, Node.js, PHP, Python and Ruby on Windows, Linux and macOS. source
- Development interfaces
- Azure SQL Database supports standard T-SQL and can be accessed through the Azure portal, SQL Server Management Studio, Visual Studio Code's MSSQL extension, and compatible application frameworks. source
- Documentation depth
- Microsoft Learn provides conceptual guidance, quickstarts, tutorials, API references, resource-limit tables, code samples and troubleshooting material. source
- Elastic pools
- Elastic pools let multiple databases share resources so workloads with different usage patterns can be managed together. source
- Free plan
- Yes source
- Free tier limit
- The free offer provides up to 10 General Purpose databases per subscription, each with 100,000 vCore seconds, 32 GB of data, and 32 GB of backup storage monthly. source
- Hyperscale
- The Hyperscale tier independently scales compute and storage and supports scale-out with up to 30 named replicas. source
- Hyperscale
- Hyperscale can scale to meet demand and supports up to 30 named read replicas. source
- Independent performance criticism
- TechRadar rated Azure SQL Database its security pick but said tested performance needed improvement compared with AWS. source
- Integrations
- Azure SQL Database can connect to Azure services such as Azure Functions and replicate SQL data into Microsoft Fabric for near-real-time querying and analysis. source
- Intended workloads
- Microsoft describes Azure SQL Database as designed for modern application development, mission-critical workloads, and AI-ready architectures. source
- Licence
- Azure SQL Database is a proprietary Microsoft cloud service rather than an open-source database; licensing is bundled or discounted through Azure pricing and Azure Hybrid Benefit. source
- Limit: G2 cost and feature gaps
- G2 reviewers report rising costs at higher DTU or vCore levels, limited cross-database queries and less detailed troubleshooting than on-premises SQL Server. source
- Limit: Trustpilot billing/support
- Trustpilot complaints include unexpected or disputed Azure charges and slow or inadequate support responses. source
- Limit: TrustRadius pricing
- TrustRadius reviewers repeatedly describe pricing as difficult to understand or predict and expensive for smaller or high-IO workloads. source
- Limit: TrustRadius tooling
- Reviewers mention missing or weaker cross-server connections, bulk-loading, export, SQL worksheet and management capabilities compared with on-premises tools. source
- Maker founded
- Microsoft was founded in 1975. source
- Maker headquarters
- Microsoft’s head office is in Redmond, Washington, United States. source
Checked against the maker's pages on 14 Oct 2026.