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

No idea, but a couple responses from Twitter.

Gail Shaw - https://sqlinthewild.co.za/index.php/2008/05/02/token-and-perm-user-store-growth/

There's a couple settings in sp_configure, about access buckets. Fiddling with those might help.

Erin Stellato - I've seen a recommendation...

I think the setup is likely OK, but you ought to look IO load on the existing dbs and run HammerDB or something else to be sure you're getting better...

A certificate is an asymmetric key.

First, this why you want roles and/or groups in play. If this is SQL auth, AD groups don't help, but for Windows auth, this us why you'd want a group,...

Wordpress (this platform) doesn't allow username changes. We'll have to do it in the back end. Please send an email to the webmaster@ (this domain) and request the change. Send...

+1 for single statement.

Glad you enjoyed it. Pix looked great.

I'm headed to Pensacola this weekend and Austin next month. No Albany for me, I'll be in the UK 🙁

It's still slightly weird, because coordinating changes is difficult at times. It's something I think we'd want to get to, but because there are database changes at times, it's not...

Interesting, is it just me, or would anyone read that from the note on the latest version of What's new in SQL Server 2019 preview that although 2008(R2) ...

With the new SSC, everything is supposed to run through a dev/QA cycle before prod. We have PRs that require review before they get merged into a deployable spot.

However, we...