Yeah, I think a few of my code examples got absorbed. I'll correct them

Thank you for the sum up of the new "Operator".

I believe it's beneficial to have this operator available as an ANSI standard in SQL Server. This is especially true...

Worth mentioning: the CONCAT function implicitly converts all arguments to character data types, while the + operator always chooses the cheapest possible type conversion. This often results in errors...

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