This T-SQL cheat sheet gathers daily SELECT, JOIN, GROUP BY, window, TRY_CONVERT, and transaction patterns with short examples.
SQL – Difference between != and <> Operator used for NOT EQUAL TO Operation
Is there any difference between != and the ANSI operator for not equal to in SQL Server? A Facebook fan asked, and technically they work the same way.
SQL SERVER – Check Database Level (IsNullConcat) and Session Level Settings (CONCAT_NULL_YIELDS_NULL) using T-SQL
A follow up on CONCAT_NULL_YIELDS_NULL: how to check the database level IsNullConcat setting and the session level setting using T-SQL.
Finding Encrypted Stored Procedures Before a Migration
Inventory encrypted stored procedures and other modules before migration, then recover their approved source and dependencies.
SQL SERVER – A Quick Note on CONCAT_NULL_YIELDS_NULL
A friend ran SET CONCAT_NULL_YIELDS_NULL OFF above every script to deal with NULL columns. Here is a quick note on what it does and what I think of it.
SQL SERVER – How to Refresh SSMS Intellisense Cache to Update Schema Changes
Dropped an index but SSMS still underlines it in red? Press CTRL + SHIFT + R to refresh the SSMS Intellisense cache and pick up your schema changes.
OPTIMIZED_SP_EXECUTESQL in SQL Server 2025: Fewer Compile Storms
Test OPTIMIZED_SP_EXECUTESQL in SQL Server 2025, inspect compilation counters and cached plans, and compare a concurrent workload.
Compare Showplan: Finding What Changed Between Two Plans
Compare Showplan shows where two plans differ, but not why. Here is a small before and after example you can run yourself.
SQL SERVER – Check If Column Exists in SQL Server Table
A very common task is to check if column exists in a SQL Server table before you act on it. Here are two simple methods, using sys.columns and COL_LENGTH.
Trying New SQL Server Features Without Risk
Trying New SQL Server Features safely takes a separate instance, a controlled data copy, and before and after measurements.










