Every article

Newest first, grouped by year. Search or filter by topic.

556 articles
·
2 matching

Filter by topic All .NET AI Engineering Architecture Azure & DevOps Data Warehousing Engineering Practice Microservices Web APIs schema-design × View

14 May 2025

.NET 14 May 2025

An Archive Table That Outlives Its Source

The storage design behind ArchiveKit - typed queryable columns and a jsonb payload from a single write, why the archive's EntityId is an index but deliberately not a foreign key, and the reflective model configuration that builds every archive table from one method call. Part 4 of the Archive-on-Delete with ArchiveKit series.

.NET · 5 min

19 Apr 2025

.NET 19 Apr 2025

Fourteen Foreign Keys and an Index Named Placeholder

Thirty-eight tables, fourteen foreign keys, none on the tables that need them - plus a shipped SSMS template index, auto-tuning suggestions accepted blind, three-state booleans and a demo mode that mutates production master data.

.NET · 6 min