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.