DevOps
Troubleshooting Latency: A Systematic Approach to Finding the Bottleneck
A systematic method for tracking down latency issues in production systems, from network to application to database, built from decades of war stories.
Performance
Databases
Stored Procedures: When to Use Them, When to Avoid Them
Opinionated guide to stored procedures covering performance benefits, maintainability costs, security implications, and practical guidelines for when they help vs hurt.
Databases
SSD vs HDD: How to Choose the Right Storage for Your Workload
Practical guide to choosing SSD or HDD storage for databases, analytics, and archival workloads based on real-world performance, cost, and endurance tradeoffs.
Databases
Sharding vs Partitioning: Database Scaling Strategies Compared
Sharding and partitioning are related but different database scaling strategies. A veteran architect explains both approaches, their trade-offs, and when to use each.
Databases
Distributed Caching Explained: Redis, Memcached, Valkey, and How to Choose
A principal architect's guide to distributed caching: how Redis, Memcached, and Valkey work, when to use each, and lessons from running caches at scale in production.
Networking
Latency vs Bandwidth: What's the Real Difference and Why It Matters
Understand the critical difference between latency and bandwidth, why both matter for performance, and how to optimize each in real-world cloud and network architectures.