Series
Curricula grouped by product. Read in order when the problem is a path, not a single note.
Microsoft Fabric
Open series Lakehouse topology, Direct Lake, refresh, CI/CD blast radius, and Fabric platform contracts.
Fabric Airflow: Is It Possible to Use Apache Airflow with Fabric?
Keep Fabric as the execution plane and Airflow as the orchestration plane. Thin tasks, terminal-state success, and the failure modes that show up when you collapse both into one tool.
Lakehouse Design: One Lakehouse with Schemas, or 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.
Direct Lake: Do You Still Need to Refresh a Semantic Model?
How to choose notebook, pipeline, or scheduled refresh for lakehouse semantics, and when Direct Lake beats a SQL endpoint for heavy facts.
Semantic Migration: How Do You Rebind Reports When the Model Moves to Lakehouse?
Why lakehouse migrations fail on NULL versus zero, float drift, and type rebase settings, and how to treat parity as a contract.
Fabric CI/CD: How Do You Limit Blast Radius Across Dev Workspaces?
Why Fabric deployment tooling can republish unchanged notebooks and how to design for stable identities and smaller blast radius.
OneLake Shortcuts: Should Shortcuts Stay Bronze-Only?
Argue that bronze should be a contract of OneLake shortcuts and clean views, not a second physical copy of upstream gold and silver.
Gold + Direct Lake: Direct Lake or Import for Large Fact Tables?
Show why a high-volume source table belongs in gold as a documented fact table with shared key matching and Direct Lake storage mode for volume.
Gold Semantic Contract: Can You Choose Which Columns Reach the Direct Lake Model?
Argue that gold tables only become platform assets when unmatched keys, captions, and relationships are explicit in the semantic model.
Workspace Naming: Is a One-Time Rename Cheaper Than Translating Prefixes Forever?
Argue that inconsistent workspace display-name prefixes create operational tax and that a one-time rename with stable catalog names is cheaper than perpetual translation layers.
Fabric CI/CD: Merge the whole ladder, or cherry-pick what is ready?
In a multi-dev Fabric test to staging to main ladder, merge the tip only when everything is ready. Safer selective promotion cherry-picks squash commits onto a temp branch, opens a PR, then deploys.
Microsoft Foundry
Open series Identity, knowledge RBAC, session durability, and deploy patterns for production agent apps.
Agent Access: How Do You Scope an Agent's Permissions Safely?
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.
Enterprise Agents: How Do Big Companies Secure AI Agents and Knowledge Access?
How to design folder-scoped knowledge access for enterprise agents so chat, library browse, downloads, and citation files share one entitlement model.
Microsoft Foundry: How Do You Persist Agent Sessions Outside the Chat Shell?
Where conversation state should live when a browser shell wraps a platform agent, and why refresh and quit behavior is an architecture choice.
Agent Apps: Can a Public POC Become a Private MVP?
How to stage agent webapps from a public POC to a private MVP without pretending env files are a network design.
Agent Pilots: Should You Rank Use Cases Before Picking an Agent Topology?
Make the case that enterprise agent programs should start from ranked use cases (orchestrator vs single agent vs tools) instead of from a menu of model endpoints.
Microsoft Foundry: Is Deploy as Web App Enough, or Do You Need a Backend Proxy?
Walk through a VNet-integrated container App Service pattern with secretless OBO, managed identity, and private egress to Foundry, Search, and storage.
Agent Traceability: How Do You See Inside an AI Interaction for Audit?
Argue that activity timelines must reconcile Foundry traces, MCP knowledge searches, and UI tool-call counts, or reviewers will never trust the product.
Agent Shells: How Do You Feature-Toggle Agent Capabilities Across Environments?
Replace hard-coded agent catalogs with product feature flags plus per-agent overlay rows for scope, starters, export prefixes, and access arrays.
Foundry + private Search: Is Name or service not known a DNS problem or an auth problem?
When Foundry agent tool enumeration fails with Name or service not known against private Azure AI Search MCP, treat it as DNS and VNet path first, then chase 403 and RBAC.
Foundry Agent Webapps: Cosmos or Azure SQL for Backend State, and When?
Teach the Foundry agent webapp backend store decision. Split app-owned state from Foundry platform stores. Prefer Cosmos for document chat bags; prefer Azure SQL + EF Core when app-owned records need relational ops behind a frozen HTTP API.
Databricks
Open series Genie readiness, modeling contracts, and analytics assistants on Databricks.
Databricks Genie: Can It Build My Deck and Deploy My App?
What Databricks Genie Code changes for deck generation and app deploy when the assistant already sits inside your governed lakehouse context.
Data Agent Readiness: Is Genie (and Fabric Agents) Really a Modeling Problem?
What has to be true in naming, modeling, and catalog descriptions before conversational analytics tools like Genie produce trustworthy answers.
Power Platform
Open series Canvas apps, semantic models, and Power BI contracts that survive platform scale.
Canvas Apps: When Do You Outgrow Power Apps at Platform Scale?
How to keep canvas apps maintainable at scale: fewer mega-screens, less chatty data access, more Dataverse-side work.
Import UX: Should Uncertain AI Rows Start Selected or Deselected?
Default-deny AI import UX: keep uncertain and incomplete rows deselected, bind validity to the live section schema, and show selected versus valid counts.
Semantic Relationships: Why Do Model Relationships Break After Pipeline Runs?
Show how int64 vs string mismatches across role-playing dims silently break relationships and how to align gold SQL with TMDL.
Azure
Open series App Service, networking, CLI isolation, and front-door patterns for Azure-hosted apps.
Env Isolation: How Do You Handle Dev/Staging/Prod with Azure CLI and Subscriptions?
Show how collapsing redundant env templates and treating Azure CLI subscriptions/resource groups as the real isolation boundary prevents POC/MVP config drift.
Secure AI Shells: Should the Browser Talk to Foundry, or Only Through a Proxy?
Compare hardening options for browser-to-API proxies in front of agent backends, including runtime mismatch and Front Door failure modes.