Search

Latest posts

• If AI Eats the Web, Who Feeds AI?
  2026-04-19 — Data Architecture — AI can answer faster than search, but speed is not the same as sustainability. If creators lose traffic, revenue, and incentive, the open knowledge loop starts to break.
• PostgreSQL - DBA Toolkit - Blocking and Lock Waits
  2026-04-17 — Database Admin — Find exactly who is blocking who in PostgreSQL — the blocking session, the waiting session, and the query that started the pile-up.
• PostgreSQL - DBA Toolkit - Checkpoint and WAL Health
  2026-04-17 — Database Admin — Monitor PostgreSQL checkpoint frequency, WAL generation rate, and background writer pressure to catch I/O storms before they hit.
• PostgreSQL - DBA Toolkit - Connection Limits and Pooling
  2026-04-17 — Database Admin — Check connection usage against limits, spot idle connections burning slots, and know when you are close to refusing new clients.
• PostgreSQL - DBA Toolkit - Database Size and Growth
  2026-04-17 — Database Admin — See database and table sizes at a glance, identify the biggest objects, and spot growth before it fills the disk.
• PostgreSQL - DBA Toolkit - Deadlocks
  2026-04-17 — Database Admin — Track deadlock counts per database, identify tables with active lock contention, and surface the transactions involved.
• PostgreSQL - DBA Toolkit - Index Bloat and Health
  2026-04-17 — Database Admin — Find bloated, unused, and duplicate indexes in PostgreSQL — the silent performance killers that accumulate over time.
• PostgreSQL - DBA Toolkit - Long Running Queries
  2026-04-17 — Database Admin — Spot long-running queries and idle transactions in PostgreSQL before they block autovacuum, hold locks, and cause a cascade of timeouts.
• PostgreSQL - DBA Toolkit - Query Performance with pg_stat_statements
  2026-04-17 — Database Admin — Use pg_stat_statements to find the queries costing you the most — by total time, average time, and I/O — across your entire workload.
• PostgreSQL - DBA Toolkit - Replication Lag
  2026-04-17 — Database Admin — Check streaming replication lag on all standby servers, WAL send and replay positions, and whether replicas are keeping up with the primary.
• PostgreSQL - DBA Toolkit - Table Bloat and Vacuum Health
  2026-04-17 — Database Admin — Find tables with high dead tuple counts, stalled autovacuum, and growing bloat before they degrade query performance and threaten transaction ID wraparound.
• Leadership: You don't just learn from People You Get Along With
  2026-04-16 — Leadership
• MySQL - DBA Toolkit - Active Sessions and Threads
  2026-04-07 — Database Admin — See every active session and thread at a glance — who is running what, for how long, and where your connection headroom sits.
• MySQL - DBA Toolkit - Index Usage and Missing Indexes
  2026-04-07 — Database Admin — Identify unused indexes wasting write overhead and large tables with no useful indexes that will cause full scans under load.
• MySQL - DBA Toolkit - InnoDB Buffer Pool Health
  2026-04-07 — Database Admin — Check InnoDB buffer pool hit rate, utilization, and dirty page pressure to understand whether your working set fits in memory.
• MySQL - DBA Toolkit - Lock Waits
  2026-04-07 — Database Admin — Surface active InnoDB lock waits and long-running transactions to identify what is blocking and how long it has been doing so.
• MySQL - DBA Toolkit - Replication Lag and Status
  2026-04-07 — Database Admin — Check replica status, seconds behind source, I/O and SQL thread health, and GTID consistency to catch replication problems before they become outages.
• MySQL - DBA Toolkit - Slow Query Analysis
  2026-04-07 — Database Admin — Find the queries consuming the most cumulative time using performance_schema digest statistics, without needing the slow query log.
• MySQL - DBA Toolkit - Table Size and Growth
  2026-04-07 — Database Admin — Identify your largest tables, compare data versus index footprint, and spot fragmentation that can be reclaimed with a table rebuild.
• MySQL - DBA Toolkit - Deadlocks
  2026-04-06 — Database Admin — Detect and investigate MySQL deadlocks using InnoDB status, performance_schema, and the last deadlock report.
• MySQL - DBA Toolkit - Connection Usage and Limits
  2026-04-05 — Database Admin — Check current connection counts, max_connections limits, and identify who is consuming connections before you hit the wall.
• MySQL - DBA Toolkit - Binary Log Health
  2026-04-04 — Database Admin — Monitor binary log status, current log file, position, and retention to ensure replication and point-in-time recovery are healthy.
• MSSQL - DBA Toolkit - Query Plan Cache
  2026-04-03 — Database Admin
• NoSQL, OLAP, Transactional and Flat Files: What They Actually Are
  2026-04-02 — Database Admin
• MSSQL - DBA Toolkit - Availability Group Health
  2026-03-29 — Database Admin
• MSSQL - DBA Toolkit - CPU and Memory Pressure
  2026-03-29 — Database Admin
• MSSQL - DBA Toolkit - Database Growth Trends
  2026-03-29 — Database Admin
• MSSQL - DBA Toolkit - DBCC CHECKDB and Corruption Checks
  2026-03-29 — Database Admin
• MSSQL - DBA Toolkit - Deadlock History
  2026-03-29 — Database Admin
• MSSQL - DBA Toolkit - Index Fragmentation and Health
  2026-03-29 — Database Admin
• MSSQL - DBA Toolkit - Log File Usage and VLFs
  2026-03-29 — Database Admin
• MSSQL - DBA Toolkit - Missing and Unused Indexes
  2026-03-29 — Database Admin
• MSSQL - DBA Toolkit - SQL Agent Job Health
  2026-03-29 — Database Admin
• MSSQL - DBA Toolkit - TempDB Usage and Contention
  2026-03-29 — Database Admin
• MSSQL - DBA Toolkit - Top Queries by Resource
  2026-03-29 — Database Admin
• Running Out of Oil Isn’t Just a Fuel Problem
  2026-03-26 — Energy Industry
• Global Shock Part 6: What We Can Conclude
  2026-03-06 — Data Science
• Global Shock Part 5: How I Hooked Oil Prices, Shock Events, and Recovery Phases Together
  2026-03-04 — Data Science
• When Politicians Say 'Drill the North Sea'
  2026-03-04 — Energy Industry
• Global Shock Part 4: Build a Daily Oil Price Pipeline on AWS with CloudFormation and Lambda
  2026-03-03 — Data Engineering
• Global Shock Part 3: It's Just One Pipeline — But You Should Still Architect
  2026-03-02 — Data Architecture
• Global Shock Part 2: The Heating Oil Industry
  2026-03-01 — Energy Industry
• Global Shock Part 1: Not again!?!
  2026-02-28 — Data Science
• Language Matters: Why Data & Grit Isn’t a Professional Document
  2026-02-22 — Leadership
• Storage isn't always about Money
  2026-02-21 — Data Architecture
• Data Science — Tip of the Spear
  2026-02-19 — Data Science
• What do I know about Nuclear Power
  2026-02-18 — Energy Industry
• Party with Partitions
  2026-02-17 — Data Architecture
• I’ve Done Management. That’s Not The Same Thing As Leadership.
  2026-02-16 — Leadership
• Data Governance: It’s Not About Saying No
  2026-02-15 — Data Governance
• ETL vs ELT: Same Letters. Different Eras.
  2026-02-14 — Data Engineering
• Choosing the Right Database: There is no such thing as “the best database.”
  2026-02-13 — Data Architecture
• On-Prem V Cloud: Opinions, Love, Distrust Vs Use Cases
  2026-02-12 — Data Architecture
• MSSQL - DBA Toolkit - Active Sessions
  2026-02-01 — Database Admin
• MSSQL - DBA Toolkit - Blocks Waits locks
  2026-02-01 — Database Admin
• MSSQL - DBA Toolkit - Cached Plans by CPU
  2026-02-01 — Database Admin
• MSSQL - DBA Toolkit - Databases Don’t Shrink. They Betray Patterns.
  2026-02-01 — Database Admin
• Running Backups + ETA
  2026-02-01 — Database Admin
• PostgreSQL - DBA Toolkit - Active Sessions
  2026-02-01 — Database Admin