Loading...

Announcing JSON Enhancements in Azure SQL Database, Azure SQL Managed Instance and SQL Server 2022

Announcing JSON Enhancements in Azure SQL Database, Azure SQL Managed Instance and SQL Server 2022

Azure SQL Database, Azure SQL Managed Instance and SQL Server 2022 have recently announced enhancements to their JSON text processing capabilities. These enhancements enable the storage and manipulation of JSON documents within the database, providing an array of functions including ISJSON, JSON_VALUE, JSON_QUERY, and JSON_MODIFY for document validation and modification. By utilizing these JSON functions, developers can efficiently process JSON documents using T-SQL batches, bringing greater flexibility and scalability to their applications and processes.

Overall, these enhancements represent a significant step forward in the handling of JSON data, bolstering the capabilities of Azure SQL Database, Azure SQL Managed Instance and SQL Server 2022, and equipping developers with a powerful set of tools to more easily manage and process JSON documents.

The post Announcing JSON Enhancements in Azure SQL Database, Azure SQL Managed Instance and SQL Server 2022 was originally published in Azure SQL Database Devs’ Corner.

Published on:

Learn more
Azure SQL Devs’ Corner
Azure SQL Devs’ Corner

Voices from the Azure SQL PM Team, focusing on development and developers

Share post:

Related posts

SQL 4 CDS v8 Released

SQL for CDS v8 brings with it a game-changing feature – Common Table Expression (CTE) support, along with enhanced JSON functionality. ...

9 months ago

Azure SQL Database Elastic Jobs preview refresh

The Azure SQL Database Elastic Jobs preview has received a significant "refresh", including several capabilities requested by customers. Among...

8 months ago

Developing with Azure SQL bindings and Azure SQL trigger for Azure Functions

This post sheds light on how to harness the combined power of Azure SQL bindings and triggers in Azure Functions to create event-driven scenar...

1 year ago

Develop with SQL on your desktop using the Azure SQL Database emulator | Azure Friday

Azure Friday brings a video tutorial on how to develop apps with SQL on your desktop using the Azure SQL Database emulator. The tutorial focus...

1 year ago

SQL Server > Find a specific value in column of table in the whole database using T-SQL

In this post, you'll learn how to use T-SQL to find a specific value in a column within a SQL Server database. This can come in handy when you...

1 year ago

How to Identify SQL Server Database Server Name / Instance Name | SQL Tutorial for Beginners (15/20)

Learn how to identify SQL server database server name and instance name with this SQL tutorial for beginners. This video is part of a series t...

2 years ago

Announcing General Availability of Change Data Capture (CDC) on Azure SQL Database

Azure SQL Database users, rejoice! Change data capture (CDC) is now generally available on the platform, offering you insight into your user t...

2 years ago

Azure SQL Database Ledger

In this special episode, Pieter Vanhove joins Sarah and Michael to provide insights into the latest feature of Azure SQL Database Ledger. This...

2 years ago

Azure SQL Managed Instance Windows Authentication

In this episode, Michael discusses the preview feature of Windows authentication support for Azure SQL Managed Instance with Sravani Saluru, a...

2 years ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy