What Is Azure SQL Database?
Azure SQL Database is a fully managed platform-as-a-service (PaaS) relational database built on the same engine as Microsoft SQL Server, handling patching, backups, and high availability automatically so teams focus on schema design and queries instead of OS or database-engine maintenance.
Cricket analogy: It is like the BCCI providing a curator-maintained, ICC-certified pitch at Eden Gardens for every match — the groundstaff handles rolling and watering so Virat Kohli's team just turns up and plays, never worrying about the surface itself.
Deployment Models and Service Tiers
Azure SQL Database offers two purchasing models — DTU-based (bundled compute, storage, and I/O units across Basic, Standard, and Premium tiers) and vCore-based (separate compute and storage, with General Purpose, Business Critical, and Hyperscale tiers) — plus a Serverless compute tier that auto-pauses and auto-scales vCores based on workload demand to save cost on intermittent workloads.
Cricket analogy: Choosing DTU versus vCore is like a franchise picking between a fixed squad salary cap (IPL's bundled purse) versus negotiating batting and bowling budgets separately, and Serverless is like paying only for overs actually bowled in a rain-affected match.
Elastic Pools
Elastic pools let you group multiple databases with variable and unpredictable usage patterns onto a shared pool of resources, so you pay for the pool's aggregate DTUs or vCores rather than provisioning peak capacity for every database individually — ideal for SaaS applications with one database per tenant.
Cricket analogy: It's like an IPL franchise sharing one squad of net bowlers across all its age-group teams rather than hiring separate bowlers for the under-19s, seniors, and women's team, since not all teams train at peak intensity simultaneously.
-- Connect using Azure AD auth (sqlcmd) and create a table
sqlcmd -S myserver.database.windows.net -d mydb -G
CREATE TABLE dbo.Orders (
OrderId INT IDENTITY(1,1) PRIMARY KEY,
CustomerName NVARCHAR(100) NOT NULL,
OrderDate DATETIME2 DEFAULT SYSUTCDATETIME(),
Amount DECIMAL(10,2) NOT NULL
);
-- Move an existing database into an elastic pool via Azure CLI
az sql db update \
--resource-group myRG \
--server myserver \
--name mydb \
--elastic-pool myPoolAzure SQL Database takes automatic full, differential, and transaction log backups, retaining them for point-in-time restore (PITR) — 7 days by default on most tiers, up to 35 days configurable — with no manual backup jobs required.
High Availability and Security
Azure SQL Database provides built-in high availability through zone-redundant configurations and auto-failover groups that replicate to a secondary region, combined with security features like Transparent Data Encryption (TDE) at rest, Azure AD authentication, and firewall rules that deny all public access by default until explicit IP ranges are allowlisted.
Cricket analogy: Auto-failover groups are like a team having a designated vice-captain (MS Dhoni backing up Rohit Sharma) ready to take over instantly if the captain is injured, ensuring the innings continues without a break in play.
Azure SQL Database firewalls deny all inbound connections by default — even from Azure services in some configurations — so forgetting to add your client IP or enable 'Allow Azure services' will silently block valid application traffic; never widen the firewall to 0.0.0.0-255.255.255.255 in production.
- Azure SQL Database is a fully managed PaaS relational database based on the SQL Server engine.
- Two purchasing models exist: DTU-based (bundled) and vCore-based (compute/storage separated).
- Serverless compute tier auto-pauses and auto-scales, ideal for intermittent workloads.
- Elastic pools share resources across many databases with variable usage, common in multi-tenant SaaS.
- Automatic backups support point-in-time restore without manual backup jobs.
- Auto-failover groups and zone redundancy provide built-in high availability.
- TDE, Azure AD auth, and default-deny firewalls provide layered security.
Practice what you learned
1. Which Azure SQL Database compute tier automatically pauses during inactivity to save cost?
2. What is the primary benefit of placing multiple databases into an elastic pool?
3. By default, how does the Azure SQL Database firewall treat inbound connections?
4. What does Transparent Data Encryption (TDE) protect in Azure SQL Database?
5. Which feature provides automatic replication to a secondary region for disaster recovery in Azure SQL Database?
Was this page helpful?
You May Also Like
Cosmos DB Basics
Azure's globally distributed, multi-model NoSQL database service, covering APIs, partitioning, consistency levels, and request units.
Azure Key Vault Basics
Azure's managed service for securely storing and accessing secrets, keys, and certificates, covering access models, managed identities, and rotation.
Azure RBAC Explained
Azure's role-based access control system for granting fine-grained permissions to resources through role definitions, scopes, and role assignments.