I find AI provides me with 80% of what I need.  As a data engineer, this is fantastic.  I can't think of a programming aid that can boast the...

Lol, I usually need a couple of guiding hands to ensure juniors stay on task. However, they also help me get work done without me having to do all the...

I see the backslashes and test reply

I had someone say to check the advanced tab in SSIS

https://x.com/fv439/status/2001016477722562647?s=20

Backing up will almost certainly preserve corruption, but ensuring you have a backup is critical. l'd certainly make an extra one before I start doing anything. Never know when someone...

I'd echo what Brian wrote. Work with VEEM on this

Anytime someone makes a "never do this", I'm skeptical. First, never is a long time, second, they often don't really have a rational reason.

AI isn't magical now, and it can...

The error looks like a firewall thing to me. Can't establish a connection.

I might connect to the source SQL Server and verify the source db is accessible. Meaning that TDE...

Not entirely sure, but I do know there is a proc that you can run, which might do what the auto cleanup is missing: sp_flush_CT_internal_table_on_demand

I might run that and...

No company can afford a highly skilled coder to go around refactoring their code base and shouldn't use an inexperienced coder for the task.  When does it make sense...

I am currently in the midst of a refactoring project primarilly intended to "quiet" the log files.  Non-catestrophic errors and warnings are polluting the log files causing unacceptable growth.

One...

I tend to adopt Aaron's view a lot. I am refactoring my code and trying to make it better, but also help me clean things up that are an investment...

You can ask the AI what they did. I asked to restore a single table. Got "RESTORE FROM DISK WITH SINGLE_TABLE". Told it didn't exist but I could have pasted...

This apply?

https://support.microsoft.com/hu-hu/topic/kb4538365-fix-change-tracking-cleanup-does-not-work-when-invalid-cleanup-and-hardened-cleanup-version-are-negative-in-sql-server-2017-and-2019-f186bd92-622c-89f2-a6c2-739c250593f2

Expired records should be those that are in the tables, but should be deleted. Are you saying based on settings there aren't any records in the on-disk table...

Jason,

ask yourself this. Is the vibe coding any different from blindly approving a PR from a colleague? Or having to support someone else's code who you know takes shortcuts?

Those lawyers...