Author: Henny Staas
Backups
Backups: the simple truth most people ignore (and how to do it right) A backup is nothing more than a copy of your data.If your computer dies, you buy a new one and copy everything back. No data lost. No tears.Sounds simple? It is, if you do it properly.But most people don’t. They think it…
Read MoreUnreadable SQL
How to write Unreadable SQL… and why you shouldn’tWe’ve all seen it: a 200-line SQL query with no indentation, cryptic column aliases like a1, x, tmp, no comments, and nested subqueries that make your eyes bleed. It runs. It works. But six months later, nobody, not even the original author, can understand it. I’ve spent…
Read MoreWindows 11 Clipboard Sync
Windows 11 Clipboard Sync: the feature that uploads everything you copy.Windows 11 has a handy feature called Clipboard History, it lets you see and reuse things you’ve copied recently.But there’s a catch most people miss:Cloud sync is ON by default.That means everything you copy, passwords, bank details, private messages, addresses, it all gets uploaded to…
Read MoreTemporary Tables
Temporary Tables still there 5 years later.Why your junior dev’s temporary table is still there 5 years later We’ve all seen it: a table named tmp_orders_2020, test_customers_backup, or temp_report_john, created just for a quick test, but still sitting in production years later, full of outdated data, wasting space and confusing everyone. In my 35 years…
Read MoreWindows 11 Recall
Windows 11 Recall: why you (probably) don’t have it, and why that’s good for privacyYou may have heard about Windows Recall, Microsoft’s new AI feature that takes screenshots of your screen every few seconds, stores them locally, and lets you search your PC activity like a timeline. It sounds useful for some… but it raised…
Read MoreDatabase Normalization
Database Normalization: Great Servant, Terrible Master Normalization is one of the most preached concepts in database design. Many SQL gurus treat it like a religion: chase the highest normal form (5NF or even 6NF) at all costs. But in the real world, especially in OLTP systems (online transaction processing) and even many analytics setups, blind…
Read More