There are performance implications when choosing between the Default Schema and an Explicit Schema for SQL Server's OPENJSON rowset function.

[...Read More]

Can the performance of PIVOT be beaten with newer T-SQL features?

[...Read More]

Acquire web page data in-database with Machine Learning Services...and JSON. [...Read More]

Now that SQL Server supports JSON, schema-on-read should be a thing. Right? [...Read More]

Thoughts on JSON functions and some suggestions for the future. [...Read More]

Another option for splitting strings in TSQL. This one addresses a shortcoming of STRING_SPLIT. [...Read More]

Get started with a few examples using the OPENJSON and JSON_VALUE functions. [...Read More]