Introducing SQL Operations Studio
Note: This is content that I originally wrote for our upcoming book, SQL Server 2017 Administration Inside Out, that did...
2017-11-29
698 reads
Note: This is content that I originally wrote for our upcoming book, SQL Server 2017 Administration Inside Out, that did...
2017-11-29
698 reads
In the grand scheme of things, MySQL and SQL Server operate in different realms. It’s difficult to compare them because...
2017-11-22
341 reads
For the last five months or so, I have been helping some really smart people put words on paper, both...
2017-11-15
569 reads
Ewald Cress writes: Find a person or several people to pick on, and tell us a shareable story or two...
2017-11-14
322 reads
I love theatre. In six months I am putting on two one-act plays for a local festival, because I don’t...
2017-11-08
329 reads
I have a favourite new feature of SQL Server Management Studio 17.3 (SSMS), and that’s XE Profiler, which allows you to...
2017-11-01
491 reads
This is more for my benefit in the future, but hopefully it can help someone else too. We recently had...
2017-10-25
4,266 reads
Recently, I was asked to assist an organization with getting their data back for a SQL Server that had experienced...
2017-10-18
620 reads
In the #sqlhelp Slack channel on the SQL Server Community Slack workspace last month, Jemma Hooper asked: When trying to...
2017-10-11
456 reads
For a few years now, Microsoft has augmented its irregular release of Service Packs with a more frequent Cumulative Update...
2017-10-04
441 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