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

I suspect SQL Server 2016 runs better than 2005.

It's always an "it depends" discussion. Some things run for years, and there's no reason to change. Some things do need to...

Ah, I realized I had an extension added. I'll update the article with this.

Likely you added the sp_whoisactive extension

Good Stuff.  There were a couple of the queries that didn't run against my Synapse instance.  "can't convert to int".  I had to cast some of the columns to...

Hi Steve, very useful posts around ADS, however, when I fire my ADS for a 2k16 SQL, in the monitoring part I have no "Server Reports" nor tempdb as...

These things made a big difference in my career before SQL Server Central. Answering questions elsewhere, doing a talk at a UG, they helped me stand out as well. You...