XQuery node order compares positions in an XML document, not their text. Source order, alphabetical order and a node compared with itself give different answers.
geometry STAsBinary: Carry the SRID Beside the WKB
geometry STAsBinary exports a geometry as WKB, while reconstruction takes a separate spatial reference identifier. I carry that identifier beside the bytes. Supplying a different identifier creates a differently tagged value from the same exported coordinates.
geometry STPointN: Read a One-Based Point Position
geometry STPointN selects a point from an instance. The example keeps its one-based position visible and returns NULL when the requested position exceeds the line point count.
REGEXP_REPLACE Text Cleanup: Replacing Tags Is Not Parsing HTML
REGEXP_REPLACE can remove controlled tag-like text, but that is not the same as parsing HTML. Test quoted brackets, surviving script text and word boundaries before deciding whether the replacement fits the input.
SQL SERVER – Puzzle – SELECT * vs SELECT COUNT(*)
SELECT * gives an error when run alone, but SELECT COUNT(*) does not. Why? Here is my SELECT * vs SELECT COUNT(*) puzzle from the Bangalore User Group.
OPENJSON Default Schema: Read Its Type Codes
OPENJSON default schema exposes key, value and type. Compare all six type codes, retain JSON null, and distinguish scalar text from nested fragments.
SQL SERVER – Running SSIS Package in Scheduled Job
How to run an SSIS package on a schedule with a SQL Server Agent job, step by step, after my earlier post on running it from the command line.