06SQL Server → PostgreSQL · Part 6 Indexes, MVCC and Performance: Unlearning the Clustered Index PostgreSQL has no clustered index. Readers never block writers either, so here are MVCC, VACUUM, EXPLAIN ANALYZE and the new index types for SQL Server folks. Aug 6, 2026 · 7 min read →
Fixes EF Core: two HasIndex calls on the same column create only one index (name them) Two HasIndex calls on one column produced a single index. EF Core merges same-property HasIndex calls unless each has a name, so name them. Sep 4, 2026 · 2 min read →
Databases & Data Database Indexes: Why Your Queries Are Slow Scan a million rows, or jump straight to one. How indexes work, when to add them, and the trade-offs nobody mentions. Jul 30, 2026 · 5 min read →
Fixes Blazor: the h1 shows a focus ring after navigation (FocusOnNavigate and tabindex=-1) FocusOnNavigate moves keyboard focus to your heading. Your :focus-visible rule then draws a ring around it. Keep the focus, lose the ring. Sep 4, 2026 · 2 min read →
04From Prompt to Production · Part 4 Spec to Schema: Designing PostgreSQL Tables with AI Turn the spec into PostgreSQL DDL with AI. Then catch its mistakes in a schema review: the missing FK index, the naive timestamp, and the partial unique index. Aug 9, 2026 · 7 min read →
06The .NET Developer Interview · Part 6 SQL and EF Core Questions The data-access questions that decide senior vs junior. Indexes, the N+1 problem, tracking vs no-tracking, transactions and joins. Aug 7, 2026 · 7 min read →
06From Prompt to Private · Part 6 Giving It Knowledge, Part One: Chunks, Embeddings and pgvector in the Clinic's Own Database The clinic's documents become searchable vectors. A heading-aware chunker, nomic-embed-text, pgvector with an HNSW index, and ingest that skips the unchanged. Sep 18, 2026 · 5 min read →
11From Prompt to Production · Part 11 The Hardening Pass: AI as a Hostile Reviewer Ask the AI to attack its own app. The open self-registration it shipped, the missing role checks, the CHECK constraint it forgot, and the index EXPLAIN wanted. Aug 9, 2026 · 7 min read →