cloud-azure-sql

Overview

Provides comprehensive guidance for Azure SQL Database, covering database creation, configuration, security, and ongoing management. It helps users ask about Azure SQL, create databases, configure settings, and manage Azure database services.

How This Skill Works

The skill translates user needs into Azure SQL tasks such as provisioning databases, configuring security, and tuning performance. It covers best practices, service features, and practical steps for day-to-day management of Azure SQL resources.

When to Use It

• You need to create a new Azure SQL Database or server.
• You want to configure firewall rules, authentication, or security settings for Azure SQL.
• You need to tune performance, manage backups, or set up high availability for Azure SQL.
• You manage multiple Azure SQL databases/servers across resources and environments.
• You are migrating data to or scaling Azure SQL and require guidance on best practices and tooling.

Quick Start

1. Step 1: Determine deployment option (Single DB, Elastic Pool, or Managed Instance) and chosen SKU.
2. Step 2: Create the SQL server and database, then set security basics (firewall rules and AAD admin).
3. Step 3: Enable automated backups, monitoring, and scaling policies to match your needs.

Best Practices

• Plan deployment size and SKU (Single DB, Elastic Pool, or Managed Instance) before provisioning.
• Enable Azure AD authentication and assign least-privilege roles to users and apps.
• Turn on automated backups with appropriate retention and consider geo-redundancy when needed.
• Secure connectivity with firewall rules, VNET service endpoints, and enforce TLS.
• Implement monitoring and alerting via Azure Monitor and consider automatic tuning for performance.

Example Use Cases

• Create a new Azure SQL Database for a development environment with restricted firewall access for the team.
• Configure Azure AD admin and RBAC to control access to a production database with least privilege.
• Enable automated backups and configure geo-redundant backups for disaster recovery.
• Migrate an on-premises SQL Server to Azure SQL Database using the Data Migration Assistant and validate compatibility.
• Monitor performance with Query Performance Insight and enable automatic tuning to optimize workloads.

Frequently Asked Questions