Hi Steve, I like the idea of using Git.  Where I work, it's all databases and we use file sharing.  We've experienced all of the example you gave as...

Re-skilling is always a concern, as is finding people with older skills.

A long-term stable team, can be good, but as noted, can be insular. They also might have  fallen behind...

Glad you liked it, Jeff. You've impressed and taught a lot of people and a few things came together recently that reminded me of you.

So thanks for all you do...

I did get someone at MS looking into this to see if there's a better way. I'll let you know if I hear something.

I'm guessing there's not good solution to...

Thanks, I've gotten a few, but not too often. I'll post ticket to IT

OK, LRS probably won't work out of MI, but you can use MI link to migrate to a VM and then LRS to migrate from the VM to a new...

Migrating a database from one server to another is what you're doing, so it's good to note that. Otherwise it's hard to understand.

If you are moving to a different tennant,...

It's likely some data issue. When you run manually, or from the agent, are you accessing the same data sources?

There should be logs as well you can examine.

https://www.sqlshack.com/overview-of-ssis-package-logging/

I assume by migrations, you mean SQL Scripts changing the schema/objects somehow.

There is no zero downtime, but you can fake it. First, make sure all migrations are backwards compatible with...

AFAIK, yes. You could use some sort of middle tier app server with connection pooling, which might get you more, but the low levels are low as they are stacked...

It's likely some data issue. When you run manually, or from the agent, are you accessing the same data sources?

There should be logs as well you can examine.

https://www.sqlshack.com/overview-of-ssis-package-logging/

AFAIK, yes. You could use some sort of middle tier app server with connection pooling, which might get you more, but the low levels are low as they are stacked...

Someone is having fun with AI tech

I tend to update SSMS fairly soon after the new version is announced. Same for the Red Gate add-ins.

For Visual Studio, I tend to wait quite a while because...

I'm glad you're optimistic. FWIW, have you submitted these to...