Azure SQL
Deploy managed databases on Azure.
Create SQL Database
Create server
az sql server create
--name myserver
--resource-group mygroup
--admin-user sqladmin
--admin-password SecureP@ss123
Create database
az sql db create
--resource-group mygroup
--server myserver
--name mydb
--service-objective S1
Firewall Rules
az sql server firewall-rule create
--resource-group mygroup
--server myserver
--name AllowAzure
--start-ip-address 0.0.0.0
--end-ip-address 0.0.0.0
Cosmos DB
az cosmosdb create
--name mycosmosdb
--resource-group mygroup
--default-consistency-level Session
Best Practices
-
Enable transparent data encryption
-
Use Azure AD authentication
-
Implement geo-replication
-
Configure automated backups
-
Use private endpoints