Build Smarter.
Ship Faster.
Deep technical content on agentic AI systems, LLM cost optimization, Commander Architecture, and production SaaS engineering — from 18+ years of building.
Timeline
Filter by Year
Database Index Fragmentation: Diagnosing and Rebuilding SQL Server B-Trees
An engineering guide to database maintenance in late 2014, detailing index fragmentation analysis and rebuild commands.
Clustered Columnstore Indexes in SQL Server 2014: Columnar Storage for OLAP Databases
Exploring the announced Clustered Columnstore Indexes in SQL Server 2014, detailing read-write optimizations and data compression.
High-Performance Columnstore Indexes in SQL Server 2012
A deep dive into SQL Server 2012 Columnstore Indexes, evaluating column storage structures and batch processing for data warehousing.
Designing High-Performance SQL Indexes: A Masterclass in Query Optimization
A deep dive into database internals, examining B-Tree layouts, page reads, and how to structure composite indexes to satisfy query execution plans.
Get New Posts In Your Inbox
No spam. Deep technical content when we publish — roughly twice a month.