Many of us have worked in environments that have a number of SQL Server instances. Different versions, editions, and mostly different hardware profiles. We deal with different applications and software that places different demands and requirements on our database systems. Some of us are even dealing with multiple datastores, trying to integrate SQL Server with […]
2020-06-09
193 reads
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-06-08
8 reads
I've worked in a a couple very high performing organizations that adapted to changing conditions and built software well. I've worked in more poorly performing organizations that struggled to release updates and patches, causing tremendous stress for the IT staff. DevOps is designed to help improve our software delivery and quality, if you work on […]
2020-06-08
105 reads
2020-06-08
512 reads
I got a dataset file the other day with an .rds extension. I had never seen this, but with a quick Google, I figured out this was a dataset...
2020-06-08
88 reads
Tl;Dr – This is about changing your main branch in git to main. However, please read and think about what I am saying here. When I started working with...
2020-06-08
33 reads
Let the data drive your decisions. This has been something of a mantra for many technical people, and even many business people, across the last twenty or so years. The allure of business intelligence is harnessing lots of data to make decisions that are rooted in some rational analysis of what has happened. Many companies […]
2020-06-06
77 reads
As part of the Community Circle effort at Redgate, we’ve released a cookbook: A Byte of Redgate. You can read about the story in this blog, and it was...
2020-06-05 (first published: 2020-05-25)
229 reads
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-06-05
9 reads
2020-06-05
575 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