skills.rest
pascalvanderheiden
pascalvanderheidenCOMMUNITY
Explore all skills by this author →
GitHub

azure-sql-database

Troubleshoot and design Azure SQL Database security, configuration, and performance solutions.

1|Updated May 1, 2026
Search Tags:#architecture#performance#deployment#security#troubleshooting#geo-replication#azure sql database
One-click install
npx skills add https://github.com/pascalvanderheiden/energize-your-code-hackathon --skill azure-sql-database-pascalvanderheiden
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: azure-sql-database
Source: https://github.com/pascalvanderheiden/energize-your-code-hackathon/tree/main/.github/skills/azure-sql-database
Command: npx skills add https://github.com/pascalvanderheiden/energize-your-code-hackathon --skill azure-sql-database-pascalvanderheiden

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Azure SQL Database projects stall when teams lack confident guidance on architecture, configuration, limits, security, and troubleshooting—leading to outages, performance regressions, and rework.

Core Features & Use Cases

  • Troubleshooting & diagnostics: Identify and resolve common issues such as high CPU, deadlocks, blocking, connectivity failures, capacity/scaling problems, geo-replication lag, data sync issues, and transaction log full errors.
  • Design & decision support: Choose the right deployment model (vCore/DTU, Hyperscale, serverless, elastic pools, HA/DR patterns) and plan cost, licensing, and migration paths.
  • Security & operational hardening: Implement secure authentication (Entra, managed identity), encryption (TDE/Always Encrypted), auditing/Defender, network controls, and compliance-ready practices.
  • Integration & deployment guidance: Apply recommended configuration for tooling and code patterns (EF Core/.NET, Node.js, Python) and deploy/automate infrastructure using common IaC workflows.

Quick Start

Use azure-sql-database to troubleshoot a specific Azure SQL Database issue by asking: “Analyze my Azure SQL Database symptoms (include tier, workload type, error messages, and recent changes) and recommend the most likely root cause plus step-by-step remediation.”

Frequently Asked Questions about azure-sql-database

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I troubleshoot high CPU and deadlocks in Azure SQL Database?▼

To troubleshoot Azure SQL Database high CPU and deadlocks, analyze your workload type, tier, and recent configuration changes to identify blocking queries. Structured guidance helps map symptoms like transaction log full errors or connectivity failures to step-by-step remediation actions.

What is the best way to choose between vCore and DTU deployment models for Azure SQL Database?▼

Choosing between vCore and DTU deployment models for Azure SQL Database requires evaluating your cost, licensing, and migration paths. Decision support guidance compares Hyperscale, serverless, and elastic pool configurations to match your specific HA/DR patterns and workload scale.

How do I implement geo-replication and high availability for Azure SQL Database?▼

Implementing geo-replication and high availability for Azure SQL Database involves selecting appropriate HA/DR patterns and configuring replicas to minimize lag. Design guidance covers setting up active geo-replication, diagnosing data sync issues, and planning failover operations.

Can I use managed identity and Always Encrypted to secure Azure SQL Database authentication?▼

Yes, you can secure Azure SQL Database authentication using Entra ID and managed identity, while protecting data with Always Encrypted and TDE. Operational hardening guidance also covers configuring auditing, Microsoft Defender, and network controls for compliance-ready practices.

How do I deploy and automate Azure SQL Database infrastructure using IaC and EF Core?▼

Deploying and automating Azure SQL Database infrastructure with IaC workflows integrates code patterns from EF Core, Node.js, and Python. Integration guidance provides recommended configurations for tooling and automation pipelines to ensure consistent provisioning.

Why does my Azure SQL Database transaction log keep filling up and causing errors?▼

Azure SQL Database transaction log full errors typically occur when capacity limits or scaling problems block log truncation. Diagnostic guidance analyzes your specific tier and workload symptoms to isolate root causes and provides step-by-step remediation to restore normal operations.

Related Skills

Explore More Software Engineering Skills→
MicrosoftDocsMicrosoftDocs
686

azure-sql-database

Provide expert guidance for Azure SQL Database development, troubleshooting, and optimization.

Official
Advanced
nist0nist0

cloud-web-hosting

Assess Azure hosting options and configure Cloudflare DNS for .NET web apps.

Community
Intermediate
do360nowdo360now

azure-review

Evaluate Azure infrastructure configurations against CIS security benchmarks.

Community
Intermediate
sitharaj88sitharaj88
1

azure-sql

Generate Bicep or Terraform code for Azure SQL databases, elastic pools, and managed instances.

Community
Advanced