Sql server

Normalization vs. Reality: When to Denormalize for Throughput on SQL Server & Azure SQL

Sudhir Mangla
Database , Performance Optimization
13 Apr, 2026

1 Normalization vs. Reality: When to Denormalize for Throughput on SQL Server & Azure SQL 1.1 The Architect’s Paradox: Purity vs. Performance Normalization still matters. Third Normal For

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