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 …
Convert a X.509 (PKI) certificate to GPG
I see this question a lot all over the web, and it results in a lot of people saying it can’t be done. However, this wasn’t the case back when …
The fallacy of identity verification online.
I have done a lot of work for various companies, dealing in different industries, including financial and insurance. Everyone wants to validate peoples identity for various reasons, HIPPA, Payment Card, …
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 …