06SQL Server → PostgreSQL · Part 6 Indexes, MVCC and Performance: Unlearning the Clustered Index PostgreSQL has no clustered index — and readers never block writers. MVCC, VACUUM, EXPLAIN ANALYZE and the new index types, explained for SQL Server folks. Aug 6, 2026 · 7 min read →
Databases & Data Database Indexes: Why Your Queries Are Slow The difference between scanning a million rows and jumping straight to one. How indexes work, when to add them, and the trade-offs nobody mentions. Jul 30, 2026 · 5 min read →
06The .NET Developer Interview · Part 6 SQL and EF Core Questions Indexes, the N+1 problem, tracking vs no-tracking, transactions and joins — the data-access questions that decide senior-vs-junior impressions. Aug 7, 2026 · 7 min read →