🗄️ Azure SQL Database¶

🌟 Service Overview¶

Azure SQL Database provides a modern SQL Server database engine in the cloud with automatic updates, scaling, and enterprise-grade features without infrastructure management.

🔥 Key Value Propositions¶

Fully Managed: Automated patching, backups, and high availability
Intelligent Performance: Automatic tuning and query optimization
Hyperscale: Up to 100TB databases with fast backups
Built-in Security: Advanced threat protection and encryption
Elastic Scaling: Scale up/down or scale out with elastic pools

🏗️ Deployment Options¶

Option	Description	Best For
Single Database	Standalone database	Simple applications, microservices
Elastic Pool	Shared resources across databases	Multi-tenant SaaS
Managed Instance	Near 100% SQL Server compatibility	Lift-and-shift migrations
Hyperscale	Massively scalable architecture	Large databases (> 4TB)

📊 Pricing Tiers¶

vCore-based Model¶

-- General Purpose - balanced compute and I/O
-- Best for most workloads
CREATE DATABASE ProductionDB
  (EDITION = 'GeneralPurpose', SERVICE_OBJECTIVE = 'GP_Gen5_4');

-- Business Critical - high performance
-- Best for mission-critical applications
CREATE DATABASE CriticalDB
  (EDITION = 'BusinessCritical', SERVICE_OBJECTIVE = 'BC_Gen5_8');

-- Hyperscale - massive scale
-- Best for large databases
CREATE DATABASE LargeDB
  (EDITION = 'Hyperscale', SERVICE_OBJECTIVE = 'HS_Gen5_4');

🚀 Quick Start¶

Create Azure SQL Database¶

# Create resource group
az group create --name myresourcegroup --location eastus

# Create SQL Server
az sql server create \
  --name mysqlserver \
  --resource-group myresourcegroup \
  --location eastus \
  --admin-user sqladmin \
  --admin-password 'YourPassword123!'

# Create database
az sql db create \
  --resource-group myresourcegroup \
  --server mysqlserver \
  --name mydatabase \
  --service-objective GP_Gen5_2 \
  --backup-storage-redundancy Local

# Configure firewall
az sql server firewall-rule create \
  --resource-group myresourcegroup \
  --server mysqlserver \
  --name AllowAzureServices \
  --start-ip-address 0.0.0.0 \
  --end-ip-address 0.0.0.0

Connect with Python¶

import pyodbc
from azure.identity import DefaultAzureCredential

# Connection string with Azure AD authentication
connection_string = """
    Driver={ODBC Driver 18 for SQL Server};
    Server=tcp:mysqlserver.database.windows.net,1433;
    Database=mydatabase;
    Authentication=ActiveDirectoryInteractive;
    Encrypt=yes;
    TrustServerCertificate=no;
"""

# Connect and query
conn = pyodbc.connect(connection_string)
cursor = conn.cursor()

# Create table
cursor.execute("""
    CREATE TABLE Products (
        ProductID INT PRIMARY KEY,
        Name NVARCHAR(100),
        Price DECIMAL(10,2),
        Category NVARCHAR(50)
    )
""")

# Insert data
cursor.execute("""
    INSERT INTO Products VALUES (1, 'Laptop', 999.99, 'Electronics')
""")

# Query data
cursor.execute("SELECT * FROM Products")
for row in cursor.fetchall():
    print(row)

conn.commit()
conn.close()

🔧 Core Features¶

🚀 Hyperscale Tier ¶

Massively scalable architecture supporting databases up to 100TB.

Key Features: - Rapid scale up/down (minutes vs. hours) - Fast database backups (seconds) - Up to 4 readable replicas - Flexible storage auto-grow

📖 Detailed Guide →

💰 Elastic Pools ¶

Share resources across multiple databases for cost optimization.

Key Features: - Pool resources across databases - Automatic scaling - Cost-effective for variable workloads - Perfect for SaaS applications