Renaming a column safely requires finding SQL and application references, applying sp_rename, refreshing modules, and testing every consumer.
SQL SERVER – Preserve Leading Zero While Coping to Excel from SSMS
Want to preserve leading zero values when you paste SSMS results into Excel? The fix is in Excel: format the cells as Text first, and the zeros stay.
SQL SERVER – Importance of User Without Login
Some questions are very open ended. Here is one question I was asked in recent User Group Meeting about user without login.
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.
SQL SERVER – Validating Unique Column Name Across Whole Database
A Unique Column Name check lists existing matches across visible database metadata. I use it as an inspection, not an enforcement guarantee.