Field notes
What I learned building, securing and cleaning up a production platform.
- 01
Two databases, one source of truth
How a platform with an admin side and a customer side runs on two SQL Server databases that reference each other, and how we put both schemas in Git with a build and deploy pipeline that handles the circular references.
- 02
I audited my own platform against OWASP. Here is what I found.
About 80 findings across an ASP.NET Core API and three Next.js portals, and the lessons that will change how I write code from now on.
- 03
MFA is a chain, and I found the weak links
A password that skipped the second factor, a shared seed behind every authenticator code, and a five-minute window. How we moved to per-user TOTP secrets without locking anyone out.
- 04
Encryption is not a function call. It is a lifecycle.
Argon2id for passwords, a fixed IV that had to go, three generations of ciphertext living side by side, and why rotating a key is harder than choosing one.
- 05
What a year of SonarQube warnings taught me about my own code
Injection hotspots, copy-pasted blocks, runaway regexes and one fix that made things worse: what static analysis caught, what it missed, and why we eventually replaced it.