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.

Been a few years since I've done a multi-restore version upgrade, but there was a couple years where it happened often enough that I had a virtual box spun...

Been a few years since I've done a multi-restore version upgrade, but there was a couple years where it happened often enough that I had a virtual box spun...

I have been hunting for a pyramid diagram that represents the pace of change for the different layers of applications.

The fastest layer is at the top representing the user...

Can't you use Redgate SQL Backup to do restores that are no longer possible with native SQL backups? I think, I did this some years ago with SQL 2005...

Thanks, not sure what happened, but it is marked as SPAM now.

I'll keep an eye on this