In SQL Server, we treat XML with a reverence that is disproportionate to its importance. This hit me whilst reading up on XML. I’ve come a bit late to Michael Coles’ wonderful ‘Pro SQL Server 2008 XML’. It is the first book on the subject of using XML in SQL Server that I’ve enjoyed, and that is because Michael is keen to put XML firmly in the context of the needs of the database developer. He has all the right instincts. However, to see the extent to which XML has insinuated itself into SQL Server so eloquently laid out only makes me even more baffled as to why the same hasn’t been done for JSON, or even HTML; both of which are dominant, human-readable, platform independent, open data-exchange formats that can be used wherever applications need to exchange or store structured information as text, and which may need to be shredded by SQL Server.