Insights

Technical writing on AI implementation, Microsoft Fabric, and enterprise analytics.

Claude AI

Building a Production MCP Server for SQL Server: Lessons from the Field

What it actually takes to expose a SQL Server data warehouse to Claude via the Model Context Protocol — authentication, query scoping, and keeping responses grounded in schema.

Microsoft Fabric

Medallion Architecture on Microsoft Fabric: Design Decisions That Matter

Key decisions in bronze/silver/gold layer design that affect downstream analytics performance and maintainability — and the ones that are easy to get wrong early.

Claude AI

Deploying Claude on Azure AI Foundry: What Enterprise Teams Should Know

A practical overview of the deployment process, managed identity authentication, and the integration points that differ from direct Anthropic API usage.

Power BI

Power BI Row-Level Security at Scale: Patterns That Hold Up

Dynamic RLS using username() and USERPRINCIPALNAME() works well at small scale. Here is what changes when you have hundreds of roles, large semantic models, and DirectQuery sources.

New posts are published periodically. Contact layak@mydatadynamo.com to discuss a specific topic.