Preview: Temporal tables in Azure SQL Database

22 February 2016

Now available in preview, you can use temporal tables in all service tiers of Azure SQL Database. Temporal tables are a productivity tool for developing applications that aim to provide insights from historical data. Temporal tables allow you to track the full history of changes in critical data directly in Azure SQL Database, without the need for custom coding. You can efficiently focus business analysis on a specific point-in-time. Use temporal tables to:
  • Add data auditing capability to your applications.
  • Version data to analyze trends or detect anomalies over time.
  • Perform fine-grained repairs if there is an accidental corruption made by humans or applications.
To get started, create new system-versioned temporal tables in your database or extend existing tables to become temporal. For more information, check out Getting Started with Temporal Tables in Azure SQL Database.

Free account

Get $200 in Azure credits and 12 months of popular services—free

Start free

Visual Studio

Subscribers get up to $1800 per year of Azure services

Activate now

Startups

Join the BizSpark program and get free Azure services

Learn more