Notes from the system
Notes on systems, development, automation, databases, IT design… and some gaming when it is worth it. Written when there is something worth sharing.
Indexes are one of the most powerful performance tools in SQL Server — and one of the most overlooked sources of overhead. Every index you create must be maintained on every INSERT, UPDATE, and DELETE operation. Unused indexes cost you disk space, backup time, memory, and write performance, without providing any read benefit. Finding and…
When troubleshooting performance issues on a SQL Server instance, the first step is always to understand what is happening right now: which queries are running, which sessions are blocking others, and where time is being spent waiting. These three T-SQL scripts give you an immediate picture of the current workload using Dynamic Management Views (DMVs)…
What would happen if a great warrior and a small tortoise were to race? According to Zeno of Elea, the Greek mathematician and philosopher of the 5th century BC, the warrior would never catch the tortoise — at least according to the logic of his famous paradox. And yet common sense tells us the opposite…
IT & Sysadmin
Servers, networks and automation: what I have set up, broken and fixed.
Go to section →AI & Dev
Code written hand in hand with AI: experiments, tools and what I learned.
Go to section →Gaming
Games, hardware and a few thoughts once the credits roll.
Go to section →Projects
Apps and games I have built, from MovieMania! to Time Drift.
Go to section →Archive
Older articles: some dated, all still here.
Go to section →“This is for Everyone”
— Tim Berners-Lee