JSON_OBJECT constructs a typed object payload. Choose null or absent properties deliberately and preserve empty strings as present values.
Staging, Warehouse and Mart: Why Three Layers
Staging, warehouse and mart give data loads, trusted history, and focused reporting separate jobs; learn when each layer earns its place.
SQL SERVER – Fillfactor, Index and In-depth Look at Effect on Performance
Where in SQL Server does 100 equal 0? In Fillfactor settings. An in-depth look at how the Fillfactor of an index affects page fill and performance.
SQL SERVER – Difference TempTable and Table Variable – Table Variable in Memory a Myth
Is a table variable in memory while a temp table lives in TempDB? It is a myth: both are created in TempDB, and a simple script proves it.
SQLAuthority News – An Year of Personal Events – A Life Outside SQL
Do I have a life outside SQL? Yes, and it is beautiful. Three photographs from my year of personal events, told with very few words.
DATEADD Fractional Numbers: Truncate Before Addition
DATEADD fractional numbers are truncated, not rounded. Compare positive and negative day additions while preserving an explicitly typed date input.
SQLAuthority News – Featured on Channel 9
This blog was featured on Channel 9 in This Week on Channel 9, where Scott Hanselman and Jon Galloway talked about my CSV from table column post.