miniguide

Azure SQL Cheatsheet: Managing Azure Managed Databases

Introduction

This cheatsheet provides essential Azure CLI commands for creating, configuring, and troubleshooting Azure SQL Databases and Managed Instances. It is designed for DevOps professionals managing SQL resources in Azure.

Table of Contents

1. Create Azure SQL Server

az sql server create --name <serverName> --resource-group <rg> --location <location> --admin-user <user> --admin-password <password>

2. Create Azure SQL Database

az sql db create --resource-group <rg> --server <serverName> --name <dbName> --service-objective S0

3. List SQL Databases

az sql db list --resource-group <rg> --server <serverName> --output table

4. Get SQL Database Details

az sql db show --resource-group <rg> --server <serverName> --name <dbName>

5. Update SQL Database

az sql db update --resource-group <rg> --server <serverName> --name <dbName> --service-objective S1

6. Delete SQL Database

az sql db delete --resource-group <rg> --server <serverName> --name <dbName> --yes

7. Set Firewall Rules

az sql server firewall-rule create --resource-group <rg> --server <serverName> --name AllowMyIP --start-ip-address <ip> --end-ip-address <ip>

8. Export Database

az sql db export --admin-password <password> --admin-user <user> --name <dbName> --resource-group <rg> --server <serverName> --storage-key <storageKey> --storage-key-type StorageAccessKey --storage-uri "<blobSasUri>"

9. Import Database

az sql db import --admin-password <password> --admin-user <user> --name <dbName> --resource-group <rg> --server <serverName> --storage-key <storageKey> --storage-key-type StorageAccessKey --storage-uri "<blobSasUri>"

10. Monitor Database Performance

az sql db show-usage --resource-group <rg> --server <serverName> --name <dbName> --output table