Write Skew: The Anomaly Snapshot Isolation Does Not Catch
Two transactions each read what the other writes, both commit, and an invariant dies. Snapshot isolation allows write skew — here is how to close the hole.
Field-tested patterns, honest postmortems, and short tactical fixes on Claude, MCP, system design, Dynamics 365, and the modern web. Written for engineers who ship.
Categories
Guides and insights for Dynamics 365 Finance & Operations, Sales, Customer Service, and Copilot.
Tutorials and tips for Power Automate, PowerApps, and the broader Power Platform ecosystem.
System design, modern web development with Next.js, React, .NET, Azure, and practical coding guides.
DevOps practices, PowerShell tips, and stories from the trenches of enterprise tech.
Deep dives into designing scalable, reliable systems — URL shorteners, chat apps, rate limiters, caching, and more.
Practical guides on Claude, the Model Context Protocol (MCP), agent architectures, prompt caching, and tool use in production.
FAANG-style coding interview prep — real questions with Python solutions, organized by the nine patterns that cover most of what interviewers ask.
Start here
Nulls, blank dates, concurrency, duplicates, retries, and the trigger quirks that take production flows down.
31 articles
Indexes, set-based operations, temp tables, batch parallelism, and the Trace Parser habits that keep F&O jobs under an hour.
6 articles
Grounding, plugins, MCP, and the production constraints of Copilot in Sales, Customer Service, and Finance.
10 articles
Dual-write, virtual entities, business events, DMF, and choosing an integration pattern that survives One Version.
11 articles
Recent writing
Two transactions each read what the other writes, both commit, and an invariant dies. Snapshot isolation allows write skew — here is how to close the hole.
ASP.NET Core binds CancellationToken to the aborted request. Forward it to EF Core and HttpClient, and do not turn a client disconnect into a 500.
Patch writes every column present in the change record, including blanks from empty form cards. How to update only the fields the user actually edited.
LeetCode 739 in Python. The stack stores days still waiting for a warmer one, each index is pushed and popped once, and equal temperatures must not count.
What Parental, Referential Restrict, and Remove Link actually do on delete, assign, and merge, and which preset to pick before a parent row takes its children with it.
A cart is a per-user document, not a reservation. What to store on the line, how to merge an anonymous cart at login, and when the price is allowed to change.