In late-May 2024, the following updates and enhancements were made to Azure SQL:
-
New JSON functionality: Use native JSON type to manage and query JSON documents. Use ANSI SQL JSON Aggregates - JSON_ARRAYAGG and JSON_OBJECTAGG to aggregate data into JSON documents.
-
Monitor the database availability for Azure SQL Database using the SLA compliant availability metric.