tubeshowcase●1,661,197 videos♡ My collection 0
← Learn to Code

Learn to Code14:52

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

Microsoft Developer ↗

From the creator

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. 0:00 Introduction 1:36 What is change tracking in Azure SQL Database 3:57 Why use change tracking 4:44 How and where can I use change tracking 5:58 How and why can I use change tracking 7:18 Demo 13:28 Getting started ✔️ Resources: About Change Tracking: https://learn.microsoft.com/en-us/sql/relational-databases/track-changes/about-change-tracking-sql-server Change Tracking Functions: https://learn.microsoft.com/en-us/sql/relational-databases/system-functions/change-tracking-functions-transact-sql Data replication on Azure SQL Databases: https://learn.microsoft.com/en-us/training/modules/azure-sql-replication/?branch=main 📌 Let's connect: Twitter: Anna Hoffman, https://twitter.com/AnalyticAnna​​​ Twitter: Brian Spendolini, https://twitter.com/btspendo Twitter: AzureSQL, https://aka.ms/azuresqltw​​​ 🔔 Subscribe to our channels for even more SQL tips: Microsoft Azure SQL: https://aka.ms/ms

Published 2023-04-20 · Watch on YouTube ↗
Availability and playback restrictions are controlled by the original channel.

Keep exploring Learn to Code