ReadMeFeed / Community knowledge
Real questions. Useful conversations. Find the people who know your stack.
Databases & messaging · #microsoftsqlserver
Learn how to move from manual data filtering to Row-Level Security (RLS) to enforce per-user data isolation transparently without rewriting application logic.
Learn how to enable Query Store, identify a regressed query, force a known‑good plan, and verify the fix while understanding the overhead trade‑off.
Learn how to implement table partitioning in SQL Server using partition functions and schemes to improve maintenance and performance for massive datasets.
Columnstore indexes can turn minute-long scans into sub-second queries — but only for the right workload. A concrete 5M-row test shows how to verify the gain and where the feature backfires.
Learn how to enable Query Store, capture a performance baseline, spot regressed statements after a deployment, and temporarily force a good plan while you work on a permanent fix.
Learn how to protect a single column with SQL Server Always Encrypted and secure enclaves while still enabling in‑place equality joins, including requirements, design, trust boundaries, checks, failures, and when to revisit the design.
Implement SQL Server’s system‑versioned temporal tables to automatically track every change to a row. Learn how to create, query, and monitor temporal tables, and understand the trade‑offs like storage overhead and write‑latency.
A decision guide for SQL Server indexing strategies, comparing clustered, non-clustered, covering, and columnstore indexes to balance read performance and write overhead.
Query Store lets you capture every query’s plan and runtime stats in SQL Server, giving a durable baseline for performance tuning and regression detection. Enable it once, tune retention, and use plan_compare to spot regressions in production.