RAG Explained Simply: How Retrieval-Augmented Generation Really Works
A plain-language guide to RAG, why it matters, where vector search fits, and how to think about retrieval quality before building an AI assistant.
All articles
From the notebook.
AI Agents for DBAs: What They Can Help With and Where to Be Careful
A practical look at AI agents for DBA work: monitoring, runbooks, SQL explanation, incident triage, and the guardrails needed before automation.
Oracle 26ai Tablespace and Space Management: A Practical DBA Starter Guide
A DBA-friendly introduction to Oracle tablespaces, data files, autoextend, free space, temp usage, undo, and the SQL checks every Oracle admin should know.
Oracle 26ai User Management: Users, Roles, Privileges, and Safer Access
A practical Oracle DBA guide to creating users, assigning roles, managing privileges, and avoiding over-permissioned accounts.
PostgreSQL Performance Basics: What DBAs Should Check First
A practical starter guide to PostgreSQL performance: slow queries, indexes, vacuum, statistics, memory, connections, and wait symptoms.
PostgreSQL Indexing Explained: B-tree, Selectivity, and Query Plans
A simple but detailed guide to PostgreSQL indexing for DBAs and developers, with practical examples and common mistakes.
Cassandra Architecture Basics: Nodes, Partitions, Replication, and Consistency
A practical introduction to Cassandra architecture for DBAs: clusters, nodes, partition keys, replication factor, consistency levels, and operational tradeoffs.
Cassandra Data Modeling: Query-First Design for DBAs
Cassandra data modeling explained simply: why query-first design matters, how partition keys work, and why normalization habits can hurt performance.
MongoDB Architecture Basics: Documents, Collections, Replica Sets, and Sharding
A DBA-friendly introduction to MongoDB architecture, including documents, collections, replica sets, sharding, indexes, and operational checks.
MongoDB Indexing and Query Performance: What to Check First
A practical MongoDB indexing guide covering query patterns, compound indexes, covered queries, explain plans, and common performance traps.
YugabyteDB Architecture: Distributed SQL Explained for DBAs
A practical explanation of YugabyteDB architecture, distributed SQL, tablets, replication, nodes, and PostgreSQL-compatible access.
YugabyteDB for PostgreSQL DBAs: What Feels Familiar and What Changes
A practical guide for PostgreSQL DBAs learning YugabyteDB: SQL compatibility, distributed storage, replication, indexes, and operational differences.