I recently encountered an interesting issue with ADF where the publish feature suddenly attempted to republish every single object, claiming they were new, despite having incrementally published changed objects...
2025-07-02 (first published: 2025-06-15)
180 reads
The PASS Summit goes on tour this year, with an August stop in New York City. This is the first event in the series, and I’m excited to go...
2025-07-02
6 reads
Useful tips to make your jobs more stable Too many IT teams treat SQL Server Agent jobs like a coffee timer “Set it and forget it!” Unfortunately, that mindset...
2025-07-02 (first published: 2025-06-11)
537 reads
A Goldmine of Clues You Might Be Ignoring SQL Server’s Error Logs often get overlooked, until something breaks. But if you know how to use them, they can tell...
2025-07-02
67 reads
AI is deemed to be the new superpower. Adoption of AI in various capacities is at 72% across industries, world wide, according to one study, and it does not...
2025-07-01
9 reads
(2025-June-30) Working with different abbreviations or acronyms can speed up communication, but at the same time, it can exclude those who are not familiar with them. Sometimes this exclusion happens...
2025-07-01 (first published: 2025-06-30)
77 reads
Hello Hello, We. Are. Back! The schedule for EightKB 2025 Edition has been announced! We’re kicking off at 1pm UTC on August 21st…here’s the schedule: – N.B. – If...
2025-06-30
23 reads
(2025-June-15) Long gone are the days when a data engineer could simply focus on building a new data integration solution. You’d establish connections to one or more source datasets, review...
2025-06-30 (first published: 2025-06-16)
316 reads
The more I look to GenAI to save me minutes, short periods of time, the better it works. Here’s an example of something I do regularly where AI helps....
2025-06-30
176 reads
Joe Fleming wants to know how I solve weird problems. I’m not sure I’m actually qualified to answer this question since I, myself, am a weird problem, but I’ll...
2025-06-30 (first published: 2025-06-10)
330 reads
By Steve Jones
It’s time for T-SQL Tuesday again and this time Todd Kleinhans has a great...
By Steve Jones
Recently I was working in VS Code and I saw a walkthrough for the...
By alevyinroc
In the blink of an eye, summer has passed. I don’t know about you,...
I am trying to check out elastic query between two test instances we have...
Comments posted to this topic are about the item Change Tracking Data Retention Options
Comments posted to this topic are about the item Requiring Technical Debt Payments
If I am running this code:
ALTER DATABASE AdventureWorks2017 SET CHANGE_TRACKING = ON (CHANGE_RETENTION=4 xxx);What are the possible choices for xxx? See possible answers