🗄️ Azure SQL Database - Advanced

High Availability and Geo-Replication

# Create active geo-replication
az sql db replica create \
  --resource-group myResourceGroup \
  --server myserver \
  --database mydatabase \
  --partner-server myserver-secondary \
  --partner-resource-group myResourceGroup

# Initiate failover
az sql db failover \
  --resource-group myResourceGroup \
  --server myserver-secondary \
  --database mydatabase

Advanced Security

# Enable Transparent Data Encryption
az sql db tde set \
  --resource-group myResourceGroup \
  --server myserver \
  --database mydatabase \
  --status Enabled

# Enable advanced security
az sql db threat-policy update \
  --resource-group myResourceGroup \
  --server myserver \
  --database mydatabase \
  --state Enabled \
  --retention-days 30

Performance Optimization

-- Create filtered index
CREATE INDEX idx_active_users 
ON users(status, created_date) 
WHERE status = 'active';

-- Query optimization
EXEC sp_executesql 
  N'SELECT * FROM users WHERE status = @status',
  N'@status NVARCHAR(50)',
  @status = 'active';

Key Takeaways

• **Geo-replication** enables disaster recovery

• **Encryption** protects data

• **Indexing** improves query performance

• **Monitoring** identifies bottlenecks

Next Steps

Explore Cosmos DB for globally distributed NoSQL.