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

You can certainly add logging to your app that captures start of query and then when the datareader/datatable fills. I don't know of anything directly that does this natively in...

I agree that doing a POST is a bit overkill for something like that. Must have been timing but it was quite strange. Might also be a good...