XML vs JSON in SQL Server 2016

Starting with the 2016 release, SQL Server offers native JSON support. We compare JSON versus XML and determine which is better to use in SQL Server.

Elsewhere on the internet:

[lukeav]

Thank you for making this video. I was torn between xml and json. JSON here I come.

[Stelios.Posantzis]

Very nice. Very informative and relaxing to watch - for those of us too lazy or time constrained to try to figure things out on our own. Also, far less dreary than reading a blog at work... I don't think I've ever watched a video by a SQL developer who was smiling : )

[narendrannaren]

Thanks Bert for your Clear explaination.

[Themojopriest]

Very informative! Thank you very much, Bert. :)

[harbor.boundary.flight]

Thanks Bert really useful and clearly explained

[stefanotorelli]

What about cardinality estimations on XML and NVARCHAR(MAX) JSon columns? are they the same?

[chiragjoshi]

Nice Video Bert !! worth to appreciation. - What do you think about following use case?
1) Use XML for Insertion and Update and when there is a matter of reading then do it from a computed column, where a computed column is json conversion of XML data type so that we get both benefits of XML & JSON !!

[harisbegluk]

Perfect video, can you make video about basic uses of JSON in production sites with examples? Thank you for this video.