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

I've never seen that. I wonder if someone changed yours from AD Group Policy? It's certainly strange.

Reminds me of a tech support run I did at the nuclear plant with my boss. A manager complained their PC wouldn't turn on. We walked over to the office,...

That's a good idea, and a nice sentiment. I've volunteered for things my kids have been involved in over the years, and doing less now as they've gotten older, but...