Practical notes on performance troubleshooting, HA/DR, migrations, database internals and the evidence behind safe production changes.
Independent consulting for teams that need senior help with database performance, production incidents, migrations and reliability.
PostgreSQL packs a surprising amount of power once you get past the basics: lean on EXPLAIN ANALYZE to understand your queries, and reach for the right index type—B-tree, GIN, or GiST—depending on the workload. Its JSONB support lets you blend relational and document-style data without giving up indexing or constraints. Don’t forget routine maintenance either;
SQL Server rewards a few good habits: index your most-filtered columns, keep statistics up to date, and read the actual execution plan before guessing at performance problems. Prefer set-based queries over row-by-row cursors, and watch out for implicit conversions that quietly kill index usage. When something feels slow, start with wait statistics and the query
Welcome to my personal blog, where I share notes and lessons from my journey in data and software. Here you’ll find practical tips, honest reflections, and useful resources I’ve gathered along the way. Thanks for stopping by—I hope you find something helpful and decide to stick around.