Create a table and insert a couple of rows:
Then back up the database without using compression, and open up the backup file with a hex editor:
The same trick works on the data file, too.
That’s all. That’s the post.
Look, not every post is groundbreaking: sometimes it’s just about writing down something that I had to explain to a client, and I’m pretty sure I’m going to have to explain it again. PII is like a sexually transmitted infection: it gets around in ways that you’re just not prepared to face.