Contents
第1話Chapter 1
The substation that kept failing
A 3kV traction substation broke down about 1.1 times a week. A Lean Six Sigma DMAIC project found the cause and took it to near zero.
第2話Chapter 2
One click
A 20-page monthly performance report used to take hours. Excel VBA on a live database turned it into one click.
第3話Chapter 3
Shrinking the targets
A retail target-setting pipeline on SQL Server, where empirical Bayes shrinkage keeps small stores from getting wild targets.
第4話Chapter 4
The admin that answers to one
A custom MCP server that lets an AI assistant inspect and restart containers on a personal server, behind single sign-on.
第5話Chapter 5
The server with one door
A self-hosted VPS where the only way in is a WireGuard tunnel, with a default-deny firewall and CrowdSec watching the front.