Do you store data in XML format in SQL server? Why or why not?

Data Science, AI and ML
,
#1

We used to store lots of unstructured data in XML format. Some of the examples were metadata information about media gallery, campaign capture info from customers etc. Most cases the data was generated by an external device and fed into db through asynchronous process. In such cases it was easy to post data within XML envelope tied to a XSD schema.

Recently we’re preferring JSON over XML due to its light weight nature and also because of interoperability with many applications in case data needs to be communicated with them.
So there are cases where formats like XML, JSON come handy and of late latter is gaining more popularity over the former