PostList

Historical data with MS SQL System-Versioned (Temporal) Tables

Historical data with MS SQL System-Versioned (Temporal) Tables

Before the existence of system-versioned temporal tables, tracking changes in a database table forced us to implement some custom solutions based on triggers, stored procedures etc. System-versioned temporal tables offer us the possibility to keep a full history of data changes and allowing us easy point in time analysis. Using this solution, we can easily time travel through the data and see what the exact state of the data in a point of time was....

Read More
Modify JSON data using JSON_MODIFY

Modify JSON data using JSON_MODIFY

After discussing about how MS SQL Server can help us to format MS SQL data in JSON format and how to read JSON data in MS SQL Server, in this article we will see how we can modify JSON data in MS SQL Server using JSON_MODIFY function....

Read More
MS SQL JSON functions, tips & tricks

MS SQL JSON functions, tips & tricks

After discussing about how MS SQL Server can help us to format MS SQL data in JSON format and how to read JSON data in MS SQL Server, in this article we will quickly pass over some additional functions, tips and tricks and possibilities handling JSON data in MS SQL Server....

Read More
Read JSON data in MS SQL

Read JSON data in MS SQL

Starting from MS SQL server 2016 you can convert JSON data to tabular format. It is possible using the newly introduced OPENJSON rowset function. Let’s find how!...

Read More
Format MS SQL data in JSON format

Format MS SQL data in JSON format

Prior to MS SQL server 2016 manipulating data in JSON format was not supported and sometimes a challenging task, forcing us to implement third party solutions (e.g. CLR). In this article we will see how we can create JSON objects from MS SQL data....

Read More
MS SQL AT TIME ZONE

MS SQL AT TIME ZONE

MS SQL AT TIME ZONE was introduced in MS SQL version 2016 and the main purpose is to convert an inputdate to the corresponding datetimeoffset value in the target time zone....

Read More
MS SQL COMPRESS AND DECOMPRESS

MS SQL COMPRESS AND DECOMPRESS

MS SQL COMPRESS and DECOMPRESS are introduced into MS SQL version 2016. In this post we will read the overview of both functions, limitations and benefits. We will also test the performance compared to ROW and PAGE compression methods....

Read More