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 moreRelated posts
Azure VMware Solution - Using Log Analytics With NSX-T Firewall Logs
Azure VMware Solution How To Series: Monitoring Azure VMware Solution Overview Requirements Lab Environment Tagging & Groups Kusto ...
Troubleshoot your apps faster with App Service using Microsoft Copilot for Azure | Azure Friday
This video provides you with a comprehensive overview of how to troubleshoot your apps faster with App Service utilizing Microsoft Copilot for...
Looking to optimize and manage your cloud resources? Join our Azure optimization skills challenge!
If you're looking for an effective way to optimize and manage your cloud resources, then join the Azure Optimization Cloud Skills Challenge or...
Have a safe coffee chat with your documentation using Azure AI Services | JavaScript Day 2024
In the Azure Developers JavaScript Day 2024, Maya Shavin a Senior Software Engineer at Microsoft, presented a session c...
Azure Cosmos DB Keyboard Shortcuts for Faster Workflows | Data Explorer
Azure Cosmos DB Data Explorer just got a whole lot easier to work with thanks to its new keyboard shortcuts. This update was designed to make ...
How to Use Azure Virtual Network Manager's UDR Management Feature
What will you learn in this blog? What is Azure Virtual Network Manager’s UDR management feature? How UDR management simplifies route setting...
Secure & Reliable Canonical Workloads on Azure | GA Availability
With Azure's partnership with Canonical, the industry standard for patching Linux distributions on the cloud is elevated. The collaboration hi...
Azure VMware Solution now available in Italy North, Switzerland North and UAE North
Azure VMware Solution continues to expand its reach, as it is now accessible in Italy North, Switzerland North, and UAE North. With this expan...
Connecting Azure to Mainframes with Low Latency
Many organizations are running their mission critical workloads on the mainframe and would greatly benefit by incorporating the mainframe in t...