Free
AUG 2022 - Change Management with CT and Temporary Tables by Tim Mitchell

AUG 2022 - Change Management with CT and Temporary Tables by Tim Mitchell

Actions and Detail Panel

Free

Event Information

Share this event

Date and time

Location

Location

Online event

Event description
AUGUST 2022 - Change Management with Change Tracking and Temporal Tables by Tim Mitchell

About this event

Abstract

Managing and moving data efficiently requires a reliable system for detecting changes, and in some cases, for tracking the history of those changes. For data stored in SQL Server, there are two easy-to-use methods for this: change tracking and temporal tables. In this session, we'll take a look at SQL Server change tracking and SQL Server temporal tables. We'll cover the basics of each of these and will review some ideal use cases for each. We'll go through several demos to show how these can be used through normal T-SQL operations as well as ETL tools such as SSIS.

Speaker Bio

Tim Mitchell is a business intelligence architect, author, and trainer. He has been building data solutions for over 17 years, specializing in data warehousing, ETL/SSIS, and reporting. He holds a bachelor’s degree in Computer Science from Texas A&M at Commerce and has been recognized as a Microsoft Data Platform MVP each year since 2010. Tim is the founder and principal data architect at Tyleris Data Solutions, a consulting firm focused on delivering on-premises and cloud-based solutions on the Microsoft data platform.

Share with friends

Date and time

Location

Online event

Save This Event

Event Saved