I love and hate patches. I've started to "defer" a whole series of them (VSCode, Redgate, etc.) to see if anyone reports instability since I think the DevOps thing is...

Sounds like you have a good plan, Neil, and I hope it goes well. I know the job market has been tough for a lot of people. I'd also suggest...

so it's working? Your message isn't clear.

One quick note, no reason not to have older certificates on the QA (or other server) until you're sure you won't ever restore an older backup. So don't delete those...

I've seen this, and it can be OK, or not. I think when I've seen it there is still a need to have each node very close in both resource...

That's one of those things that's annoying about ADF, it adds a higher for setup/use, which isn't always needed. We need a Local, simple ADF or SSIS.

Apologies. I should have mentioned the versions. This is in SQL Server 2025 and Fabric. Awarded back points.

• This reply was modified 1 months, 2 weeks ago by Steve Jones - SSC Editor.

Well that's weird. I see it in the editor.

Changing the formatting to get it to show up and awarding back points.

Still people using the same file over and over, sometimes with INIt, sometimes not, I would agree that it's not a good idea, but often it's because is not knowing...

AI gives a few suggestions. If you have the DDL and some sample data, could play around with a few options. I assume this is SQL 2022?

Haven't seen an update from Frank, so I edited the article to change each to easy.

Code edited

One thing you might consider if this is really needed is to create a new db of the right size and move data across. You'll need to do this in...

Agreed....

I've moved into the "doubtful" camp on AI becoming capable of "big successes" on its own.  It is a great junior developer and saves time on tasks, especially those...