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.