How a 1970 IBM research paper on the relational model produced a declarative query language that outlasted its rivals, survived a decade-long NoSQL insurgency, and quietly absorbed the very systems that tried to replace it.
Sql
-
The Story of SQL -
SQL Server Quick Start and T-SQL Cheat Sheet Getting productive on Microsoft SQL Server fast when you already know PostgreSQL or MySQL — connecting with sqlcmd and the modern clients, running the engine in a container, the T-SQL dialect essentials (TOP, OFFSET/FETCH, MERGE, CTEs, window functions), indexes and execution plans, stored procedures, backup and restore, and the dialect gotchas that trip up newcomers.
-
Trino: One Query Engine Over Everything Trino is a distributed MPP SQL engine that queries data where it lives — across object storage, relational databases, and streaming systems — without loading it into a central warehouse first. This guide covers the architecture, connectors, optimizer, failure model, and honest operational realities.
-
PostgreSQL Internals and Tuning How PostgreSQL works under the hood: MVCC for non-blocking reads, heap and TOAST storage, WAL for durability and replication, VACUUM and autovacuum mechanics, EXPLAIN ANALYZE output explained, index types, pg_stat_statements for query analysis, and key postgresql.conf tuning parameters.
-
dbt Core in Practice: Data Modeling That Doesn't Rot A complete hands-on guide to dbt Core — project structure, sources and staging layers, testing data quality, documentation, incremental models, and running dbt in production with Airflow.
-
DuckDB for Analytics Engineers: In-Process OLAP That Replaces Your Spark Cluster A comprehensive guide to DuckDB—covering its columnar vectorized execution engine, querying Parquet and S3 directly, replacing heavy Spark jobs for medium data workloads, Python and R integration, performance tuning, and when to use DuckDB vs alternatives.
-
PostgreSQL Performance Tuning: From Slow Queries to a Database That Purrs A practical deep dive into PostgreSQL performance: reading pg_stat_statements, analyzing slow queries with EXPLAIN ANALYZE, choosing the right index type, tuning autovacuum, and scaling connections with PgBouncer.
-
PostgreSQL for Developers: Indexes, EXPLAIN ANALYZE, JSONB, and Tuning for Real Workloads A practical deep-dive into PostgreSQL for developers — understanding indexes and when to use them, reading EXPLAIN ANALYZE output, using JSONB for flexible schemas, and tuning the key configuration knobs that matter for real workloads.
-
Database Design Fundamentals Principles for designing database schemas that scale and perform.