Read a network trace of a SQL Server connection by separating TCP, pre-login, TLS, login, and first-query delays before tuning queries.
What TDS Is and Why It Matters to You
What TDS is becomes practical when a SQL Server connection fails: it carries login and query traffic, packet settings, and encryption negotiation.
Connection Resiliency: Surviving Brief Wi-Fi and Network Drops
Configure connection resiliency for brief idle network drops, test ConnectRetryCount and ConnectRetryInterval, and separate retryable failures.
Finding the Client IP Address of a Connection
Find the client IP address of a SQL Server connection with DMVs and CONNECTIONPROPERTY, and understand proxy and local transport limits.
SQL SERVER – Running Batch File Using T-SQL – xp_cmdshell bat file
What is xp_cmdshell used for, and how do you run a batch file using T-SQL? Examples run a system command, a plain BAT file and one with a parameter.
SQL SERVER – De-fragmentation of Database at Operating System to Improve Performance
Why does de-fragmentation of database files at the operating system level skip MDF files? SQL Server has them open, so stop the services first.
SQL SERVER – Fix : Error : An error has occurred while establishing a connect to the server. Solution with Images.
An error has occurred while establishing a connection to the server, also known as Error 40, is the top error searched on my blog. Here is the fix in screenshots.