Unfortunately (well, actually fortunately :)) our SQL servers don't allow any incoming traffic from the internet so Wireshark trace just shows it's connecting but then it stops, no replies come...

Thanks, very useful info! Just a small remark about finding the start time in the ERRORLOG. The log may have been re-initialized so the current log file might not include...

What a touching article. I'd never head of the "imposter syndrome" but I do feel related. As Jeff mentions, we shouldn't try to fix that feeling, although it is an...

This looks super-handy, thanks for sharing.

Note the small typo on the web site though: EnterpriCe instead of EnterpriSe. Unless this was intentional, given the price for Enterprise Edition 🙂

hey doesn't work in SSMS, you need to use Azure Data Studio

Hi Steve

I think this is something every DBA needs to know about, so thanks for sharing!

I have a small note though...  I have restored master a few times on an...

Hmm, no comments yet? Curious.

I'm that type of person who really likes to know how something works. I just love all the fantastic info coming from you and guys/girls like...

Thanks for the feedback Luke, much appreciated!

Hi,

facing the same kind of issues (intermittent connection issues) on a comparable environment.

Found this https://support.microsoft.com/en-us/help/4557473/errors-when-applications-try-to-connect-to-sql-server-in-windows

Haven't checked yet though because of project and other constraints but maybe you'll find...

I like CLR! Imagine all the possibilities...
I don't like CLR! Imagine all the possibilities...

I agree with Andreas. Make sure you have a backup first 🙂
Depends on a number of things but some quick ideas that come to mind.
If you're on VM,...

Thanks for sharing. I tend to be on KenpoDBA's side though... don't like xp_logininfo either.
Btw, did a little test: created a plain login and granted it CONTROL SERVER. It...

Thanks for sharing.
I may be wrong but I don't think any of the SqlConnection constructors throws exceptions (cfr https://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.sqlconnection(v=vs.110).aspx)
So the try/catch shouldn't be...