Using T-SQL to find differences between tables
Abstract:
When you have to find differences and changes in your tables, there are many methods and tools to use.We'll cover a range of t-sql code, from basic to complex, and settings to find these differences and changes: Brute force - write it all out, Change Data Capture, T-sql Merge statement, And more.
Speakers:
-
Martin Perez
2 RecordingsMartin has progressed in his career just a DBA just starting out to Data Warehousing, Data Engineering, and now Data Architecting. He's pushed himself to get out of just working in SSMS and just SQL to use Python and Data Bricks and other tools. He will have an open discussion about some of his decisions, what's he's been focusing on, and methods he used, so you can follow along and also expand your own horizon.
Recorded At:
- Capitol Area Central Texas Users of SQL Server 87 Recordings
Recorded on:
Aug 15, 2017
More Info:
Tags:
- SQL Server 14 Recordings