Author: Antony Asish
-
WEF Core unique constraint bug that cost me 2 hours
Blogs Antony Asish 07 Feb 2026 EF Core unique constraint bug that cost me 2 hours Last week, I faced a frustrating issue in Entity Framework Core that wasted almost two hours of debugging time. It looked simple: Add a new entity Save it to the database Done The Problem: Unique Constraint Violation Let’s say…
-
SQL Server RCSI vs Read Committed Explained
Blogs Antony Asish 01 Mar 2026 SQL Server: Read Committed vs Read Committed Snapshot (RCSI) Most production systems use Read Committed — but many teams don’t fully understand how it behaves under heavy concurrency. If your application experiences: Blocking issues Slow APIs during peak hours Read queries waiting for updates You need to understand this…
-
Understanding SQL Server ACID & Isolation Levels
Blogs Antony Asish 05 Mar 2026 Understanding SQL Server ACID & Isolation Levels When building enterprise applications using MS SQL Server, especially in high-concurrency systems (banking, e-commerce, booking systems), understanding ACID properties and Isolation Levels is critical. This turns high-cost AI investments into shelfware—not because models were poorly built, but because systems were never designed…