For reference and from practice.
At the top is our reference collection: topics we maintain continuously and expand step by step. Below it, articles and case reports from projects, talks and the work on our tools. Factual, with evidence and with their limits.
Reference
Maintained rather than published and forgotten: every page shows its status, its maturity level and a change log.
SQL Server versions
Current build and end of support for SQL Server 2005 through 2025, complete update lists per version, and a build checker for the output of @@VERSION.
Understanding the optimizer
Why the same query is sometimes fast and sometimes slow: real execution plans to try out, parameter sniffing in the plan cache, and a comparison of the remedies.
Read chapter 1 →Articles & case reports
Where does the time go? Query Store with triggers, procedures and functions
Measured on SQL Server 2019: where duration overlaps, where work has no entry of its own, and why totals mislead. With a fast-motion view and a quiz.
Read the article →T-Lift: dynamic SQL without writing it by hand
Our T-SQL precompiler turns catch-all procedures into parameterized dynamic SQL with suitable plans. The source stays readable T-SQL.
Read the article →
What evidence looks like
A look inside PSG QX: from the timeline through the expensive line of code to the finding with proof, unknowns and next step to verify.
Take a look →Local. Deterministic. Verifiable.
Why we rely on data mining for our analyses, long before generative AI, and what “deterministic” means for your findings.
Read more →The first case report is coming
Starting point, evidence, measure, impact and limits, anonymized and traceable.
How it will be structured →
Performance Driven Development
Considering performance in development and architecture from the start, instead of repairing it in operations.
To the training courses →QX Fleet in practice
What a product-wide view across many installations shows. Follows after the first deployments.
More about QX Fleet →
Always pushing ahead
From 1994 to today: CeBIT 2008 on the Microsoft stage, columnstore at the partner conference in 2012, In-Memory OLTP since 2015.
To the milestones →
Hamburg SQL Server user group
Organized by us since 2005, today the Microsoft Data Platform Community Hamburg.
To Meetup ↗