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.
SQL Server 2014 In-Memory OLTP: Speeding Up Writes with Hekaton Tables
An architectural review of SQL Server 2014's Hekaton In-Memory OLTP engine, analyzing lock-free index structures and compiled queries.
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.
Redis 2.6: Lua Scripting, Server-Side Scripts, and Commands
Exploring the release of Redis 2.6 in late 2012, detailing server-side Lua scripting, transaction security, and cache performance.
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.
MongoDB 2.0: Concurrency, Indexing, and Enterprise Readiness
Reviewing the release of MongoDB 2.0 in late 2011, examining improvements to concurrency locks, index sizes, and automatic failovers.
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.