Windows 11 Telemetry
The Hidden Windows 11 Privacy setting that stops 90% of Telemetry. Google gets a lot of flak for tracking everything you do, and rightly so. But many people don’t realize that Windows 11 also sends a huge amount of diagnostic and telemetry data back to Microsoft by default. The good news? Microsoft actually gives you…
Read MorePostgreSQL snapshots
What are snapshots in PostgreSQL, how do they work, and why you might need them. Snapshots are a key part of achieving Isolation in ACID. Let’s break it down quickly. ACID recap:Atomicity → All or nothing (transaction commits fully or rolls back).Consistency → Database moves from one valid state to another (constraints, triggers, etc.).Isolation →…
Read MoreJSON in PostgreSQL
PostgreSQL’s JSONB type is fast, indexable, and incredibly flexible for semi-structured data. But it’s not a silver bullet, sometimes a traditional normalized table is still the better choice.Since I have PostgreSQL running on my laptop, I’ll show you real examples you can copy-paste and run yourself, complete with actual psql screenshots. When to use JSONB…
Read MoreFrankenstein tables
The horror of bloated schemas and premature partitioningAlso known as monster tables, out-of-control tables, or God tables (the ones that try to hold everything because it’s easier and joins are for the weak). I prefer frankenstein tables. These beasts start innocently enough, a few extra columns here, some quick fixes there, but before you know…
Read MoreStart Menu full of ads?
Imagine this: you’re in the middle of a high-stakes trading session at a bank. The clock’s ticking, your screen is a sea of spreadsheets and market feeds, and you hit the Windows key for a quick app launch. Boom, your Start Menu is full of ads . It’s a digital flea market: prompts for Microsoft…
Read MoreWindows 11 Task Manager trick
Banks use this Windows 11 Task Manager trick to find viruses manually. I work at an investment bank, part-time at the IT helpdesk. Most people rely solely on antivirus software and think they’re fully protected. In reality? Antivirus misses things, especially sneaky, low-profile threats that don’t trigger alerts. At the investment bank where I work,…
Read More