1 Azure SQL Database: a managed relational engine
Azure SQL Database is a fully managed Platform-as-a-Service (PaaS) relational database built on the SQL Server engine. Unlike a SQL Server running on a VM, you never patch the operating system, install the engine, or schedule your own backups — Azure handles high availability, patching and automated backups for you.
You choose a purchasing model: the DTU model bundles compute, memory and I/O into a single unit, while the newer vCore model lets you size CPU and storage independently and is required for advanced tiers like Hyperscale and Serverless. A single logical server is just an administrative container for one or more databases; it is not a machine you can log into.
# Create a logical server and a database in the vCore General Purpose tier
az sql server create -g rg-app -n sql-app-01 \
--admin-user sqladmin --admin-password '<StrongP@ss>'
az sql db create -g rg-app -s sql-app-01 -n appdb \
--edition GeneralPurpose --family Gen5 --capacity 2 \
--compute-model Provisioned