NOTES & ARTICLES
My personal notes on the challenges encountered while building a system from scratch, the solutions I found, and a bit of the philosophy behind it all. A mix of the technical and the theoretical.


October 24, 2026
EF Core Query Performance: Projection, AsNoTracking and AsSplitQuery
Speed up EF Core queries: Select projection instead of Include, AsNoTracking and AsSplitQuery. Read the generated SQL and learn which one to use when.
EF Core, SQL Server
October 24, 2026
SQL Server Indexes: Clustered, Non-Clustered and B-Tree
What is an index in SQL Server? Clustered vs non-clustered indexes, how a B-Tree lookup works, covering indexes and choosing the right index, with examples.
EF Core, SQL Server