Thanks, need to write more of these. I think at 2019+ this starts to become a more viable tech.

I've submitted an issue to try and get quoting either only quoting the post itself (no sub quotes) or adding line breaks in. I think this is a cumbersome item.

It's not, but it's a lot of work, and easy to make a mistake in complex guard clauses. Add to this the evolution across a dozen changes and the scripts...

We run SSC on ephemeral drives (NVMe) but with AGs because if it dies, we need to fail over .

I think the challenge is that the actual implementation of how you deploy changes presents challenges. You can't easily mix state and migrations if your deployment method is a particular...

RSA was a poor choice, and actually might be correct. The documentation isn't clear here, but developers can write their own implementation of a key store, which could be an...

I'll leave this here, as we're not going to agree.

I've apologized for the issues, and I do so again here: I'm sorry. We made mistakes and didn't do this that...

You should assume all backups work and provide an alert of some sort if backups fail. You can do this with SQL Agent, or you can use something like

Thanks for the update, and nice catch. This would make an interesting article, the story about the restore not working and why, as well as how you caught it. If...

Have you restored it manually to see if anything crops up that you didn't expect?

It's a good question. My guess with the SO database, that like Jonathan referenced, there are intermediate pages that need to be read to find the leaf pages.

Not all asymmetric keys are certificates, but from what I've seen with HSMs, they use certificates, precisely because of the metadata of the expiration date. If that's documented elsewhere differently,...

Visually appealing is a personal preference. The people on this thread seem (to me and a few others) to be complaining as though the formatting is something that's right or...

I'll let Lynn respond, but I think you're on the right track here. To me, the table will return a prioritized list of rows that your application (or a process)...

So, I don't want to argue through all this. We had a number of things, not just management, that pushed a release. Quite a few of the items wouldn't have...