Sql server

Optimistic vs Pessimistic Concurrency in EF Core: Choosing the Right Strategy

Sudhir Mangla
Database , Concurrency control
26 Feb, 2026

1 The Concurrency Landscape for .NET Architects Every multi-user application faces the same fundamental question: what happens when two users modify the same data at the same time? If you don't

Graph Problems on Relational Systems: SQL Server Graph vs. Neo4j—When to Choose What

Sudhir mangla
Database , Data Engineering
05 Sep, 2025

1 Introduction: The Inevitable Rise of Connected Data Relational databases have been the backbone of enterprise systems for decades. They excel at structured, transactional workloads—think invento