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.
DATABASE
Database Engineering.
Postgres, Oracle, Cassandra, Mongo, Yugabyte — replication, performance, and surviving 3am pages.
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.
Oracle 26ai Architecture Explained for DBAs: Instance, CDB, PDB, Memory, and Services
A practical Oracle 26ai architecture guide for DBAs, covering the instance, database files, CDB/PDB model, SGA, PGA, background processes, listener, services, and SQL*Plus verification commands.
Oracle AI Database 26ai New Features: A Practical DBA Guide
A simple but detailed DBA-friendly walkthrough of Oracle AI Database 26ai features, including AI Vector Search, JSON Relational Duality, SQL Firewall, SQL enhancements, and SQL*Plus changes.