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
SQL Server on Linux: CoreCLR Compilation and SQLPAL Translation Layers
Analyzing Microsoft's SQL Server on Linux preview. We study the SQLPAL translation layer, CoreCLR integrations, and Linux migrations.
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 Auditing: Monitoring Database Access and Tracking Audit Trails
An engineering guide to configuring database-level auditing in SQL Server 2014, detailing audit specifications and compliance tracking.
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.
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.
SQL Server 2012 AlwaysOn: Rethinking Database Disaster Recovery
An evaluation of high availability features in the SQL Server 2012 release previews, focusing on AlwaysOn Availability Groups.
Get New Posts In Your Inbox
No spam. Deep technical content when we publish — roughly twice a month.