azure-sql-database
Expert knowledge for Azure SQL Database development including troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. Use when planning DTU/vCore tiers, Hyperscale, geo-replication/DR,
By microsoftdocs · 965 installs
npx skills add microsoftdocs/agent-skills --skill azure-sql-database
Source repository · Upstream listing
Azure SQL Database Skill
This skill provides expert guidance for Azure SQL Database. Covers troubleshooting, best practices, decision making, architecture & design patterns, limits & quotas, security, configuration, integrations & coding patterns, and deployment. It combines local quick reference content with remote documentation fetching capabilities.
How to Use This Skill
IMPORTANT for Agent : Use the Category Index below to locate relevant sections. For categories with line ranges (e.g., L35 L120 ), use read file with the specified lines. For categories with file links (e.g., [security.md](security.md) ), use read file on the linked reference file
IMPORTANT for Agent : If metadata.generated at is more than 3 months old, suggest the user pull the latest version from the repository. If mcp microsoftdocs tools are not available, suggest the user install it: [Installation Guide](https://github.com/MicrosoftDocs/mcp/blob/main/README.md)
This skill requires network access to fetch documentation content:
Preferred : Use mcp microsoftdocs:microsoft docs fetch with query string from=learn agent skill . Returns Markdown.
Fallback : Use fetch webpage with query string from=learn agent skill&accept=text/markdown . Returns Markdown.
Category Index
Category Lines Description
Troubleshooting L37 L62 Diagnosing and fixing Azure SQL issues: performance, deadlocks, blocking, CPU/memory, capacity, import/export, connectivity, geo replication, Data Sync, serverless, and log full errors.
Best Practices L63 L79 Best practices for Azure SQL operations: monitoring, auditing, security, HA/DR, failover, read replicas, maintenance, elastic pool tuning, file space, Data Sync, and T SQL adaptation.
Decision Making L80 L107 Guidance for choosing Azure SQL deployment, tiers, pricing, Hyperscale options, DR/HA, automation, reservations, and migration paths (SQL Server, DTU↔vCore, Data Sync, elastic sharding).
Architecture & Design Patterns L108 L126 Architectural patterns for Azure SQL apps: geo replication, DR/BCP, connectivity/routing, sharding & elastic scale, multi tenant SaaS models, Hyperscale internals, and upgrade/failover designs.
Limits & Quotas L127 L142 Limits, quotas, and behaviors for Azure SQL: free tier and offers, DTU/vCore and serverless resource caps, backups immutability, maintenance windows, and billing rules.
Security L143 L209 Securing Azure SQL: authentication (Entra, managed identity, MFA), network/firewall, auditing, threat protection, encryption/TDE, data masking, DR replicas, and compliance/policy configuration.
Configuration L210 L279 Configuring Azure SQL databases and pools: backups, geo replication, failover, scaling, maintenance windows, monitoring/alerts, security (TLS, Always Encrypted), Data Sync, and CLI/PowerShell setup.
Integrations & Coding Patterns L280 L309 Connecting apps and tools to Azure SQL (EF Core, .NET, Node.js, Python, Go), plus PowerShell/CLI automation for auditing, scaling, geo replication, data sync, and streaming/Spark integration.
Deployment L310 L322 Deploying and migrating Azure SQL: CI/CD with GitHub/Terraform, scaling and tier changes (Hyperscale, elastic pools), region moves, zone redundancy, dev environments, and feature availability.
Troubleshooting
Topic URL
Troubleshoot Azure SQL capacity deployment and scaling errors https://learn.microsoft.com/en us/azure/azure sql/capacity errors troubleshoot?view=azuresql
Resolve common Azure SQL database watcher issues https://learn.microsoft.com/en us/azure/azure sql/database watcher faq?view=azuresql
Analyze and prevent deadlocks in Azure SQL Database https://learn.microsoft.com/en us/azure/azure sql/database/analyze prevent deadlocks?view=azuresql
Fix slow database import and export in Azure SQL https://learn.microsoft.com/en us/azure/azure sql/database/database import export hang?view=azuresql
Use RecoveryManager to fix Azure SQL shard maps https://learn.microsoft.com/en us/azure/azure sql/database/elastic database recovery manager?view=azuresql
Troubleshoot Azure SQL Database Elastic Scale issues https://learn.microsoft.com/en us/azure/azure sql/database/elastic scale faq?view=azuresql
Diagnose and fix high CPU in Azure SQL Database https://learn.microsoft.com/en us/azure/azure sql/database/high cpu diagnose troubleshoot?view=azuresql
Troubleshoot performance issues in Azure SQL Hyperscale https://learn.microsoft.com/en us/azure/azure sql/database/hyperscale performance diagnostics?view=azuresql
Diagnose Azure SQL query performance bottlenecks https://learn.microsoft.com/en us/azure/azure sql/database/identify query performance issues?view=azuresql
Monitor and troubleshoot In Memory OLTP storage capacity https://learn.microsoft.com/en us/azure/azure sql/database/in memory oltp monitor space?view=azuresql
Use DMVs to troubleshoot Azure SQL performance https://learn.microsoft.com/en us/azure/azure sql/database/monitoring with dmvs?view=azuresql
Use Azure Resource Health to troubleshoot Azure SQL https://learn.microsoft.com/en us/azure/azure sql/database/resource health to troubleshoot connectivity?view=azuresql
Troubleshoot auto pause and resume in Azure SQL serverless https://learn.microsoft.com/en us/azure/azure sql/database/serverless tier auto pause resume?view=azuresql
Troubleshoot common Azure SQL Data Sync issues https://learn.microsoft.com/en us/azure/azure sql/database/sql data sync troubleshoot?view=azuresql
Troubleshoot transient connectivity errors for Azure SQL https://learn.microsoft.com/en us/azure/azure sql/database/troubleshoot common connectivity issues?view=azuresql
Troubleshoot Azure SQL and Fabric SQL connectivity errors https://learn.microsoft.com/en us/azure/azure sql/database/troubleshoot common errors issues?view=azuresql
Troubleshoot geo replication and redo lag in Azure SQL Database https://learn.microsoft.com/en us/azure/azure sql/database/troubleshoot geo replication redo?view=azuresql
Investigate and fix memory issues in Azure SQL Database https://learn.microsoft.com/en us/azure/azure sql/database/troubleshoot memory errors issues?view=azuresql
Resolve transaction log full errors in Azure SQL Database https://learn.microsoft.com/en us/azure/azure sql/database/troubleshoot transaction log errors issues?view=azuresql db
Identify and resolve blocking in Azure SQL Database https://learn.microsoft.com/en us/azure/azure sql/database/understand resolve blocking?view=azuresql
Resolve known issues in Azure SQL Managed Instance https://learn.microsoft.com/en us/azure/azure sql/managed instance/doc changes updates known issues?view=azuresql
Resolve transaction log full errors in Azure SQL Managed Instance https://learn.microsoft.com/en us/azure/azure sql/managed instance/troubleshoot transaction log errors issues?view=azuresql mi
Best Practices
Topic URL
Analyze Azure SQL monitoring data with KQL and T SQL https://learn.microsoft.com/en us/azure/azure sql/database watcher analyze?view=azuresql
Apply auditing best practices in production Azure SQL https://learn.microsoft.com/en us/azure/azure sql/database/auditing best practices?view=azuresql
Run disaster recovery drills for Azure SQL workloads https://learn.microsoft.com/en us/azure/azure sql/database/disaster recovery drills?view=azuresql
Optimize resource management in dense Azure SQL elastic pools https://learn.microsoft.com/en us/azure/azure sql/database/elastic pool resource management?view=azuresql
Configure and operate Azure SQL failover groups with best practices https://learn.microsoft.com/en us/azure/azure sql/database/failover group sql db?view=azuresql
Manage Azure SQL Database file space efficiently https://learn.microsoft.com/en us/azure/azure sql/database/file space manage?view=azuresql db
Apply HA and DR configuration checklist for Azure SQL https://learn.microsoft.com/en us/azure/azure sql/database/high availability disaster recovery checklist?view=azuresql
Plan for Azure SQL planned maintenance events https://learn.microsoft.com/en us/azure/azure sql/database/planned maintenance?view=azuresql
Configure and use read scale out replicas in Azure SQL https://learn.microsoft.com/en us/azure/azure sql/database/read scale out?view=azuresql
Apply security best practices to Azure SQL Database https://learn.microsoft.com/en us/azure/azure sql/database/secure database?view=azuresql
Apply security best practices for Azure SQL https://learn.microsoft.com/en us/azure/azure sql/database/security best practice?view=azuresql
Apply best practices for Azure SQL Data Sync https://learn.microsoft.com/en us/azure/azure sql/database/sql data sync best practices?view=azuresql
Adapt SQL Server T SQL for Azure SQL Database https://learn.microsoft.com/en us/azure/azure sql/database/transact sql tsql differences sql server?view=azuresql
Decision Making
Topic URL
Decide when to use Azure Hybrid Benefit for Azure SQL https://learn.microsoft.com/en us/azure/azure sql/azure hybrid benefit?view=azuresql
Use Azure SQL decision tree to choose service https://learn.microsoft.com/en us/azure/azure sql/azure sql decision tree?view=azuresql
Understand Copilot in Azure SQL capabilities and usage https://learn.microsoft.com/en us/azure/azure sql/copilot/copilot azure sql faq?view=azuresql
Plan deployment of Always Encrypted secure enclaves https://learn.microsoft.com/en us/azure/azure sql/database/always encrypted enclaves plan?view=azuresql
Plan and manage Azure SQL Database costs https://learn.microsoft.com/en us/azure/azure sql/database/cost management?view=azuresql
Choose Azure SQL disaster recovery options for regional outages https://learn.microsoft.com/en us/azure/azure sql/database/disaster recovery guidance?view=azuresql
Choose migration path from elastic query shard map manager https://learn.microsoft.com/en us/azure/azure sql/database/elastic query horizontal partitioning migration?view=azuresql
Compare Azure SQL Database vs Managed Instance features https://learn.microsoft.com/en us/azure/azure sql/database/features comparison?view=azuresql
Plan and use Hyperscale elastic pools for Azure SQL https://learn.microsoft.com/en us/azure/azure sql/database/hyperscale elastic pool overview?view=azuresql
Choose job automation options for Azure SQL and Synapse https://learn.microsoft.com/en us/azure/azure sql/database/job automation overview?view=azuresql
Plan and manage Azure SQL Hyperscale databases https://learn.microsoft.com/en us/azure/azure sql/database/manage hyperscale database?view=azuresql
Migrate Azure SQL databases from DTU to vCore model https://learn.microsoft.com/en us/azure/azure sql/database/migrate dtu to vcore?view=azuresql
Choose Azure SQL Database vCore vs DTU purchasing https://learn.microsoft.com/en us/azure/azure sql/database/purchasing models?view=azuresql
Choose and use Azure Reservations for Azure SQL compute https://learn.microsoft.com/en us/azure/azure sql/database/reservations discount overview?view=azuresql
Reverse migrate Azure SQL Hyperscale to General Purpose https://learn.microsoft.com/en us/azure/azure sql/database/reverse migrate from hyperscale?view=azuresql
Choose Azure SQL serverless vs provisioned tiers https://learn.microsoft.com/en us/azure/azure sql/database/serverless tier overview?view=azuresql
Decide when to use Azure SQL Hyperscale tier https://learn.microsoft.com/en us/azure/azure sql/database/service tier hyperscale frequently asked questions faq?view=azuresql
Choose and use Hyperscale secondary replica types https://learn.microsoft.com/en us/azure/azure sql/database/service tier hyperscale replicas?view=azuresql
Decide when