Everything You Wanted to Know About Implementing Temporal Tables
PASS Data Community Summit via YouTube
Google AI Professional Certificate - Learn AI Skills That Get You Hired
Learn EDR Internals: Research & Development From The Masters
Overview
Google, IBM & Meta Certificates — All 10,000+ Courses at 40% Off
One annual plan covers every course and certificate on Coursera. 40% off for a limited time.
Get Full Access
Explore the powerful feature of Temporal Tables in SQL Server through this comprehensive conference talk from PASS Data Community Summit. Dive into the world of data versioning and historical analysis as Ben Miller guides you through implementing and leveraging Temporal Tables. Learn how to set up this feature on both new and existing tables, understand its practical applications, and master the new syntax for querying historical data. Discover the evolution of Temporal Tables from SQL Server 2016 through SQL 2019, including the introduction of Retention Policies. Gain insights into solving common data tracking challenges, such as viewing data states from previous points in time and eliminating the need for complex trigger-based change capture mechanisms. Embark on a time-traveling adventure to unlock the potential of Temporal Tables in your database environment and revolutionize your approach to data history management.
Syllabus
Everything You Wanted to Know About Implementing Temporal Tables - Ben Miller
Taught by
PASS Data Community Summit