Your Primary Key Is Making Your DB Slow
Split business identity from surrogate; spend clustering where it pays. TL;DR Don’t cluster on row IDs. Keep a surrogate id for FKs (UUIDv7/NEWSEQUENTIALID()/INT). Make the business key the PK or …
pengdows.crud is now released as opensource
🚀 Introducing Pengdows.CRUD – SQL-First, Developer-Focused, Cross-Database Simplicity for .NET Pengdows.CRUD is now open source! This is not an ORM — on purpose. It’s a clean, high-performance, developer-centric data access …
Onions in Milkshakes: A Case for GUIDs and Deterministic IDs with BLAKE3
Data integrity isn’t just theory—it’s the difference between a cheeseburger and a milkshake full of onions. Intro Picture yourself running a classic diner. Burgers sizzling on the grill, fries crisping …
The Danger of Email-Only E-Signatures in Real Estate Transactions
There was a time when signing important legal documents required an in-person meeting with a notary—someone who verified your identity, ensured you were signing voluntarily, and applied their seal as …
Why Breaking Down User Stories by Deployable Units is Best Practice in Microservices Architecture
Introduction In modern software development, particularly within microservices architecture, there’s an ongoing debate about how to best break down user stories. While traditional Agile methods emphasize vertical slicing—cutting through the …
Gnu tools on Mac via Brew
I am always using unix/linux tools like grep, sed, awk and others. MacOs has many but not all. Years ago, I wrote a script to install all my favorites, but …
Lock your credit file
This is just plain helpful for anyone looking to lock their credit files. Transunion Lock/Unlock for Free Equifax Lock/Unlock for Free Experian doesn’t have a free lock but you can …
CentOS Issues
Trying to setup CentOS, which isn’t my normal Linux, I found a number of issues. Time drifts horribly. I tried installing the standard NTP package, but something about CentOS didn’t …
Pengdows.CRUD
This very helpful wrapper over ADO.NET has been released to NuGet free of charge and will soon be released as open source. It is now and will forever be free …
Building a BeagleBone Firewall: Part 6
Now we are ready to plug in the USB ethernet connector. I prefer to make this ethernet connection, the connector to your internet provider, but there is nothing to say …