SQL Server network latency can make a fast database look slow. An application that fetches 4,000 orders one query at a time pays for every round trip. I measured the loop against one query, tested what ASYNC_NETWORK_IO means, and show how to check your own round trip time.
SQL SERVER – Fix – Error – The certificate chain was issued by an authority that is not trusted
ASP.NET Core applications can sometimes result in the error “The certificate chain was issued by an authority that is not trusted.”
Implicit Transactions in SQL Server: The Setting That Leaves Work Open
Implicit transactions make SQL Server open a transaction on the first data statement and keep it open until a COMMIT or ROLLBACK. This post shows what starts one, how @@TRANCOUNT counts it, why a second session waits, and how to find and clear the sessions that left work open.
Tagging Queries With SESSION_CONTEXT to Trace App Users
Tag SQL Server work with SESSION_CONTEXT, read tags in audit defaults and modules, and handle read-only values and pooled connections.
Read-Only Routing for Availability Group Replicas
Configure availability group read-only routing, listener connections, replica URLs, balanced lists, and verification after failover.
Max Server Memory Set Too Low: Fix It Through the DAC
Max server memory set too low can stop SQL Server from answering normal connections. This post shows how to connect through the Dedicated Administrator Connection, raise the value with sp_configure and start the service when it will not start.
Logon Storms: Protecting SQL Server From Connection Floods
Diagnose SQL Server logon storms, control connection growth, test a limited logon trigger, and preserve administrator recovery access.