Whilst a JSON lad myself; the XML data type is commonly used, especially in
applications using .Net and dealing with serialization. Data sets provided in
XML can be parsed with relative ease using C#; however in SQL Server it can be
tricky especially when you want to work in sets.