- Shrinking a SQL Server data file safely: DBCC SHRINKFILE in steps, low-priority waits and fixing the fragmentationDatabases · 9 Nov 2026
- MongoDB basics: connect with mongosh, read and write documents, add your first indexDatabases · 6 Nov 2026
- PostgreSQL HOT updates and fillfactor: reduce bloat and WAL on update-heavy tablesDatabases · 6 Nov 2026
- SQL Server PAGELATCH_EX on inserts: fix last-page contention with OPTIMIZE_FOR_SEQUENTIAL_KEYDatabases · 6 Nov 2026
- PostgreSQL CREATE INDEX CONCURRENTLY failed or stuck: INVALID indexes, _ccnew leftovers and a safe retryDatabases · 4 Nov 2026
- Oracle ORA-00060 deadlock detected: read the trace file and fix the real causeDatabases · 3 Nov 2026
- PostgreSQL index basics: B-tree indexes, reading EXPLAIN, and why your index is not being usedDatabases · 29 Oct 2026
- Optimization: MongoDB working set, WiredTiger cache and index efficiencyDatabases · 25 Oct 2026
- Optimization: MySQL index clean-up and tuning with the sys schema - unused, redundant and full-scan queriesDatabases · 25 Oct 2026
- Optimization: PostgreSQL query and index tuning with pg_stat_statements - top queries, unused and duplicate indexesDatabases · 25 Oct 2026
- Optimization: SQL Server index and statistics maintenance - stop rebuilding everything every nightDatabases · 25 Oct 2026
- Optimization: SQL Server index review - missing, unused and duplicate indexes from DMVs and Query StoreDatabases · 25 Oct 2026
- Finding slow MySQL queries with the slow query log and Performance SchemaDatabases · 22 Oct 2026
- MongoDB slow queries: profiler, explain() and the ESR index ruleDatabases · 22 Oct 2026
- Reading PostgreSQL EXPLAIN ANALYZE: find the slow step in five minutesDatabases · 22 Oct 2026