For any disruption at the primary node you want the service to failover to the secondary. However, it is better to keep the fail back to manual so you can...

Three options

1. Cost saving for company (flexible too) --> Sites like Lynda, Pluralsight etc
2. Recommended for depth or better overall exposure to DBA skills --> any instructor...

Investigate your common or long running transactions. It is possible that the transactions are running long enough there by not releasing locks. This is one of the common symptoms of...

When I hire candidates I would like to test them for below things

1. Are they passionate about data?
2. Are they self learners? Involved in reading or community...

Both the servers support data transfers upto 2 gbps on the NICs and there is an 8 gig pipe between them. If something like QOS is enabled I dont know...

So it seems that login comes from the server itself. I would check the Agent jobs. Maybe there is a job that runs once a minute and runs SQLCMD...

Thank you Grant. I reviewed it and the section above says its applicable to Classic deployment model. I believe I can use this TSQL for the Resource manager...

The 32 bit client should work just fine. How you determined this is not a network issue at all? Does ODBC connectivity work?