Why managed databases matter in Azure - See It in Action

Why Managed Databases Matter

📖 Scenario: You are working as a cloud engineer for a small company that wants to move its data storage to the cloud. The company is considering using Azure's managed database services to simplify their work and improve reliability.

🎯 Goal: Build a simple Azure Resource Manager (ARM) template that creates a managed Azure SQL Database instance. This will help you understand why managed databases matter by seeing how easy it is to configure and deploy one.

📋 What You'll Learn

Create a resource group variable named resourceGroupName with the value myResourceGroup.

Create a variable named location with the value eastus.

Define a managed Azure SQL Server resource with the name mySqlServer in the specified resource group and location.

Define a managed Azure SQL Database resource named myDatabase under the SQL Server.

Set the SKU of the database to Basic tier with capacity 5 DTUs.

Add the final property to enable geo-replication with zone redundancy set to true.

💡 Why This Matters

🌍 Real World

Managed databases simplify cloud database deployment and management, reducing manual work and improving reliability.

💼 Career

Cloud engineers and developers often use managed database services to quickly provision and maintain databases without handling infrastructure details.

1

Create resource group and location variables

Create a variable called resourceGroupName and set it to myResourceGroup. Also create a variable called location and set it to eastus.

Azure

# Your code here

Need a hint?

Use simple variable assignments with the exact names resourceGroupName and location.

2

Define Azure SQL Server resource

Define a variable called sqlServer as a dictionary representing an Azure SQL Server resource with the name mySqlServer, using resourceGroupName and location variables. Include properties for administrator login adminUser set to sqladmin and administrator password adminPassword set to StrongP@ssw0rd!.

Azure

resourceGroupName = "myResourceGroup"
location = "eastus"
# Your code here

Need a hint?

Use a dictionary with keys type, name, location, and properties containing admin login info.

3

Define Azure SQL Database resource

Define a variable called sqlDatabase as a dictionary representing an Azure SQL Database resource named myDatabase under the mySqlServer server. Use the location variable. Set the SKU to Basic tier with capacity 5 DTUs.

Azure

resourceGroupName = "myResourceGroup"
location = "eastus"
sqlServer = {
    "type": "Microsoft.Sql/servers",
    "name": "mySqlServer",
    "location": location,
    "properties": {
        "administratorLogin": "sqladmin",
        "administratorLoginPassword": "StrongP@ssw0rd!"
    }
}
# Your code here

Need a hint?

Use the resource type Microsoft.Sql/servers/databases and set the SKU dictionary with name, tier, and capacity.

4

Enable geo-replication with zone redundancy

Add the property zoneRedundant set to true inside the properties of the sqlDatabase dictionary to enable geo-replication with zone redundancy.

Azure

resourceGroupName = "myResourceGroup"
location = "eastus"
sqlServer = {
    "type": "Microsoft.Sql/servers",
    "name": "mySqlServer",
    "location": location,
    "properties": {
        "administratorLogin": "sqladmin",
        "administratorLoginPassword": "StrongP@ssw0rd!"
    }
}
sqlDatabase = {
    "type": "Microsoft.Sql/servers/databases",
    "name": "mySqlServer/myDatabase",
    "location": location,
    "sku": {
        "name": "Basic",
        "tier": "Basic",
        "capacity": 5
    },
    "properties": {
        # Add zoneRedundant property here
    }
}

Need a hint?

Add the key zoneRedundant with value true inside the properties dictionary of sqlDatabase.