Even though support for XML data has been in the product for a long time now (introduced in SQL 2000 and then improved in SQL 2005), whenever I’m working with it I still find it completely unintuitive and constantly have to refer back to the documentation and previously worked examples. Most of all I rely Read more about JSONTABLE – Shredding JSON data into a relational structure[…]