I delivered a presentation for the Houston SQL Server User Group tonight, virtually from Colorado. I’d love to go down, but couldn’t do it today. The slides for the...
2023-05-25
16 reads
I’m going to attend the Denver Dev Days 2023 in June. I submitted a few sessions and got two picked. I’ll be doing these talks: Blogging for the Tech...
2023-05-25
4 reads
Setting up a local web server was something that I haven’t done in a long time and this was really easy. This post shows how to do this with...
2023-05-24
155 reads
2023-05-24
427 reads
Today Steve discusses visualizations and how we would think about the information a client gets from them.
2023-05-24
190 reads
I had a question on multiple backups in a file and had to check my syntax. This post shows how to see which backups are in a file. Note:...
2023-05-24 (first published: 2023-05-10)
133 reads
Today Steve talks APIs, which are important in much of software development. He thinks we ought to treat our database schema as part of an API.
2023-05-22
277 reads
2023-05-22
400 reads
trumspringa – n. the longing to wander off your career path in pursuit of a simple life, which is just the kind of hypnotic diversion that allows your thoughts...
2023-05-19
126 reads
2023-05-19
529 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 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 am trying to create a subscription that posts to a one drive directory. ...
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