What are the new JSON capabilities available in SQL database Public Preview

Umachandar Jayachandran shares about JSON data type & aggregates in Azure SQL Database Public Preview.
Learn more: msft.it/6059mDSR3
#AzureSQL
#OneDevQuestion

[@julycastiblanco]

Why should I use sql database instead of cosmosdb to store json documents?

[@carlosmunozrodriguez]

Maybe a little array of ints instead of a new related table, or a tree of something that is always read as a single unit. Those little uses cases doesn't justify the provisioning of an instance of a whole different DB type.

[@DavideMauri]

'Cause you can then have the best of both worlds, and you can decide at any time, without the need for re-platforming, to move from unstructured or semi-structured data to a structured one, or even have both at the same time

[@gotqn2103]

Why the SQL Database gets all the love by mam and dad and the SQL Server is sent to foster home?