A sixty second video on resolving SQL Server connection errors, the kind first time IT pros often hit after a fresh install and cannot figure out.
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.
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.
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.
SQL SERVER – Replace a Column Name in Multiple Stored Procedure All Together
A beginner on a development server asked how to replace a column name in Multiple Stored Procedure code all together. Here is the quick way I suggest.
SQL SERVER – SSMS Automatically Generates TOP (100) PERCENT in Query Designer
Why does Query Designer in SSMS keep adding TOP (100) PERCENT when you create a view? A forum question, the full scenario, and what is going on.
SQL SERVER – Get Date and Time From Current DateTime – SQL in Sixty Seconds #025 – Video
How do you get date and time separately from the current datetime? This sixty second video answers three common beginner questions with simple CONVERT scripts.