Тёмный

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

Microsoft Developer
Подписаться 545 тыс.
Просмотров 3,2 тыс.
50% 1

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:
learn.microsoft.com/en-us/sql...
Change Tracking Functions:
learn.microsoft.com/en-us/sql...
Data replication on Azure SQL Databases:
learn.microsoft.com/en-us/tra...
📌 Let's connect:
Twitter: Anna Hoffman, / analyticanna​​​
Twitter: Brian Spendolini, / btspendo
Twitter: AzureSQL, aka.ms/azuresqltw​​​
🔔 Subscribe to our channels for even more SQL tips:
Microsoft Azure SQL: aka.ms/msazuresqlyt
Microsoft SQL Server: aka.ms/mssqlserveryt
Microsoft Developer: aka.ms/microsoftdeveloperyt
#AzureSQL #AzureSQLDatabase #ChangeTracking

Наука

Опубликовано:

 

3 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 5   
@DB-sf1hy
@DB-sf1hy Год назад
Very good idea to also include topics about features that are not new.
@gaberice4365
@gaberice4365 8 месяцев назад
Thank you, good explanation and examples. I use it to track changes in my organisation where a third party data mart app provides incremental updates to one of our DBs.
@Astral100
@Astral100 Год назад
Thank you, that was very helpful. Finally allowed me to understand what I was doing wrong in following examples on Microsoft learning pages. (This damned 'ColumnId', which is a string constant, unlike the other parameters in the COLUMNPROPERTY, ugh...)
@Astral100
@Astral100 Год назад
Also it looks like there is a bug in Change tracking. Updating same row with several updates keeps the same (single) SYS_CHANGE_VERSION for all of the updates, even if you run updates separately! Which makes it impossible to trigger processing for only that one column that has just been updated.
@glennaitchison2527
@glennaitchison2527 Год назад
Wish they went through it slower
Далее
Introduction to SQL Server Change Tracking
49:19
Просмотров 18 тыс.
ELA NÃO ESPERAVA POR ISSO 🥶 ATTITUDE #shorts
00:20
Просмотров 725 тыс.
Schoolboy - Часть 2
00:12
Просмотров 1,8 млн
I'm Excited To see If Kelly Can Meet This Challenge!
00:16
SQL Database and Fabric - Better Together!
31:28
You Thought You Knew What Change Data Capture Is!
8:08
I've been using Redis wrong this whole time...
20:53
Просмотров 346 тыс.
Vector databases are so hot right now. WTF are they?
3:22
How I use SQL as a Data Analyst
15:30
Просмотров 815 тыс.
Azure Synapse Serverless vs Dedicated SQL Pool
10:25
Просмотров 24 тыс.
Tracking Data Changes in C# .NET
20:42
Просмотров 49 тыс.
КРУТОЙ ТЕЛЕФОН
0:16
Просмотров 6 млн