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.
In this session we will see what system-versioned temporal tables are, how we can create and use them and what are the limitations and benefits of such implementation.
Microsoft Data Platform MVP | Senior Database Developer @Span | SQL Server User Group Croatia - Lead
Zagreb, CroatiaView Speaker Profile