Azure SQL Databases
Deployment models
Azure SQL Database provides the three deployment options:
- Single is a fully managed, isolated database
- Elastic Pool is a collection of single databases with a shared set of resources
- 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
Backups
Backup frequency
Azure SQL Database creates:
- Full backups every week.
- Differential backups every 12 or 24 hours.
- Transaction log backups approximately every 10 minutes.
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
- Azure Data Studio officially retires on February 28, 2026
- MSSQL Extension - VSCode
- Download SQL Server Management Studio (SSMS) | Microsoft Learn
- .NET Interactive with SQL!| .NET Notebooks in Visual Studio Code - .NET Blog
- Polyglot Notebooks
- interactive/docs/working-with-data.md at main · dotnet/interactive · GitHub
#r "nuget: Microsoft.DotNet.Interactive.SqlServer, *-*"