Be careful with table updates
The dire warning in the subject line is not meant to scare you. Rather, it is advice that is going to be useful to those of us who need...
2021-12-01
132 reads
The dire warning in the subject line is not meant to scare you. Rather, it is advice that is going to be useful to those of us who need...
2021-12-01
132 reads
This is one of those shameless plugs I’m allowed to do from time to time to promote my user group here in Calgary. Tonight, starting 5pm Mountain time, Bob...
2021-11-24
11 reads
There’s a lot going on in the world today. It feels like there’s too much for us to think about. Speaking for myself, I’m worried about the environment first...
2021-11-17
11 reads
A customer I’ve been working with for a while now has a monolithic ASP.NET MVC web application which we are porting to .NET Core 3.1 (and then almost immediately...
2021-11-10
1,256 reads
SQL Server 2022 was announced yesterday at Microsoft Ignite, and it’s going to be a big one. Building on a lot of work in the Azure SQL space, SQL...
2021-11-03
96 reads
After writing several posts about a neat feature in Azure SQL called system-versioned ledger tables, it reminded me about something I’ve wanted to say for a number of years...
2021-10-27
24 reads
2021 has been the year people want to learn about Temporal Tables, it seems. Not only am I speaking at the SQL Trail conference next week, but I was...
2021-10-20
45 reads
This is the third post in the series about system-versioned ledger tables, a new feature introduced in Azure SQL Database. You can read Part 1 and Part 2 if...
2021-10-13
21 reads
I’ve had the privilege of presenting all over the world about temporal tables in SQL Server including the United Kingdom, Canada, and the United States. The theme of the...
2021-10-06
20 reads
In the first post of this series, we learned about a new type of system-versioned table that also works at the database level and introduces a mechanism that demonstrates...
2021-09-29
54 reads
By Steve Jones
I think we might have forgotten this a bit, but on one of the...
By Brian Kelley
I refresh my test SQL Servers at least monthly with a fresh VM. Setting...
By Chris Yates
Embracing Total Responsibility In every organization there comes a moment when teams must choose...
We are using MySQL version 5.6 in our Windows Server 2012 R2 environment. We...
We have created a parent table, child table & Audit log table in SQL...
Comments posted to this topic are about the item Change Tracking Default Retention
I run this command on my SQL Server 2022 database:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON;What is the default data retention period? See possible answers