ASP.NET Core applications can sometimes result in the error “The certificate chain was issued by an authority that is not trusted.”
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.
SQL SERVER – Adjust Memory with Dedicated Administrator Connection (DAC)
the services did not start at all. Let us learn today how to Adjust Memory with a Dedicated Administrator Connection (DAC).
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.
Connection Strings Explained: Encrypt, TrustServerCertificate and Timeouts
Explain TrustServerCertificate, encryption modes, connection and command timeouts, listener failover, and server-side connection evidence.
SQL SERVER – Unable to Start SQL Server Service or Connect After Incorrectly Setting Max Server Memory to a Low Value
After incorrectly setting max server memory to 14 MB instead of 145000, a client could not start SQL Server. Here is how we got it back online.