Day: December 28, 2025
Temporary 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