Some questions are very open ended. Here is one question I was asked in recent User Group Meeting about user without login.
Draw Pictures with T-SQL: The SSMS Spatial Results Tab
The SSMS Spatial results tab draws every geometry value a query returns. This post draws a house and a tree with STGeomFromText and STBuffer, explains labels and the 5,000 object limit, and checks store service areas for overlaps and gaps.
SQL SERVER – Not Possible – Delete From Multiple Table – Update Multiple Table in Single Statement
Can you delete from multiple table or update multiple tables in a single statement? No, and you should not try. Here is why, and what a reader pointed out.
Copy Column Headers From SSMS Results to Excel
To copy column headers from SSMS results, use Copy with Headers or press Ctrl+Shift+C. This post also shows the Options setting that includes headers every time, why a change can seem to do nothing, and how to stop Excel from dropping leading zeros.
Order of Operations in SQL Server: How PEMDAS Works in T-SQL
The order of operations in SQL Server follows PEMDAS, so 6/2*(1+2) returns 9. This post walks through the precedence rules with tested queries. It also covers integer division, the negative number trap and AND before OR.
SQL SERVER – Excel Losing Decimal Values When Value Pasted from SSMS ResultSet
I often get questions that how to fix the issue where excel loses decimal values when values are pasted from SSMS Resultset.
Keeping a Patch Test Environment Honest
A Patch Test Environment must match production data, settings, jobs, and versions closely enough to reveal real patch risks.