~/ notes

Field notes

What I learned building, securing and cleaning up a production platform.

  1. 01
    Architecture7 min read

    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.

  2. 02
    Security audit7 min read

    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.

  3. 03
    MFA5 min read

    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.

  4. 04
    Encryption5 min read

    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.

  5. 05
    Code quality5 min read

    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.