#stretch database

Temporal Tables – Simple Guide to implement History Tables using SQL Server 2016/2017–Part 5- Storing History data in Azure using Stretch Database

In previous posts, we saw

Part 1 – How to create Temporal Tables

Part 2 – Accessing History data from Temporal Tables

Part 3 – Modifying Temporal Tables, Disabling System versioning and why we need to disable ?

Part 4 – Managing Temporal Tables and History Data

In this post we will see how to store the history data in Azure using Stretch database

Step 1:Right click on Database name and click on…

Stretch Database in SQL Server

Data is usually categorized into levels of importance and frequency of use based on age, and older data is usually less important than recent data. While today’s data, or this week’s data, is access more frequently than older data, you usually have to keep that older data for compliance or business-specific reasons. Storing historical data that isn’t accessed very often can be more expensive if…