In this session, we'll explore the recently announced JSON features and other T-SQL enhancements in Azure SQL Database. We'll explore how Azure SQL DB integrates JSON as a native data type, facilitating seamless data exchange across various systems and databases. The newly added JSON aggregates allow you to aggregate existing relational data into any complex JSON document easily. Discover the advantages of leveraging JSON in Azure SQL DB, including its flexibility, scalability, querying and document searching capabilities. Additionally, we'll look at the most requested T-SQL REGEX functions available for preview in Azure SQL DB. The newly added REGEX functions enable you to write concise queries that perform complex data pattern matching, and manipulation.