Diagnosing Azure SQL Database Plan Regression with Automatic Tuning Plan Correction
Identify and resolve Azure SQL Database plan regression using Automatic Tuning Plan Correction with a step‑by‑step diagnostic guide.
Loading…
ReadMeFeed / Community knowledge
Azure SQL Database
Real questions. Useful conversations. Find the people who know your stack.
Azure SQL Database
Databases & messaging · #azuresqldatabase
Using Accelerated Database Recovery to Keep Azure SQL Database Logs Under Control
Learn how to enable Accelerated Database Recovery (ADR) in Azure SQL Database to speed up recovery and prevent log growth caused by long-running transactions.
Azure SQL Database Active Geo‑Replication: Minimal Viable Architecture and Operational Checks
A concise architecture note covering requirements, the smallest viable design, trust boundaries, monitoring, failure modes, and when to reconsider the design for Azure SQL Database active geo‑replication.
Optimizing Multi-Tenant Costs with Azure SQL Elastic Pools
Elastic pools let many tenant databases share one block of Azure SQL capacity. How the sharing works, a CLI configuration to copy, and the limits that bite in production.
Scaling Reads on Azure SQL Hyperscale: What You Gain and What to Watch
Learn how Azure SQL Hyperscale read scale‑out lets you add up to 30 read‑only replicas without extra storage cost, how to route traffic with ApplicationIntent=ReadOnly, and the key trade‑offs—replication lag, replica limits, and compute‑only pricing.
Designing Around Azure SQL Database Serverless: An Architecture Note for Variable Workloads
An architecture note on Azure SQL Database serverless: when it fits, the smallest configuration that works, trust boundaries, monitoring checks, and the failure modes that should trigger a redesign.
Performing a Point-in-Time Restore of an Azure SQL Database
Step‑by‑step guide to restore an Azure SQL Database to a specific point in time using the portal or Azure CLI, with verification, limitations, and recovery options.
Diagnosing Azure SQL Database Resource‑Governance Throttling (40501, 10928, 10929)
Step‑by‑step guide to recognize, diagnose, and fix Azure SQL Database throttling errors (40501, 10928, 10929) using DMVs, resource stats, and connection‑pool tuning.
Architecture Note: Azure SQL Database Auto-Failover Groups for Cross‑Region HA
Learn the requirements, minimal design, trust boundaries, operational checks, failure modes, and design change triggers for Azure SQL Database Auto‑Failover Groups.