JSON support now available in Azure SQL Database

SQL Azure Performance

Microsoft recently announced that JSON support is generally available in Azure SQL Database. With this support, users can now query and store both relational and textual data formatted in JSON using Azure SQL Database. Azure SQL Database also comes with simple built-in functions that read data from JSON text, transform JSON text into table, and format data from SQL tables as JSON.

This support allows developers to build and exchange data with modern web, mobile, and HTM5/JavaScript single-page applications, NoSql stores such as Azure DocumentDB that contain data formatted as JSON, and to analyze logs and messages collected from different systems and services. Also, they can now integrate Azure SQL Database with any service that uses JSON with ease.

Check out Microsoft’s Getting Started page or Channel 9 video for more details.