Why Did Autovacuum Stall and My Table Keep Bloating?
Dead tuples keep climbing even though autovacuum runs. Find the idle transaction, prepared xact or stale replication slot pinning the xmin horizon, and reclaim the space.
Pillar: Pillar 15 - Technical Debt & Sustainability
Pillar 15 · Evolve
Replacing black, flake8, and isort With a Single Tool: Migrating to Ruff
How to retire black, flake8, isort and their plugins in favour of one Rust-based tool: port your rules into ruff.toml, enable the formatter, and enforce it in CI.
Why Did a Patch Release Break My CI Overnight
CI is red this morning and nobody touched the code. A caret range let a transitive ‘patch’ slip in. Here is how to find it, confirm it, and stop it recurring.
SAP ECC to S/4HANA: Automating Custom-Code Remediation Analysis
The real risk in an SAP ECC-to-S/4HANA migration hides in years of custom Z-code. Automated scans and usage data let you size the remediation with evidence before the 2027 maintenance cliff.
Don’t forget you are out of extensions on Server 2012 — there is no year four
Extended Security Updates for Windows Server 2012 and 2012 R2 end on 13 October 2026. Three years was the whole runway — there is no year four to buy. Find your last box before the date, not after it.
PostgreSQL 15 to 17 Major Upgrade with pg_upgrade
A rehearsed in-place PostgreSQL 15 to 17 upgrade with pg_upgrade –link: pre-flight checks, matching extensions, statistics rebuild and a tested rollback.
This Fixes: pg_upgrade ‘could not load library’ Extension Mismatch
pg_upgrade aborts with ‘could not load library’ when an extension has no matching binary in the new cluster. Install the target-version contrib and PostGIS packages, re-check, then upgrade.
Autovacuum Tuning for a Write-Heavy Postgres Table
Global autovacuum defaults let a hot table bloat between runs. Set per-table storage parameters so a high-churn table gets vacuumed often enough to stay lean.
Upgrading a Service From .NET 6 to .NET 8
How to retarget a real ASP.NET service from .NET 6 to .NET 8 LTS: the TFM and global.json bump, the analyzer, and the breaking changes that actually bite.
AI as Amplifier: Why It Makes Good Engineering Orgs Better and Bad Ones Worse
AI doesn’t make an engineering organisation good or bad. It makes a good one better and a bad one worse, faster than either outcome would have happened without it — and the organisations most excited about AI’s productivity gains are frequently the ones with the least visibility into which of the two they actually currently …