Webcast : Troubleshooting SQL Server Connection Issues

Presenter: Robert L Davis
Share This:  Facebook Twitter LinkedIn Google+

Whenever a connection to SQL Server fails, it’s usually blamed on SQL Server by default. There are dozens of things between the user and SQL Server that could cause the connection to fail. The problem is proving it. How do you convince someone that “it’s not me, it’s you”? And then of course, sometimes it actually is SQL Server. This session will demonstrate how to determine the root cause of the failures and explain how to prove to others what the real issue is.

We will look at some of the most common connection issues and show how to troubleshoot them. This session will start with the basics like firewalls and SQL Server protocols and move on to some more advanced topics like mining the ring buffer connectivity data for connection issues.

Speaker(s): Robert L Davis is a Microsoft Certified Master in SQL Server and a Data Platform MVP. He is a Database Engineer by day who spends most of his time performance tuning the queries written by a small army of data scientists at BlueMountain Capital Management. He is passionate about disaster recovery, availability, performance tuning, and security. He is co-leader of the PASS Security Virtual Chapter. He founded SQL Server Best Practices website (www.sqlbp.com) and blogs at www.SQLSoldier.com.

Register for Free Webcast

Register For Free Webcast