Investigate ASYNC_NETWORK_IO with request and task evidence, check client consumption, and separate large outputs from network faults.
Connecting to SQL Server From Home Without Exposing Port 1433
Keep port 1433 off the public internet by checking external reachability and using VPN, a jump host, Bastion, and trusted encryption.
Reading a Network Trace of a SQL Server Connection
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.