Details

Working with Temporal Data in SQL Server

Speaker: David Maxwell

Duration: 60 minutes

Track: Database & Application Development

Submit Session Evaluation

In many industries, it is necessary for data professionals to be able to show what a data set looked like at a previous point in time. Whether it's calculating tax or insurance rates based on a contract date, quickly comparing data changes over time for trend analysis or just recovering from an accidental data change, it's useful to be able to look back in time through our data. SQL Server has long offered solutions like Change Data Capture or trigger-based audit tables, though those aren’t always the best solutions for each situation. SQL Server 2016 introduces system-versioned tables, which track data through time with far less overhead than other solutions. In this session, you'll learn how to work with tables for each kind of solution, how SQL Server manages data within those tables, and how to query data at a specific point in time using several real-world examples. Attendees will leave with a fundamental understanding of practical use cases for different types of temporal tables.


Back to Top
cage-aids
cage-aids
cage-aids
cage-aids