AUG 2022 - Change Management with Change Tracking and Temporal Tables by Tim Mitchell (@TimMitchell)
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.
Slide deck and code
https://www.timmitchell.net/wp-content/uploads/2022/09/Change-Tracking-and-Temporal-Tables_LA2022.zip
-
6:55
Chrissy Clark
12 hours agoLGBT Activists Want Katy Perry To Stop THIS?!
48.2K33 -
16:27
justintech
16 hours agoBest Gaming PC 2024 For Every Budget!
48.2K4 -
1:22:40
Crime Circus
17 hours agoBad Boy sneaks KNIFE into interrogation!!
54.6K9 -
2:06:10
Laura Loomer
10 hours agoEP44: TRUMP ON TRIAL: SCOTUS Hears Presidential Immunity Arguments Ahead of 2024 Election
56.2K69 -
3:04:11
Melonie Mac
11 hours agoGo Boom Live Ep 1: Stellar Blade and More!
37.7K18 -
3:59:31
barstoolsports
19 hours ago2024 En Eff El Draft Presented by DraftKings
42.6K2 -
1:27:40
Kim Iversen
13 hours agoSHOCKING IDF LINK EXPOSED: Campus Riot Police Trained In Israel | Update To Julian Assange CIA Spying Case
51.6K144 -
1:01:33
The Anthony Rogers Show
21 hours agoEpisode 300 - Near Death Experiences
14.3K1 -
1:15:47
Glenn Greenwald
13 hours agoCampus Crackdown on Protests, PLUS: Interview with Columbia Student Protesters | SYSTEM UPDATE #261
57.6K225 -
4:24:44
Crain and Company
12 hours ago2024 NFL Draft LIVESTREAM
27.5K1