Data As Code

Applying Software Engineering practices to Data Engineering with emphasis on Test-driven development (TDD)

Friday, June 21, 2024

JSON is now a first class citizen in Azure SQL Server

Azure SQL now supports JSON DataType. It is a binary data type that is way more performant than using a non-binary datatype to store JSON.

https://www.youtube.com/watch?v=WigP5PLQXhY

More info:

https://learn.microsoft.com/en-us/sql/t-sql/data-types/json-data-type?view=azuresqldb-current

https://learn.microsoft.com/en-us/sql/t-sql/functions/json-objectagg-transact-sql?view=azuresqldb-current

https://learn.microsoft.com/en-us/sql/t-sql/functions/json-arrayagg-transact-sql?view=azuresqldb-current

at June 21, 2024

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home

Subscribe to: Post Comments (Atom)

Re: Data Quality Monitoring using Data Metric Functions Snowflake

An detailed video overview of the Data Metric Functions in Snowflake: https://www.youtube.com/watch?v=M4MadvJH_Dc Saqib On Mon, Jun 10, 2024...

Equivalent of Matillion's Detect Changes in DBT

I am a fan of Test Driven Development (TDD). Basically I define tests based on the requirements, and then write code till those tests are s...
Re: dbt snapshots as a first class citizen

This is scheduled for Jun 13, 2024 08:00 AM Pacific Time (US and Canada). Please register here if you are interested: https://dbtlabs.zoom.u...
Snowflake Materialized Tables

Snowflake's Materialized Tables will bring Real-time loading into Data Vault based Data Warehouses.

Query Optimization in Snowflake (QOSF)

sql.edu.scot - forum.edu.scot. Simple theme. Powered by Blogger.