Posted on X and go this:

"Initial thoughts without any googleing, is that it could be a long process using a transaction that got deadlock killed mid-flight but not being caught...

I've been looking for a reference. The AIs say that you can't filter on an AD group, only users. That seems like a failing, but one I'm not surprised. I...

turning on encryption for the server? Likely there is, but not sure I've seen this documented. Most of the server side items require the MMC for SQL Server Configuration Manager...

It's not adult content. X.com is formerly twitter.

It's this page

You need to connect from the SSAS server to the source db, not from your SSMS local. That's where the connection issues are. Your SSMS is a client, which has...

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...