Skip to main content

Azure SQL Databases

Deployment models

Azure SQL Database provides the three deployment options:

  1. Single is a fully managed, isolated database
  2. Elastic Pool is a collection of single databases with a shared set of resources
  3. Managed Instance is a fully managed instance of the SQL Server

SQL Database Server vs SQL Database

Database Server act as a central administrative point for multiple single or pooled databases, logins, firewall rules, auditing rules, threat detection policies, and failover groups.

Pricing

Azure SQL Database offers two purchasing models

  • Database transaction unit (DU)-based purchasing model
  • Virtual core (vCore)-based purchasing model (recommended)
  • Serverless model (vCore)-based

Azure SQL Database Pricing Model

Backups

Backup frequency

Azure SQL Database creates:

The exact frequency of transaction log backups is based on the compute size and the amount of database activity. When you restore a database, the service determines which full, differential, and transaction log backups need to be restored.

Automatic, geo-redundant backups - Azure SQL Database | Microsoft Learn

Connecting

Azure SQL Database

https://azure.microsoft.com/en-in/products/azure-sql/database/

https://azure.microsoft.com/en-us/products/data-studio

What's Happening to Azure Data Studio? - Azure Data Studio | Microsoft Learn