JSON support now available in Azure SQL Database

Reading time icon 1 min. read

Readers help support MSpoweruser. We may get a commission if you buy through our links. Tooltip Icon

Read our disclosure page to find out how can you help MSPoweruser sustain the editorial team Read more

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.

More about the topics: Azure SQL Database, enterprise, JSON, JSON support, microsoft, SQL Tables