Azure SQL Database Management

This section provides comprehensive documentation on managing your Azure SQL Database instances, including programmatic access via REST APIs, PowerShell, and Azure CLI.

Note: Ensure you have the necessary permissions and authentication set up before performing any management operations.

Key Management API Operations

Azure SQL Database offers a rich set of APIs for managing databases, servers, and related resources. Here are some commonly used operations:

REST API Operations

Interact with Azure SQL Database using the Azure Resource Manager (ARM) REST API.

Create a SQL Database

PUT https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}?api-version=2021-11-01

Request Body Example:

{
  "location": "West US",
  "sku": {
    "name": "Basic",
    "tier": "Basic"
  },
  "properties": {
    "collation": "SQL_Latin1_General_CP1_CI_AS"
  }
}

Get Database Details

GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}?api-version=2021-11-01

List Databases in a Server

GET https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases?api-version=2021-11-01

Delete a Database

DELETE https://management.azure.com/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.Sql/servers/{serverName}/databases/{databaseName}?api-version=2021-11-01

Important: Refer to the official Azure SQL REST API documentation for the complete list of operations and parameters.

Azure PowerShell Cmdlets

Manage Azure SQL Database using the Az.Sql module.

Create a SQL Database

New-AzSqlDatabase -ResourceGroupName "MyResourceGroup" -ServerName "MyServer" -DatabaseName "MyDatabase" -Edition Basic

Get Database Details

Get-AzSqlDatabase -ResourceGroupName "MyResourceGroup" -ServerName "MyServer" -DatabaseName "MyDatabase"

List Databases

Get-AzSqlDatabase -ResourceGroupName "MyResourceGroup" -ServerName "MyServer"

Remove a Database

Remove-AzSqlDatabase -ResourceGroupName "MyResourceGroup" -ServerName "MyServer" -DatabaseName "MyDatabase"

Note: Ensure the Az PowerShell module is installed and updated. Run Install-Module -Name Az -Scope CurrentUser -Force and Update-Module -Name Az.

Azure CLI Commands

Manage Azure SQL Database using the Azure Command-Line Interface.

Create a SQL Database

az sql db create --resource-group MyResourceGroup --server MyServer --name MyDatabase --edition Basic

Show Database Details

az sql db show --resource-group MyResourceGroup --server MyServer --name MyDatabase

List Databases

az sql db list --resource-group MyResourceGroup --server MyServer

Delete a Database

az sql db delete --resource-group MyResourceGroup --server MyServer --name MyDatabase

Note: Ensure the Azure CLI is installed and logged in. Run az login.

Managing Server Properties

Beyond individual databases, you can manage server-level configurations such as firewall rules, virtual network rules, and auditing policies using similar REST API calls, PowerShell cmdlets, or Azure CLI commands.

Common Management Tasks

Creating and deleting databases
Resizing database services (DTUs/vCores)
Configuring firewall rules
Managing server-level auditing
Setting up failover groups
Configuring threat detection policies
Performing backups and restores

For detailed information on each management task and specific commands, please refer to the relevant sub-sections within this documentation.