I'm spectacularly bad at self-promotion, so here's some things I wrote over the years that:
a) People tell me they found useful
b) Come up surprisingly often in technical forums
c) Friends and colleagues don't realize I already wrote about (hence the bad at self-promotion part).
Database cryptography.
This covers a lot of ground, but mostly culminates in guidance for application-layer client-side encryption when working with databases, encrypted search, etc.
https://soatok.blog/2023/03/01/database-cryptography-fur-the-rest-of-us/