Oğuzhan KARAGÜZEL

OĞUZHAN KARAGÜZEL

Software Developer

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.

Hizmetlerimizi anlatan temsili görsel
EF Core Query Performance: Projection, AsNoTracking and AsSplitQuery
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
SQL Server Indexes: Clustered, Non-Clustered and B-Tree
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
EF Core Relationships and the Mixed Approach: Code First or DB First?
October 23, 2026

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
October 23, 2026

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
October 23, 2026

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
October 23, 2026

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
October 23, 2026

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
October 23, 2026

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
October 23, 2026

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?
October 31, 2023

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.