Damir Matešić

Information & Communications Technology

SQL Sever T-SQL Azure SQL Database Azure SQL Managed Instance SQL Azure SQL DB Data Platform Microsoft SQL Server Performance Tunning

Zagreb, City of Zagreb, Croatia

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.

Damir Matešić

Microsoft Data Platform MVP | Senior Database Developer @Span | SQL Server User Group Croatia - Lead

For many years Damir is a passionate programmer and a Microsoft SQL Server developer (ver. 2000+).
He is a certificated Microsoft professional on various technologies.
He leads the Croatian SQL Server User Group and he introduced SQL Saturday Event in Croatia. He organizes various Data Platform events in Croatia.
Founder and organizer of #DataWeekender. #DataWeekender is a popup online conference, organized by a group of European based Microsoft data platform professionals. Originally created as a response to Covid-19, this is now a regular online event.
He is currently working as Senior Database Developer @Span.eu.
Damir speaks on various community events, conferences and user groups.
When free he blogs about SQL @ https://blog.matesic.info.

Damir's full speaker profile