Crazy, I was lightly worried Fri as I was traveling as well. No reported issues until we got to the airport (about 90 minutes before the flight) and got a...

I think the advice above is sound (sorry for the delay).

If you rewrite, I would look at a cloud based db, though mostly because of latency. If you stick close...

I tend to follow's Brian's methodology ^^

You haven't made this easy. The data you provided is in a text format for humans, not a format that makes it easy to load. We, or at least I,...

You don't seem to want to do work on your side. The data you provided isn't something I can easily run. It's just data.

I am happy to try and help,...

The job runs as a particular login. Change the login under which the job runs.

Hmmm, Jeff going. I'm going to have to see if I can make it.

I don't know of anything, as mapping data in a db and ensuring it's not missing something or removing something needed, is a complex problem.

Most people do this with simple...

Not sure. what I would suggest is you mock this up with data that helps debug what's happening and break apart the query. Likely this is data driven in some...

I assume your packages are stored in msdb, is that right? Are you sure you're accessing the right server from the jobs?

Without code or errors, it's hard to know.

I assume your packages are stored in msdb, is that right? Are you sure you're accessing the right server from the jobs?

Without code or errors, it's hard to know.

I think that's the direction most people are moving. Getting stuff from an OLTP database to Parquet is the challenging thing, but I think things like Synapse Link will become...

Finished S1 of Dark Matter recently. A wild ride.

Maybe it's  a footer in all blogs 😛

Watched a couple Season2  episodes last night after my wife fell asleep. So funny.