Episode

Don't let change pass you by! Get started with Change Tracking in your SQL Database | Data Exposed

with Anna Hoffman, Brian Spendolini

Many database administrators ask questions like "What rows have changed for a table?" and "How has that row changed in that table?". Change Tracking is a lightweight solution built right into the SQL Database that gives you the ability to query for data that has changed over time. In this episode of Data Exposed, join Anna Hoffman and Brian Spendolini as we explore this powerful feature of the database. Learn how to enable Change Tracking in your database, what are the best uses cases, and how it can save you massive amounts of time and effort over developing custom, one off solutions.

Chapters

  • 00:00 - Introduction
  • 01:36 - What is change tracking in Azure SQL Database
  • 03:57 - Why use change tracking
  • 04:44 - How and where can I use change tracking
  • 05:58 - How and why can I use change tracking
  • 07:18 - Demo
  • 13:28 - Getting started

Azure SQL Database
Azure SQL Managed Instance
SQL Server
SQL
Transact-SQL