What it does
Azure SQL Database is Microsoft's managed relational database service for applications that use SQL Server and T-SQL. You create a single database or an elastic pool through the Azure portal, CLI, or PowerShell, then connect with database tools and application drivers. Microsoft handles the database engine and operating-system patching, backups, high availability, and underlying infrastructure, while teams still design schemas, tune queries, and manage access. Its serverless tier can pause when idle, and the free tier offers a bounded monthly allowance for small workloads.
A first database in the Azure SQL hub
The Microsoft Learn quickstart creates a single database in the serverless tier using the Azure portal, Azure CLI, or PowerShell. It requires an Azure subscription and suitable Azure permissions. In the portal, choose a SQL database, select a logical server and workload configuration, then use the Query editor to run a small T-SQL exercise such as:
CREATE TABLE dbo.FeatureFlags (
FlagName nvarchar(80) NOT NULL PRIMARY KEY,
Enabled bit NOT NULL
);
INSERT dbo.FeatureFlags (FlagName, Enabled)
VALUES (N'beta-checkout', 0);
SELECT FlagName, Enabled FROM dbo.FeatureFlags;
This is illustrative SQL, not a command run for this listing. Treat database creation as a cloud-resource decision: choose the subscription, region, compute, storage, backup redundancy, and network access before connecting an application.
Keep the free allowance and billing mode in view
Microsoft documents a free tier with 100,000 vCore-seconds of serverless compute, 32 GB of data, and 32 GB of backup storage per database each month, with up to ten free General Purpose databases in a subscription. The free-tier setup lets an owner choose to auto-pause at the limit or continue with billable overage. Outside that allowance, cost depends on the purchasing model (vCore or DTU), compute tier, storage, and workload. Compare those choices against a real workload rather than treating the free allowance as a production cost estimate.
What Microsoft manages, and what remains yours
Azure handles routine engine and operating-system patching, backups, and high availability. Application-specific administration still matters: design tables and indexes, secure credentials and network access, monitor queries, and choose whether serverless pause/resume behavior fits the app. The portal's Development workload preset can be a starting point, but Microsoft notes that it does not decide database licensing or all configuration choices for you.
Strengths
- Automates SQL and operating-system patching, backups, high availability, and common maintenance tasks.
- Offers vCore and DTU purchasing models and provisioned or serverless compute choices for different workloads.
- Create a single database through the Azure portal, CLI, or PowerShell, then query it in the portal's Query editor.
Watch out for
- Creating the database requires an Azure subscription and appropriate Azure permissions; it is not a local database install.
- The free allowance is capped, and usage beyond it can be billed or the database can be configured to pause.
Best for
- Applications that already use SQL Server or T-SQL and need a managed relational database.
- Development and test databases where serverless compute and a bounded free allowance are useful.
- Teams moving SQL workloads to Azure without managing the database host and engine patching themselves.
Sources
- Azure SQL Database | Microsoft Azure (Oct 25, 2026)
- What is the Azure SQL Database service? - Azure SQL Database | Microsoft Learn (Oct 25, 2026)
- Create a Single Database - Azure SQL Database | Microsoft Learn (Oct 25, 2026)
- Try Azure SQL Database for free - Azure SQL Database | Microsoft Learn (Oct 25, 2026)
- Plan and Manage Costs - Azure SQL Database | Microsoft Learn (Oct 25, 2026)