JSON support now available in Azure SQL Database

Reading time icon 1 min. read


Readers help support MSPoweruser. When you make a purchase using links on our site, we may earn an affiliate commission. Tooltip Icon

Read the affiliate disclosure page to find out how can you help MSPoweruser effortlessly and without spending any money. 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