JSON is the leading data interchange format for web applications and more. Here’s what you need to know about JavaScript Object Notation.

HTML is the markup format that all web pages use, potentially allowing Tasker to parse the contents of pages in a similar manner to browser extensions and other web-scraping tools.

SQL Server 2016 lets you treat JSON objects like rows in a table, allowing you to use data from AJAX queries in joins, updates and any other SQL statement you can think of.

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.