Before you switch off a protocol, find out who still uses it. Two short queries show how each session connected, and why the address is not a person.
Converting float to Text Without Losing Digits
The default float to text conversion keeps about six digits. Here is the one style that gives your float back exactly, and the traps around it.
Spotting Definition Drift With HASHBYTES on Module Code
Did someone change a production procedure and forget to tell you? Hash the module text, compare it with a baseline, and let SQL Server point at the culprit.
Error 2628: Finding the Value That Would Be Truncated
A nightly import fails and nobody knows which column is too small. Error 2628 tells you. Here is how to read it and catch every oversized value up front.
query_store_query_text: Searching Query History by Statement Text
A LIKE search on Query Store text is a good first step, but one search found four statements, including itself. I show how to narrow it down to the real history.
Linked Servers and What Goes Wrong With Them
Investigate linked server performance and failures by checking remote work, provider settings, security mappings, and the alternatives available.
SQL SERVER – Best Practices About SQL Server Service Account and Password Management
Should the SQL Server Service Account be a local or domain admin? No. Best practices from a client Q&A on service accounts, permissions and passwords.