#5 So, what about JSON in my database?

The JSON data format, also called hipster's XML, is all around, not only in Javascript or .Net environments. In this session we'll first see where it comes from, what it looks like and what it can be used for. Next we'll explore how SQL Server handles JSON. Despite not providing a dedicated data type for it, there are some sophisticated functions for storing and retrieving JSON data, thus bridging NoSQL and relational concepts. After that we're joined by the NoSQL/document store solutions. Microsoft's own Azure Cosmos DB, as well as the "original" called MongoDB enter the comparison with SQL Server in terms of features and limitations, pros and cons. Eventually we'll know when to prefer which solution.