22-25 April 2026 
SQLBits 2018
Back to the future with Temporal Tables
Back to the Future is the greatest time travel movie ever. I'll show you how temporal tables work, in both SQL Server and Azure SQL Database, without needing a DeLorean.
Back to the Future is the greatest time travel movie ever. I'll show you how temporal tables work, in both SQL Server and Azure SQL Database, without needing a DeLorean.
We cover point in time analysis, reconstructing state at any time in the past, recovering from accidental data loss, calculating trends, and my personal favourite: auditing.
There's even a bit of In-Memory OLTP.
There are lots of demos at the end.
We cover point in time analysis, reconstructing state at any time in the past, recovering from accidental data loss, calculating trends, and my personal favourite: auditing.
There's even a bit of In-Memory OLTP.
There are lots of demos at the end.
Speakers
Randolph West's previous sessions
An overview of SQL Server 2019 for the busy DBA / developer
This session will take a look at better Unicode support, query processing improvements for row store tables, secure enclaves, and other neat things you'll find useful as a modern database administrator or developer.
Back to the future with Temporal Tables
Back to the Future is the greatest time travel movie ever. I'll show you how temporal tables work, in both SQL Server and Azure SQL Database, without needing a DeLorean.