HomeWinBuzzer NewsAzure SQL Database Scores Temporal Tables

Azure SQL Database Scores Temporal Tables

Temporal Tables in Azure AQL Database helps customers to manage their data in more detail. Users can track data history throughout their databases.


The feature-set of has been given a boots. has updated the platform to add a feature called “Temporal Tables”. With this addition, customers will be able to track their data history directly in SQL Database.

In fact, the entire history of your data can be viewed without needing to use custom coding. Temporal Tables also give the ability to see data at any specific point in the history. With this data, users can set a declarative cleanup policy to control retention for the historical data.

Temporal Tables have been made available for all Azure SQL Database customers. Microsoft says they improve productivity and help maintain data when creating apps:

“Quite often you may be in the situation to ask yourself fundamental questions: How did important information look yesterday, a month ago, a year ago, etc. What changes have been made since the beginning of the year? What were the dominant trends during a specific period of time?  Without proper support in the database, however, questions like these have never been easy to answer”

Here's what Temporal Tables can be used for:

  • Supporting data auditing in your applications
  • Analyzing trends or detect anomalies over time
  • Easily implementing slowly changing dimension pattern
  • Performing fine-grained row repairs in case of accidental data errors made by humans or applications

Recent SQL Database changes

Microsoft announced that the ability to develop databases using Always Encrypted in July. The feature is now supported in SQL Server Data Tools (SSDT). The company said developers can now create protected data within a database.

Always Encrypted is available in both SQL Server 2016 and Azure SQL Database and it allows users to protect sensitive data by transparently encrypting and decrypting data sent from the database column.

Luke Jones
Luke Jones
Luke has been writing about all things tech for more than five years. He is following Microsoft closely to bring you the latest news about Windows, Office, Azure, Skype, HoloLens and all the rest of their products.

Recent News