Azure Databases: Azure SQL and Cosmos DB
Rather than running your own database server on a VM, Azure offers fully-managed database services, Azure handles patching, backups, and failover for you.
Azure SQL Database
A managed, relational SQL Server database, a good fit if your data has a stable, well-defined schema.
az sql server create --name kodstigen-sql --resource-group kodstigen-rg --admin-user sqladmin --admin-password "P@ssword123!"
az sql db create --name kodstigen-db --server kodstigen-sql --resource-group kodstigen-rg --service-objective S0Azure Cosmos DB
A globally distributed, multi-model NoSQL database, if the flexible, document-style data you worked with in MongoDB sounded appealing, Cosmos DB even offers an API that speaks MongoDB's wire protocol.
az cosmosdb create --name kodstigen-cosmos --resource-group kodstigen-rg --kind GlobalDocumentDBWhich one?
| Azure SQL Database | Cosmos DB | |
|---|---|---|
| Data shape | Rows and columns | Flexible documents |
| Best for | Structured, relational data | High-scale, globally distributed apps |
| Query language | T-SQL | SQL-like, or MongoDB/Cassandra/Gremlin APIs |
NOTE
Both services are billed based on the capacity/tier you provision, always check the pricing tier before creating one, it's easy to leave an expensive tier running by accident.