Back to Skills
Skill

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 building, debugging, or optimizing Azure SQL Database applications. Not for Azure Database for MariaDB (use azure-database-mariadb), Azure Database for MySQL (use azure-database-mysql), Azure Database for PostgreSQL (use azure-database-postgresql), Azure SQL Managed Instance (use azure-sql-managed-instance).

From azure
Install
1
Run in your terminal
$
npx claudepluginhub atc-net/atc-agentic-toolkit
Tool Access

This skill uses the workspace's default tool permissions.

Skill Content

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: This file may be large. Use the Category Index below to locate relevant sections, then use read_file with specific line ranges (e.g., L136-L144) to read the sections needed for the user's question This skill requires network access to fetch documentation content. Use mcp_microsoftdocs:microsoft_docs_fetch to retrieve full articles.

  • Fallback: Use the built-in WebFetch tool if the Microsoft Learn MCP server is not available.

Category Index

CategoryLinesDescription
TroubleshootingL37-L59Diagnosing and fixing Azure SQL issues: performance (CPU, memory, deadlocks, blocking), capacity/log, import/export, connectivity, geo-replication, Data Sync, and Managed Instance errors.
Best PracticesL60-L76Best practices for Azure SQL operations: monitoring, security, HA/DR, failover, read scale-out, maintenance, auditing, file space, Data Sync, and post-migration behavior.
Decision MakingL77-L102Guidance for choosing Azure SQL tiers, pricing models, DR/HA, Hyperscale options, automation, licensing/Hybrid Benefit, and migration paths between models and features.
Architecture & Design PatternsL103-L121Architectural patterns for Azure SQL: geo-replication, HA/DR, backups, connectivity, sharding/elastic scale-out, multi-tenant SaaS models, and rolling upgrade/failover designs.
Limits & QuotasL122-L135Limits, quotas, and resource caps for Azure SQL (DTU/vCore, elastic pools, backups), plus free tier/free account constraints and how to request quota increases.
SecurityL136-L201Configuring Azure SQL security: authentication (Entra, MFA, MI), network isolation, auditing/Defender, encryption (TDE, Always Encrypted, CMK), data masking/classification, and compliance policies.
ConfigurationL202-L269Configuring Azure SQL databases: monitoring, maintenance, backups/immutability, scaling and elastic pools, geo-replication/failover, security/TLS, Data Sync, CLI/PowerShell/REST setup and operations.
Integrations & Coding PatternsL270-L299Connecting apps and tools to Azure SQL (EF Core, .NET, Node, Python, Spark, Stream Analytics) plus PowerShell automation for sharding, scaling, replication, backup/restore, and auditing.
DeploymentL300-L315Deploying and configuring Azure SQL databases: automation (GitHub Actions, ARM/Bicep/Terraform), Hyperscale setup, sharding, dev environments, region moves, and feature availability by region.

Troubleshooting

TopicURL
Troubleshoot Azure SQL capacity deployment and scaling errorshttps://learn.microsoft.com/en-us/azure/azure-sql/capacity-errors-troubleshoot?view=azuresql
Analyze and prevent deadlocks in Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/analyze-prevent-deadlocks?view=azuresql
Fix slow database import and export in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/database-import-export-hang?view=azuresql
Use RecoveryManager to fix Azure SQL shard mapshttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-database-recovery-manager?view=azuresql
Diagnose and fix high CPU in Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/high-cpu-diagnose-troubleshoot?view=azuresql
Troubleshoot performance issues in Azure SQL Hyperscalehttps://learn.microsoft.com/en-us/azure/azure-sql/database/hyperscale-performance-diagnostics?view=azuresql
Diagnose Azure SQL query performance bottleneckshttps://learn.microsoft.com/en-us/azure/azure-sql/database/identify-query-performance-issues?view=azuresql
Monitor and troubleshoot In-Memory OLTP storage capacityhttps://learn.microsoft.com/en-us/azure/azure-sql/database/in-memory-oltp-monitor-space?view=azuresql
Use DMVs to troubleshoot Azure SQL performancehttps://learn.microsoft.com/en-us/azure/azure-sql/database/monitoring-with-dmvs?view=azuresql
Use Azure Resource Health to troubleshoot Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/resource-health-to-troubleshoot-connectivity?view=azuresql
Troubleshoot common Azure SQL Data Sync issueshttps://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-troubleshoot?view=azuresql
Handle transient connection errors for Azure SQL and Fabric SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-common-connectivity-issues?view=azuresql
Troubleshoot common connectivity issues for Azure SQL and Fabric SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-common-errors-issues?view=azuresql
Troubleshoot geo-replication and redo lag in Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-geo-replication-redo?view=azuresql
Investigate and fix memory issues in Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-memory-errors-issues?view=azuresql
Troubleshoot transaction log full errors in Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/troubleshoot-transaction-log-errors-issues?view=azuresql-db
Identify and resolve blocking in Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/understand-resolve-blocking?view=azuresql
Resolve known issues in Azure SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/doc-changes-updates-known-issues?view=azuresql
Troubleshoot transaction log full issues in Azure SQL Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/troubleshoot-transaction-log-errors-issues?view=azuresql-mi

Best Practices

TopicURL
Analyze Azure SQL monitoring data with KQL and T-SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-analyze?view=azuresql
Apply auditing best practices in production Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-best-practices?view=azuresql
Run disaster recovery drills for Azure SQL workloadshttps://learn.microsoft.com/en-us/azure/azure-sql/database/disaster-recovery-drills?view=azuresql
Optimize resource management in dense Azure SQL elastic poolshttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-resource-management?view=azuresql
Configure and operate Azure SQL failover groups with best practiceshttps://learn.microsoft.com/en-us/azure/azure-sql/database/failover-group-sql-db?view=azuresql
Manage Azure SQL Database file space and shrinkinghttps://learn.microsoft.com/en-us/azure/azure-sql/database/file-space-manage?view=azuresql-db
Apply HA and DR configuration checklist for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-disaster-recovery-checklist?view=azuresql
Operate Azure SQL databases effectively after migrationhttps://learn.microsoft.com/en-us/azure/azure-sql/database/manage-data-after-migrating-to-database?view=azuresql
Plan for Azure SQL planned maintenance eventshttps://learn.microsoft.com/en-us/azure/azure-sql/database/planned-maintenance?view=azuresql
Configure and use read scale-out replicas in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/read-scale-out?view=azuresql
Apply security best practices to Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/secure-database?view=azuresql
Apply best practices for Azure SQL Data Sync configuration and operationhttps://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-best-practices?view=azuresql
Address T-SQL differences when migrating to Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/transact-sql-tsql-differences-sql-server?view=azuresql

Decision Making

TopicURL
Decide when to use Azure Hybrid Benefit for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/azure-hybrid-benefit?view=azuresql
Use Azure SQL decision tree to select the right servicehttps://learn.microsoft.com/en-us/azure/azure-sql/azure-sql-decision-tree?view=azuresql
Plan deployment of Always Encrypted secure enclaveshttps://learn.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-enclaves-plan?view=azuresql
Plan and manage Azure SQL Database costshttps://learn.microsoft.com/en-us/azure/azure-sql/database/cost-management?view=azuresql
Choose Azure SQL disaster recovery options for regional outageshttps://learn.microsoft.com/en-us/azure/azure-sql/database/disaster-recovery-guidance?view=azuresql
Migrate existing sharded databases to Elastic Toolshttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-convert-to-use-elastic-tools?view=azuresql
Compare engine features of Azure SQL Database and Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/database/features-comparison?view=azuresql
Plan and use Hyperscale elastic pools for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/hyperscale-elastic-pool-overview?view=azuresql
Choose job automation options for Azure SQL and Synapsehttps://learn.microsoft.com/en-us/azure/azure-sql/database/job-automation-overview?view=azuresql
Plan and manage Azure SQL Hyperscale databaseshttps://learn.microsoft.com/en-us/azure/azure-sql/database/manage-hyperscale-database?view=azuresql
Migrate Azure SQL databases from DTU to vCore modelhttps://learn.microsoft.com/en-us/azure/azure-sql/database/migrate-dtu-to-vcore?view=azuresql
Choose between vCore and DTU purchasing modelshttps://learn.microsoft.com/en-us/azure/azure-sql/database/purchasing-models?view=azuresql
Choose and use Azure Reservations for Azure SQL computehttps://learn.microsoft.com/en-us/azure/azure-sql/database/reservations-discount-overview?view=azuresql
Reverse migrate Azure SQL Hyperscale to General Purposehttps://learn.microsoft.com/en-us/azure/azure-sql/database/reverse-migrate-from-hyperscale?view=azuresql
Choose and configure Azure SQL serverless compute tierhttps://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview?view=azuresql
Answer common Azure SQL Hyperscale design questionshttps://learn.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale-frequently-asked-questions-faq?view=azuresql
Choose and use Hyperscale secondary replica typeshttps://learn.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale-replicas?view=azuresql
Evaluate and use Azure SQL Hyperscale service tierhttps://learn.microsoft.com/en-us/azure/azure-sql/database/service-tier-hyperscale?view=azuresql
Use DTU-based purchasing model for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/service-tiers-dtu?view=azuresql
Plan capacity with the Azure SQL vCore modelhttps://learn.microsoft.com/en-us/azure/azure-sql/database/service-tiers-sql-database-vcore?view=azuresql
Select migration alternatives for retiring SQL Data Synchttps://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-retirement-migration?view=azuresql
Configure license-free standby replicas for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/standby-replica-how-to-configure?view=azuresql

Architecture & Design Patterns

TopicURL
Design and use active geo-replication for Azure SQL databaseshttps://learn.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview?view=azuresql
Use automatic geo-redundant backups and restore in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/automated-backups-overview?view=azuresql
Plan Azure SQL business continuity, HA, and DR architecturehttps://learn.microsoft.com/en-us/azure/azure-sql/database/business-continuity-high-availability-disaster-recover-hadr-overview?view=azuresql
Understand Azure SQL connectivity architecture and routinghttps://learn.microsoft.com/en-us/azure/azure-sql/database/connectivity-architecture?view=azuresql
Understand Azure SQL connectivity architecture and connection policieshttps://learn.microsoft.com/en-us/azure/azure-sql/database/connectivity-architecture?view=azuresql
Choose geo-replication patterns for global Azure SQL appshttps://learn.microsoft.com/en-us/azure/azure-sql/database/designing-cloud-solutions-for-disaster-recovery?view=azuresql
Disaster recovery patterns for Azure SQL elastic poolshttps://learn.microsoft.com/en-us/azure/azure-sql/database/disaster-recovery-strategies-for-applications-with-elastic-pool?view=azuresql
Use elastic query to run cross-database queries in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-query-overview?view=azuresql
Design elastic scale-out architectures with Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-scale-introduction?view=azuresql
Move and rebalance data between sharded Azure SQL databaseshttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-scale-overview-split-and-merge?view=azuresql
Configure geo-distributed Azure SQL applications with failoverhttps://learn.microsoft.com/en-us/azure/azure-sql/database/geo-distributed-application-configure-tutorial?view=azuresql
Understand Azure SQL local and zone-redundant availability architecturehttps://learn.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla-local-zone-redundancy?view=azuresql
Understand Hyperscale distributed storage and compute architecturehttps://learn.microsoft.com/en-us/azure/azure-sql/database/hyperscale-architecture?view=azuresql
Design rolling upgrade patterns with Azure SQL geo-replicationhttps://learn.microsoft.com/en-us/azure/azure-sql/database/manage-application-rolling-upgrade?view=azuresql
Select multitenant SaaS tenancy models on Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/saas-tenancy-app-design-patterns?view=azuresql

Limits & Quotas

TopicURL
Review database watcher FAQs and operational constraintshttps://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-faq?view=azuresql
FAQ on Azure SQL Database free offer limitshttps://learn.microsoft.com/en-us/azure/azure-sql/database/free-offer-faq?view=azuresql
Understand Azure SQL Database free tier limitshttps://learn.microsoft.com/en-us/azure/azure-sql/database/free-offer?view=azuresql
Use Azure free account to deploy free Azure SQL databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/free-sql-db-free-account-how-to-deploy?view=azuresql
Configure long-term backup retention for Azure SQL databaseshttps://learn.microsoft.com/en-us/azure/azure-sql/database/long-term-retention-overview?view=azuresql
Request quota increases for Azure SQL Database and Managed Instancehttps://learn.microsoft.com/en-us/azure/azure-sql/database/quota-increase-request?view=azuresql
Elastic pool DTU resource limits for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/resource-limits-dtu-elastic-pools?view=azuresql
Single database DTU resource limits for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/resource-limits-dtu-single-databases?view=azuresql
Elastic pool vCore resource limits for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/resource-limits-vcore-elastic-pools?view=azuresql
Single database vCore resource limits for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/resource-limits-vcore-single-databases?view=azuresql

Security

TopicURL
Connect .NET to Azure SQL with Entra MFAhttps://learn.microsoft.com/en-us/azure/azure-sql/database/active-directory-interactive-connect-azure-sql-db?view=azuresql
Configure security for Azure SQL disaster recovery replicashttps://learn.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-security-configure?view=azuresql
Configure Azure Attestation for Always Encrypted enclaveshttps://learn.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-enclaves-configure-attestation?view=azuresql
Enable Always Encrypted with secure enclaves in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-enclaves-enable?view=azuresql
Configure Always Encrypted with Intel SGX enclaves in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-enclaves-getting-started-sgx?view=azuresql
Configure Always Encrypted with VBS enclaves in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-enclaves-getting-started-vbs?view=azuresql
Get started with Always Encrypted secure enclaves in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-enclaves-getting-started?view=azuresql
Register Entra applications for Azure SQL accesshttps://learn.microsoft.com/en-us/azure/azure-sql/database/application-authentication-get-client-id-keys?view=azuresql
Configure SQL auditing to storage behind VNets and firewallshttps://learn.microsoft.com/en-us/azure/azure-sql/database/audit-write-storage-account-behind-vnet-firewall?view=azuresql
Analyze Azure SQL audit logs and reportshttps://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-analyze-audit-logs?view=azuresql
Configure managed identity for Azure SQL auditing to storagehttps://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-managed-identity?view=azuresql
Audit Microsoft support operations on Azure SQL servershttps://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-microsoft-support-operations?view=azuresql
Use auditing for Azure SQL Database and Synapsehttps://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-overview?view=azuresql
Understand server vs database-level auditing policieshttps://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-server-level-database-level?view=azuresql
Configure auditing for Azure SQL and Synapsehttps://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-setup?view=azuresql
Understand Directory Readers role requirements for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-directory-readers-role?view=azuresql
Use Microsoft Entra authentication with Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-overview?view=azuresql
Configure service principals to create Entra users in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-service-principal-tutorial?view=azuresql
Create Azure SQL logical server with user-assigned managed identityhttps://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-azure-ad-user-assigned-managed-identity-create-server?view=azuresql
Configure and use Microsoft Defender for SQL with Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/azure-defender-for-sql?view=azuresql
Migrate Node.js apps to passwordless Azure SQL authenticationhttps://learn.microsoft.com/en-us/azure/azure-sql/database/azure-sql-passwordless-migration-nodejs?view=azuresql
Migrate Python apps to passwordless Azure SQL authenticationhttps://learn.microsoft.com/en-us/azure/azure-sql/database/azure-sql-passwordless-migration-python?view=azuresql
Migrate .NET apps to passwordless Azure SQL authenticationhttps://learn.microsoft.com/en-us/azure/azure-sql/database/azure-sql-passwordless-migration?view=azuresql
Use backup immutability for long-term retention in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/backup-immutability?view=azuresql
Block T-SQL creation and modification of Azure SQL resourceshttps://learn.microsoft.com/en-us/azure/azure-sql/database/block-crud-tsql?view=azuresql
Classify and label sensitive data in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/data-discovery-and-classification-overview?view=azuresql
Import/export Azure SQL databases with Azure services access disabledhttps://learn.microsoft.com/en-us/azure/azure-sql/database/database-import-export-azure-services-off?view=azuresql
Use managed identity for Azure SQL import and exporthttps://learn.microsoft.com/en-us/azure/azure-sql/database/database-import-export-managed-identity?view=azuresql
Import/export Azure SQL databases over Private Linkhttps://learn.microsoft.com/en-us/azure/azure-sql/database/database-import-export-private-link?view=azuresql
Set up dynamic data masking in Azure SQL portalhttps://learn.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-configure-portal?view=azuresql
Configure dynamic data masking in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview?view=azuresql
Manage credentials for Elastic Database client library in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-scale-manage-credentials?view=azuresql
Configure split-merge service security with certificateshttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-scale-split-merge-security-configuration?view=azuresql
Configure IP firewall rules for Azure SQL and Synapsehttps://learn.microsoft.com/en-us/azure/azure-sql/database/firewall-configure?view=azuresql
Configure isolated security for Hyperscale named replicashttps://learn.microsoft.com/en-us/azure/azure-sql/database/hyperscale-named-replica-security-configure?view=azuresql
Manage logins, users, and permissions in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/logins-create-manage?view=azuresql
Configure network access controls for Azure SQL and Synapsehttps://learn.microsoft.com/en-us/azure/azure-sql/database/network-access-controls-overview?view=azuresql
Configure Network Security Perimeter for Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/network-security-perimeter?view=azuresql
Configure outbound firewall rules for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/outbound-firewall-rule-overview?view=azuresql
Apply built-in Azure Policy definitions for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/policy-reference?view=azuresql
Secure Azure SQL with Private Link private endpointshttps://learn.microsoft.com/en-us/azure/azure-sql/database/private-endpoint-overview?view=azuresql
Manage Azure SQL VNet service endpoints with PowerShellhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/vnet-service-endpoint-rule-powershell-create?view=azuresql
Secure an Azure SQL Database using built-in featureshttps://learn.microsoft.com/en-us/azure/azure-sql/database/secure-database-tutorial?view=azuresql
Apply common security best practices for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/security-best-practice?view=azuresql
Use Azure Policy regulatory controls for Azure SQL compliancehttps://learn.microsoft.com/en-us/azure/azure-sql/database/security-controls-policy?view=azuresql
Use fixed server roles on Azure SQL logical servershttps://learn.microsoft.com/en-us/azure/azure-sql/database/security-server-roles?view=azuresql
Store SQL Vulnerability Assessment scans in secured storagehttps://learn.microsoft.com/en-us/azure/azure-sql/database/sql-database-vulnerability-assessment-storage?view=azuresql
Configure Advanced Threat Protection for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/threat-detection-configure?view=azuresql
Use Advanced Threat Protection for Azure SQL databaseshttps://learn.microsoft.com/en-us/azure/azure-sql/database/threat-detection-overview?view=azuresql
Configure cross-tenant CMK TDE with user-assigned identityhttps://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-create-server-cross-tenant?view=azuresql
Create Azure SQL server with user-assigned identity and CMK TDEhttps://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-create-server?view=azuresql
Set up cross-tenant customer-managed keys for Azure SQL TDEhttps://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-cross-tenant?view=azuresql
Manage database-level CMK TDE identities and keyshttps://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-database-level-basic-actions?view=azuresql
Configure geo-replication and restore for database-level CMK TDEhttps://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-database-level-geo-replication-restore?view=azuresql
Use database-level TDE with customer-managed keys in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-database-level-overview?view=azuresql
Configure TDE with user-assigned managed identity in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-identity?view=azuresql
Rotate Azure SQL TDE protector using PowerShell and CLIhttps://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-key-rotation?view=azuresql
Use customer-managed keys for TDE in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-overview?view=azuresql
Respond to compromised TDE protector with BYOKhttps://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-byok-remove-tde-protector?view=azuresql
Configure transparent data encryption for Azure SQL databaseshttps://learn.microsoft.com/en-us/azure/azure-sql/database/transparent-data-encryption-tde-overview?view=azuresql
Secure Azure SQL with virtual network service endpoints and ruleshttps://learn.microsoft.com/en-us/azure/azure-sql/database/vnet-service-endpoint-rule-overview?view=azuresql
Prepare for Azure SQL TLS root certificate rotationhttps://learn.microsoft.com/en-us/azure/azure-sql/updates/ssl-root-certificate-expiring?view=azuresql

Configuration

TopicURL
Configure Azure Monitor alerts for database watcher datahttps://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-alerts?view=azuresql
Understand database watcher datasets and collected metricshttps://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-data?view=azuresql
Create and configure database watcher for Azure SQL monitoringhttps://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-manage?view=azuresql
Set up database watcher to monitor Azure SQL workloadshttps://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-overview?view=azuresql
Create a database watcher with Entra auth and private connectivityhttps://learn.microsoft.com/en-us/azure/azure-sql/database-watcher-quickstart?view=azuresql
Configure active geo-replication and failover for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-configure-portal?view=azuresql
Configure ADO.NET direct routing ports for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/adonet-v12-develop-direct-route-ports?view=azuresql
Configure advance maintenance notifications for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/advance-notifications?view=azuresql
Define and deploy Azure SQL resources with ARM templateshttps://learn.microsoft.com/en-us/azure/azure-sql/database/arm-templates-content-guide?view=azuresql
Interpret Azure SQL Database audit log formathttps://learn.microsoft.com/en-us/azure/azure-sql/database/audit-log-format?view=azuresql
Change automated backup retention and redundancy in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/automated-backups-change-settings?view=azuresql
Configure legal hold immutability for Azure SQL LTR backupshttps://learn.microsoft.com/en-us/azure/azure-sql/database/backup-immutability-legal-hold?view=azuresql
Configure time-based immutability for Azure SQL LTR backupshttps://learn.microsoft.com/en-us/azure/azure-sql/database/backup-immutability-time-based?view=azuresql
Configure MAXDOP for Azure SQL and Fabric databaseshttps://learn.microsoft.com/en-us/azure/azure-sql/database/configure-max-degree-of-parallelism?view=azuresql
Configure TLS and connection policy for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/connectivity-settings?view=azuresql
Restore deleted Azure SQL logical servers (preview)https://learn.microsoft.com/en-us/azure/azure-sql/database/deleted-logical-server-restore?view=azuresql
Configure and use DNS aliases for Azure SQL servershttps://learn.microsoft.com/en-us/azure/azure-sql/database/dns-alias-overview?view=azuresql
Manage Azure SQL DNS aliases with PowerShell and CLIhttps://learn.microsoft.com/en-us/azure/azure-sql/database/dns-alias-powershell-create?view=azuresql
Understand DTU benchmark characteristics for Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/dtu-benchmark?view=azuresql
Configure performance counters for Elastic shard managementhttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-database-perf-counters?view=azuresql
Understand and configure Azure SQL elastic jobshttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-jobs-overview?view=azuresql
Configure Azure SQL elastic jobs with PowerShellhttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-jobs-powershell-create?view=azuresql
Configure Azure SQL elastic jobs with T-SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-jobs-tsql-create-manage?view=azuresql
Create and manage Azure SQL elastic jobshttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-jobs-tutorial?view=azuresql
Create and manage Azure SQL elastic poolshttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-manage?view=azuresql
Configure scaling for Azure SQL elastic poolshttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-pool-scale?view=azuresql
Configure elastic queries for vertically partitioned databaseshttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-query-getting-started-vertical?view=azuresql
Set up elastic queries over sharded Azure SQL databaseshttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-query-horizontal-partitioning?view=azuresql
Configure cross-database queries for different schemashttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-query-vertical-partitioning?view=azuresql
Enable availability zone redundancy for Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/enable-zone-redundancy?view=azuresql
Configure failover groups for Azure SQL databaseshttps://learn.microsoft.com/en-us/azure/azure-sql/database/failover-group-configure-sql-db?view=azuresql
Configure automated backups for Hyperscale databaseshttps://learn.microsoft.com/en-us/azure/azure-sql/database/hyperscale-automated-backups-overview?view=azuresql
Configure and manage Azure SQL Hyperscale named replicashttps://learn.microsoft.com/en-us/azure/azure-sql/database/hyperscale-named-replica-configure?view=azuresql
Configure In-Memory OLTP for Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/in-memory-oltp-configure?view=azuresql
Configure Intelligent Insights monitoring for Azure SQL performancehttps://learn.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-overview?view=azuresql
Configure dev container templates for Azure SQL developmenthttps://learn.microsoft.com/en-us/azure/azure-sql/database/local-dev-experience-dev-containers?view=azuresql
Configure maintenance windows for Azure SQL databases and poolshttps://learn.microsoft.com/en-us/azure/azure-sql/database/maintenance-window-configure?view=azuresql
Maintenance window FAQ for Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/maintenance-window-faq?view=azuresql
Understand and use maintenance windows for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/maintenance-window?view=azuresql
Reference for Azure SQL Database monitoring metrics and logshttps://learn.microsoft.com/en-us/azure/azure-sql/database/monitoring-sql-database-azure-monitor-reference?view=azuresql
Configure monitoring for Azure SQL with Azure Monitorhttps://learn.microsoft.com/en-us/azure/azure-sql/database/monitoring-sql-database-azure-monitor?view=azuresql
Restore Azure SQL databases from automatic backupshttps://learn.microsoft.com/en-us/azure/azure-sql/database/recovery-using-backups?view=azuresql
Query Azure SQL resources with Azure Resource Graphhttps://learn.microsoft.com/en-us/azure/azure-sql/database/resource-graph-samples?view=azuresql
Restart Azure SQL databases and elastic pools (preview)https://learn.microsoft.com/en-us/azure/azure-sql/database/restart-database?view=azuresql
Add Azure SQL databases to failover groups via CLIhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/add-database-to-failover-group-cli?view=azuresql
Configure failover groups for Azure SQL elastic poolshttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/add-elastic-pool-to-failover-group-cli?view=azuresql
Back up Azure SQL databases to storage with CLIhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/backup-database-cli?view=azuresql
Copy Azure SQL databases to new servers via CLIhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/copy-database-to-new-server-cli?view=azuresql
Create and configure an Azure SQL database with CLIhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/create-and-configure-database-cli?view=azuresql
Create and configure an Azure SQL database with PowerShellhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/create-and-configure-database-powershell?view=azuresql
Import BACPAC files into Azure SQL using CLIhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/import-from-bacpac-cli?view=azuresql
Monitor and scale an Azure SQL database with CLIhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/monitor-and-scale-database-cli?view=azuresql
Move Azure SQL databases between elastic pools via CLIhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/move-database-between-elastic-pools-cli?view=azuresql
Restore Azure SQL databases from backups using CLIhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/restore-database-cli?view=azuresql
Scale Azure SQL elastic pools using CLIhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/scale-pool-cli?view=azuresql
Configure active geo-replication for Azure SQL via CLIhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/setup-geodr-failover-database-cli?view=azuresql
Configure Azure SQL failover groups with CLIhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/setup-geodr-failover-group-cli?view=azuresql
Set up geo-replication for pooled databases with CLIhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/setup-geodr-failover-pool-cli?view=azuresql
Configure SQL Data Sync between Azure SQL databases via RESThttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/sql-data-sync-sync-data-between-sql-databases-rest-api?view=azuresql
Configure scaling for single Azure SQL databaseshttps://learn.microsoft.com/en-us/azure/azure-sql/database/single-database-scale?view=azuresql
Install and configure Data Sync Agent for Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-agent-overview?view=azuresql
Set up Azure SQL Data Sync groups and scheduleshttps://learn.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-sql-server-configure?view=azuresql
Configure maintenance windows for Azure SQL databaseshttps://learn.microsoft.com/en-us/azure/azure-sql/maintenance-window-azure-sql?view=azuresql
Reference for Azure SQL Managed Instance monitoring metrics and logshttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/monitoring-sql-managed-instance-azure-monitor-reference?view=azuresql

Integrations & Coding Patterns

TopicURL
Manage Azure SQL auditing using APIs and automationhttps://learn.microsoft.com/en-us/azure/azure-sql/database/auditing-manage-using-api?view=azuresql
Use Entity Framework Core with Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/azure-sql-dotnet-entity-framework-core-quickstart?view=azuresql
Connect and query Azure SQL using .NET SqlClienthttps://learn.microsoft.com/en-us/azure/azure-sql/database/azure-sql-dotnet-quickstart?view=azuresql
Query Azure SQL from Node.js using mssql packagehttps://learn.microsoft.com/en-us/azure/azure-sql/database/azure-sql-javascript-mssql-quickstart?view=azuresql
Connect to Azure SQL using Python mssql-python driverhttps://learn.microsoft.com/en-us/azure/azure-sql/database/azure-sql-python-quickstart?view=azuresql
Build scalable .NET apps with Azure SQL Elastic Database client libraryhttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-database-client-library?view=azuresql
Implement data-dependent routing for sharded Azure SQL databaseshttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-scale-data-dependent-routing?view=azuresql
Manage shard maps with Elastic Database client libraryhttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-scale-shard-map-management?view=azuresql
Integrate Elastic Database tools with Entity Frameworkhttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-scale-use-entity-framework-applications-visual-studio?view=azuresql
Integrate Elastic Database tools with Dapperhttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-scale-working-with-dapper?view=azuresql
Use in-memory OLTP and columnstore samples in Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/in-memory-oltp-sample?view=azuresql
Configure transactional replication to Azure SQL Databasehttps://learn.microsoft.com/en-us/azure/azure-sql/database/replication-to-sql-database?view=azuresql
Create Azure SQL failover group and add database via PowerShellhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/add-database-to-failover-group-powershell?view=azuresql
Add Azure SQL elastic pool to failover group with PowerShellhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/add-elastic-pool-to-failover-group-powershell?view=azuresql
Copy Azure SQL database to new logical server via PowerShellhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/copy-database-to-new-server-powershell?view=azuresql
Import BACPAC into Azure SQL database using PowerShellhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/import-from-bacpac-powershell?view=azuresql
Monitor and scale single Azure SQL database using PowerShellhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/monitor-and-scale-database-powershell?view=azuresql
Monitor and scale Azure SQL elastic pool with PowerShellhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/monitor-and-scale-pool-powershell?view=azuresql
Move Azure SQL databases between elastic pools with PowerShellhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/move-database-between-elastic-pools-powershell?view=azuresql
Restore Azure SQL database from automatic backups with PowerShellhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/restore-database-powershell?view=azuresql
Configure Azure SQL active geo-replication with PowerShellhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/setup-geodr-and-failover-database-powershell?view=azuresql
Set up elastic pool geo-replication with PowerShellhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/setup-geodr-and-failover-elastic-pool-powershell?view=azuresql
Sync data between Azure SQL Database and SQL Server with PowerShellhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/sql-data-sync-sync-data-between-azure-onprem?view=azuresql
Configure SQL Data Sync between Azure SQL databases via PowerShellhttps://learn.microsoft.com/en-us/azure/azure-sql/database/scripts/sql-data-sync-sync-data-between-sql-databases?view=azuresql
Configure and use Spark connector with Azure SQLhttps://learn.microsoft.com/en-us/azure/azure-sql/database/spark-connector?view=azuresql
Stream real-time data into Azure SQL using Stream Analyticshttps://learn.microsoft.com/en-us/azure/azure-sql/database/stream-data-stream-analytics-integration?view=azuresql

Deployment

TopicURL
Deploy Azure SQL database changes with GitHub Actionshttps://learn.microsoft.com/en-us/azure/azure-sql/database/connect-github-actions-sql-db?view=azuresql
Convert Azure SQL databases to Hyperscale tierhttps://learn.microsoft.com/en-us/azure/azure-sql/database/convert-to-hyperscale?view=azuresql
Create transactionally consistent copies of Azure SQL databaseshttps://learn.microsoft.com/en-us/azure/azure-sql/database/database-copy?view=azuresql
Deploy Azure SQL split-merge sharding servicehttps://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-scale-configure-deploy-split-and-merge?view=azuresql
Create zone-redundant Azure SQL Hyperscale databaseshttps://learn.microsoft.com/en-us/azure/azure-sql/database/hyperscale-create-zone-redundant-database?view=azuresql
Manage Hyperscale elastic pools with CLI and PowerShellhttps://learn.microsoft.com/en-us/azure/azure-sql/database/hyperscale-elastic-pool-command-line?view=azuresql
Set up Azure SQL dev environment using dev containershttps://learn.microsoft.com/en-us/azure/azure-sql/database/local-dev-experience-dev-containers-quickstart?view=azuresql
Move Azure SQL databases and pools across regionshttps://learn.microsoft.com/en-us/azure/azure-sql/database/move-resources-across-regions?view=azuresql
Check Azure SQL Database feature availability by regionhttps://learn.microsoft.com/en-us/azure/azure-sql/database/region-availability?view=azuresql
Deploy Azure SQL single database with ARM templatehttps://learn.microsoft.com/en-us/azure/azure-sql/database/single-database-create-arm-template-quickstart?view=azuresql
Deploy Azure SQL single database using Bicephttps://learn.microsoft.com/en-us/azure/azure-sql/database/single-database-create-bicep-quickstart?view=azuresql
Provision Azure SQL server and database using Terraformhttps://learn.microsoft.com/en-us/azure/azure-sql/database/single-database-create-terraform-quickstart?view=azuresql
Check Azure SQL Managed Instance feature availability by regionhttps://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/region-availability?view=azuresql
Similar Skills
ui-ux-pro-max

UI/UX design intelligence for web and mobile. Includes 50+ styles, 161 color palettes, 57 font pairings, 161 product types, 99 UX guidelines, and 25 chart types across 10 stacks (React, Next.js, Vue, Svelte, SwiftUI, React Native, Flutter, Tailwind, shadcn/ui, and HTML/CSS). Actions: plan, build, create, design, implement, review, fix, improve, optimize, enhance, refactor, and check UI/UX code. Projects: website, landing page, dashboard, admin panel, e-commerce, SaaS, portfolio, blog, and mobile app. Elements: button, modal, navbar, sidebar, card, table, form, and chart. Styles: glassmorphism, claymorphism, minimalism, brutalism, neumorphism, bento grid, dark mode, responsive, skeuomorphism, and flat design. Topics: color systems, accessibility, animation, layout, typography, font pairing, spacing, interaction states, shadow, and gradient. Integrations: shadcn/ui MCP for component search and examples.

49.4k
Stats
Parent Repo Stars0
Parent Repo Forks1
Last CommitMar 9, 2026
Actions
View SourceView PluginView on GitHubView README