John Eisbrener

Terrible at twitter...

[John Eisbrener @johnedba]

@sqlpass I’ve had many great experiences with PASS over the years. It’s too bad they didn’t heed the advice of @TheStephLocke back in 2018 (https://t.co/7syrCiRqCa), as I suspect much of this could have been avoided. Looking forward to the next chapter for the #sqlfamily

[John Eisbrener @johnedba]

@erinstellato @erikdarlingdata @AMtwo I do believe the QDS query to be the culprit only because no other open transactions older than a few minutes old were present. As for CUs this environment falls into some strict patching guidelines, so it’s patched almost as fast as the CUs are available. Thanks for looking!

[John Eisbrener @johnedba]

@erinstellato @erikdarlingdata @AMtwo A 2 day old open Query Store transaction was identified as the oldest open transaction. The full DBCC OPENTRAN output can be found in the question.

[John Eisbrener @johnedba]

@erinstellato @erikdarlingdata @AMtwo I’d be interested in hearing any alternative theories about the cause of my automatic failover, but the logs looked pretty damning. Let me know if there are any details I can provide that are not already on the https://t.co/pId2J1mVa5 post. I’d love to hear your thoughts.

[John Eisbrener @johnedba]

@MADPASS @sqL_handLe I know those people! @sqL_handLe and Joe Obbish are solid as they always have great blog posts! That other guy must be a charity case!

[John Eisbrener @johnedba]

@equerystrian @grrl_geek @SQLEspresso @tonysebion @MADPASS @brijeetAkula We use Skype for Business at the moment, but honestly, it's pretty fragile (e.g. connection issues, camera adjustments, or a stiff breeze will cause it to crash). We're going to be experimenting with Teams soon and if that doesn't work out we'll be trying other solutions.

[John Eisbrener @johnedba]

@sqlqueen After working with clients in places like Phoenix, Arizona, USA or Regina Saskatchewan, Canada, I've become acutely aware of what a difference that distinction can be, especially during the summer months.

[John Eisbrener @johnedba]

Would anyone on #SQLHelp with some SSRS skills be able to weigh in on my https://t.co/pId2J1mVa5 question: https://t.co/587FShE7vu Wondering if I should submit a feedback item on this...

[John Eisbrener @johnedba]

@SQLBek Thanks for the positive feedback!

[John Eisbrener @johnedba]

@sqL_handLe It was me and you gave a terrific answer!

[John Eisbrener @johnedba]

I'm talking at #SQLSatMadison this year! Come out and heckle me or just be my room monitor. Sign up to volunteer at https://t.co/Jf7pCJjUzc

[John Eisbrener @johnedba]

@equerystrian @MADPASS Thanks to everyone that came out last night! A copy of the slide deck can be found here: https://t.co/67QyL4xrxy

[John Eisbrener @johnedba]

@ItzikBenGan is the Bob Ross, sans hairdo, of TSQL. Thanks for making complex queries and functions look so simple! #sqlsummit #sqlpass

[John Eisbrener @johnedba]

@luansql it was a good time! #Bierschnaps

[John Eisbrener @johnedba]

@onpnt I'd be willing to bet OCD is a bit more common in our profession... Call the extra time "equal opportunity" #sqlhelp