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...

I like Lynn's idea. I was going to suggest some other items in the rule table, like the time or cost that might influence this. I might also include a...

Ummmm.... is that where the decisions to not include critical functionality or "not good enough but we have a schedule to meet" decisions are cast in stone? I...

There's a lot of caching that occurs, so some of that might explain this. Certain things, like Active threads are a heavy load if they're always real time.

I'd be curious how to design this, or if you track notes, this might make an interesting article about permission changes, or evolution. Happy to work with you. Or if...

This might help: https://www.mssqltips.com/sqlservertip/5041/sql-server-native-backup-and-restore-in-amazon-rds/

We had a bug with not logged in users, but didn't think it was forum related.

I'll have to try that a bit. Not sure what the private window does to...

Same for me. I think something flushed last night or this morning. I know we deployed a minor change. This is still an open issue.

The login to user issue is a tough one. SQL doesn't do a good job of modeling a user and then assigning database access. I think in this case, you...

Reworded slightly. It would be one trip with that code.

I was trying to raise awareness of the simplicity of sp_prepexec().