ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Azure SQL Database Automatic Tuning can shift query execution plans automatically. This post walks through the three modes, when Parameter Sensitive Plans help, and how to inspect and control plan changes with T-SQL.
Learn how to add readable secondary replicas to an Azure SQL Hyperscale database to offload read traffic, reduce primary load, and improve query latency for SaaS workloads.
Route read-only workloads to a secondary replica in Azure SQL Database using ApplicationIntent=ReadOnly, with notes on consistency, tier coverage and verification caveats.
Learn how Azure SQL Database Hyperscale decouples compute and storage to support databases up to 100 TB without the complexity of manual sharding.
Stop over-provisioning for peak loads. Learn how Azure SQL Database Hyperscale decouples compute from storage to handle bursty traffic and automatic storage growth.
A practical guide to enabling Azure SQL Database Query Store, querying execution metrics via DMVs, detecting plan regressions, and managing retention and overhead.
Hyperscale decouples compute from storage, enabling near-instant vertical scaling and high log-rate throughput for large Azure SQL workloads.
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.
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.
