I see it rarely used. I'm sure someone does, but not many

I would lean towards what pietlinden said. separate the data movement from the formatting by querying it

I don't think so. I checked back through 2017, and this still happens.

I think most of us used cast/convert, and in those cases, it is 30.

February 14, 2024 at 10:40 pm

#4378824

I totally agree with you, Steve. Using Git is great.

Your article answers a question I've had about how DBAs may handle their SQL Scripts. I work for my state's...

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/