We are thrilled to announce the public preview of local time zone support in Azure SQL Database. Starting today, you can configure the time zone directly at the database or session level — all from T-SQL, without changing any infrastructure settings. This feature addresses one of the most consistently requested capabilities from the Azure SQL commu...

We are excited to announce the General Availability (GA) of the native JSON data type and JSON aggregates - JSON_OBJECTAGG & JSON_ARRAYAGG. You can use the JSON data type and JSON aggregates to integrate and work with JSON documents more efficiently in the database. This functionality is available in Azure SQL Database, Azure SQL Managed Instan...

Azure SQL Database, Azure SQL Managed Instance and SQL Server currently support JSON text processing in T-SQL batches. This functionality allows you to store and manipulate JSON documents in the database. The JSON functions - ISJSON, JSON_VALUE, JSON_QUERY, JSON_MODIFY allows you to validate, query and modify JSON documents. The FOR JSON operator a...