Dino Esposito explains JSON-to-rowset native support in SQL Server 2016 and provides a realistic perspective of data query when you have JSON data stored in the database.

We look at how to gain structure from unstructured data, via AI/ML analytics to create new records, selecting object data via SQL and storing unstructured files in NoSQL formats.

For more than 40 years, SQL has provided a standard way to query structured data. However, much of the data being generated and stored today exists in semi-structured formats, like JSON, which doesn’t ...

Today, JSON is the universal standard of data exchange. It is found in every area of programming, including front-end and server-side development, systems, middleware, and databases.