What kind of authentication does the source require?

Are you sure the service account has access to the directories?  You can try adding this to the end of the script to see if any errors are actually being...

The cold calls I get from recruiters when I'm not actively looking for a job are pretty much exclusively for contract work.  By that I mean recruiters who have someone...

Well two problems, first the triggers run every time statements are run against the tables regardless of how many rows are affected.  Second it doesn't look like either will handle...

Maybe in some extreme use cases you might get some benefit from separate physical SSD's but for most system compared to spinning drives it would probably never matter.

https://xkcd.com/1319/

That said I have seen manual processes that existed solely because noone thought to try to improve them, I've also deployed said automations and that straight up...

I think you'll need to actually compare the inserted and deleted data in the trigger if you want to capture actual changes.  the UPDATE() function in a trigger seems to...

Well if you already have a job pushing data from to the onsite server why wold pulling data back be any riskier?  Is the data you're pulling back more sensitive...