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.
Introductory and overview Database

How did you like it?

We appreciate your privacy. Feedback is anonymous and is used to improve quality of our conferences.

Other speaker sessions

The speaker has no other sessions.