majiayu000 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