SQL Data Compare (SDC) is a great way to sync data among tables. It’s a software utility analogous to SQL Compare, but working with data rather than schema. I...
2023-02-17 (first published: 2023-01-25)
730 reads
Today’s coping tip is to focus on being kind rather than being right. This is one of the things that grows my wisdom over time. I don’t need to...
2023-02-16
12 reads
Does Context Info work across databases? This post shows it does. Another post for me that is simple and hopefully serves as an example for people trying to get...
2023-02-15 (first published: 2023-02-01)
203 reads
Today’s coping tip is to look for good in others, particularly when you feel frustrated. We all deal with conflicts with others throughout out lives. How we handle those...
2023-02-15
12 reads
2023-02-15
363 reads
Basecamp is leaving the cloud and Steve thinks it's a good decision. He also thinks the cloud can work very well for organizations.
2023-02-15
184 reads
Today’s coping tip is to thank someone and tell them how they made a difference for you. I’ve had a lot of success in my life, as well as...
2023-02-14
4 reads
Today’s coping tip is to show an active interest by asking questions when talking to others. I listen more and more these days. I’m trying to input less and...
2023-02-13
7 reads
2023-02-13
459 reads
I saw this tweet recently, where Richie Rump asked what has changed in T-SQL since the SQL Server 2012 version. A few people from Microsoft responded that there were changes in all versions, and while I think some versions have few changes, I decided to look. SQL Server 2012 introduced the window functions with the […]
2023-02-13
354 reads
By gbargsley
Hello, reader! Today, I’m going to walk you through a scenario that many DBAs...
By Chris Yates
The Castle and the Keys Imagine your Azure SQL environment as a sprawling digital...
By Steve Jones
I think we might have forgotten this a bit, but on one of the...
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