A bare THROW passes an error on untouched. A new THROW or a copied RAISERROR message does not. See the proof, plus one semicolon trap.
SQL SERVER – SSMS Does NOT Print NULL Values
Here is a very interesting question asked on the blog by Karthik. I really liked the question and I would like to discuss this here about SSMS doe snot Print NULL values.
What Is a Star Schema?
A star schema is one fact table surrounded by dimension tables. What facts and dimensions hold, why grain is the decision you cannot undo, why the data repeats on purpose, and a worked example in AdventureWorksDW.
Subtotals and Grand Totals With ROLLUP and GROUPING SETS
Build region, product, and grand totals with ROLLUP, CUBE, and GROUPING SETS, then label subtotal rows and compare plans.
nodes() Method in SQL Server: Aliases and Row Patterns
The nodes() method turns each element at a path into one row you can query. This post builds a small catalog of books and reviewers, and shows the two alias errors, query() against value(), the singleton rule, how the row pattern decides the rows, and CROSS APPLY for the next level. Every result comes from SQL Server 2025.
Custom Date Format Strings in SQL Server: MM Is Not mm
Custom date format strings tell FORMAT exactly which parts of a date to show. This post compares CONVERT styles with FORMAT, lists the standard and custom letters, and shows the traps: MM against mm, YYYY against yyyy, month names that sort wrong, and a culture that changes with the session. Every result comes from SQL Server 2025.
Spatial Unions in SQL Server: STUnion and UnionAggregate
Spatial unions merge shapes that touch or overlap into one shape. This post uses six land parcels on a flat grid to show STContains, STUnion for two shapes, chained unions, UnionAggregate with GROUP BY, and CollectionAggregate for comparison. Every area and result comes from SQL Server 2025.