PostgreSQL Notes

PostgreSQL Notes featured image

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 Notes

SQL Server Notes featured image

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

Welcome post featured image

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.