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.


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
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
EF Core Relationships and the Mixed Approach: Code First or DB First?
Code First or DB First in EF Core? Read relationships with Include, learn the Mixed approach and compare all three to pick the right one for your project.
EF Core
EF Core Code First: Adding and Rolling Back Migrations
Learn EF Core Code First: write entities and a DbContext, run Add-Migration, apply and roll back changes with Update-Database, and ship safely to production.
EF Core
What Is EF Core? Setup and the Database First Approach
What is EF Core and how does Database First work? Set up SQL Server with Docker, generate C# classes with Scaffold-DbContext and weigh the pros and cons.
EF Core
Website Speed and Core Web Vitals: ASP.NET Optimization
How do you speed up a website? Practical ASP.NET Core, EF Core, HTML, CSS, JS, image and caching optimizations for better Core Web Vitals (LCP, INP, CLS).
SEO
Open Graph, Structured Data (Schema.org) and ARIA Guide
Learn Open Graph tags and JSON-LD structured data (Schema.org) with Article, Product and Breadcrumb examples, plus ARIA labels and accessibility tips.
SEO
Technical SEO: robots.txt, Sitemap and Canonical Guide
Technical SEO explained: robots.txt, sitemap.xml, canonical, hreflang and HTTPS redirects, with ASP.NET Core code examples and a checklist for developers.
SEO
What Is SEO? A Practical On-Page SEO Guide for Developers
What is SEO and how does it work? A step-by-step guide to on-page SEO for software developers: title tags, meta descriptions, headings, clean URLs and slugs.
SEO
ASP.NET MVC: CSS, JS and Images Not Loading on /home/index?
Your site looks fine at the root but loses its CSS, scripts and images on /home/index? It's a path problem, and a single ~ in your Razor views fixes it.
