Explore by topic
Case Studies
Deep dives into real deployments, architecture choices, and measurable outcomes.
Answer-shaped entry points
Prefer a short decision card before the long note? Start on the Answers hub, then return here for the full case-study path. Cards only cover claims the posts actually make.
What you will find here
- Topology and control-plane writeups from systems that had to survive CI/CD, private networking, and real entitlement models.
- Architecture tradeoffs with the decision criteria that mattered after the pilot, not the workshop slide.
- Migration and parity contracts: NULL versus zero, float pennies, and the checks that kept finance from rejecting the cutover.
- Platform-scale patterns for Fabric lakehouses, agent apps, and canvas surfaces, including the failure modes that showed up in production.
Featured case studies
Posts tagged Case Studies, including newer lakehouse, Direct Lake, and agent-shell writeups from the publishing backlog.
Sep 4, 2026 · 9 min read
POC public vs MVP private: networking as architecture for agent apps
How to stage agent webapps from a public POC to a private MVP without pretending env files are a network design.
Aug 17, 2026 · 8 min read
Signing in is not authorization: app access is not agent access
Why enterprise agent webapps need separate control planes for shell sign-in, agent catalog access, and knowledge corpus entitlements, and how Entra app roles on the API make that enforceable.
Aug 13, 2026 · 9 min read
Canvas apps at platform scale: push work to Dataverse
How to keep canvas apps maintainable at scale by following Microsoft reference guidance: fewer mega-screens, less chatty data access, more Dataverse-side work.
Aug 12, 2026 · 9 min read
Legacy to lakehouse: semantic parity is the real migration
Why lakehouse migrations fail on NULL versus zero, float pennies, and type rebase settings, and how to treat parity as a contract.
Aug 10, 2026 · 9 min read
SCD2 is a product question: point-in-time deployed state with MLVs
Explain why location and classification history for measuring points should be SCD2 Materialized Lake Views before anyone builds devices as of reports.
Aug 5, 2026 · 9 min read
One Fabric lakehouse with schemas vs many lakehouses
How to choose between multiple Fabric lakehouses and a schema-enabled lakehouse for bronze, silver, and gold, including CI/CD and naming fallout.
Jul 30, 2026 · 9 min read
MLV migration is a program: bronze to silver to gold with gates
Frame hundreds of T-SQL warehouse views moving to MLVs as a phased program with schema-enabled lakehouses, shortcut layouts, and POC gates before bulk conversion.
Jul 21, 2026 · 9 min read
Refresh drift is a contract break, not a flaky pipeline
Diagnose sales-line style refresh drift as mismatched incremental contracts between notebooks, watermarks, and semantic consumers.
Jul 21, 2026 · 9 min read
Foundry webapps deploy as identity and egress, not as Node hostnames
Walk through a VNet-integrated container App Service pattern with secretless OBO, managed identity, and private egress to Foundry, Search, and storage.
Jun 22, 2026 · 9 min read
Pivot once in gold: measurable controls as a flat fact
Replace OUTER APPLY Import-mode checklist pivots with a pre-pivoted gold fact built in PySpark for Direct Lake.
Jun 2, 2026 · 9 min read
IoT events are facts: model them like service, not like logs
Show why telemetry events belong in gold with contract and service-item enrichment and Direct Lake storage mode for volume.
Jun 2, 2026 · 9 min read
Shortcuts-only bronze: stop copying what OneLake already holds
Argue that bronze should be a contract of OneLake shortcuts and clean views, not a second physical copy of upstream gold and silver.
May 26, 2026 · 9 min read
When Fabric regressions force literal OneLake URLs, document the workaround
Reframe literal URL required failures as service regressions with validators, promotion playbooks, and support cases - not as eternal architecture dogma.
May 22, 2026 · 9 min read
Bridge keys before dashboards: remodel the device fact
Show why service-device relationships need an explicit bridge/fact remodel before report pages can be trusted.
May 11, 2026 · 9 min read
Gold without a semantic contract is just another table
Argue that device gold tables only become platform assets when unmatched keys, captions, and relationships are explicit in the semantic model.
Apr 8, 2026 · 9 min read
Automate Your Microsoft Fabric Workloads with Apache Airflow
Why Fabric workloads need an explicit orchestration plane, how to keep Airflow thin while Fabric owns the data work, and which failure modes show up when teams collapse both into one tool.