Glad to hear it. That's the main point of these...

Is this an ADS pipeline? What is your IF condition? How is the source data structured?

I know you can. Hoping you do, but no hurry. Feel free to teach it how you think best. If you want two articles (one on Stuff, one on common...

No, it was in response to some post, but I can't remember which one. I think they got some code, probably from you, and didn't quite understand how STUFF() works.

Thanks, glad you like it

Yes.

If she does not have any other permission, nothing changes. If she does, nothign changes, other than cleaner permission set for auditors.

Great point. I ought to try and demo that as well and show where this is useful.

Hmm, that's scary. I've worried about secure strings, though I know there are some limitations on who can see them. Can others see this if they have access to the...

Thanks, I try

YW. I think Python is my favorite language.

Uniqueness isn't something you need for the clustered index. The choice of clustering key is usually something that is increasing and not often changing, like an id or date field...

You can, however, move the FQDN to a new IP. This doesn't necessarily mean a linkage to the SPN. I can have a CNAME or ALIAS for  connectivity and a...

I'm confused. You say 1 instance of SQL 2012, but mention VMs. Are there separate VMs for other things or is this related?

I agree with the above, but I also...

You can read about them here: https://www.sqlservercentral.com/steps/stairway-to-t-sql-beyond-the-basics-level-2-writing-subqueries

I don't think there is any setting for this. AFAIK, if you add column in the middle of the designer, this causes a table rebuild. If you add at the...