The $to needs to be an array, so it should be something like [String[]] $to = @("address1", "address2".....)

Well how long does the proc actually take to run?  One thing to try would be to just take out the comparisons on the matched records, it might be faster...

My only suggestion would be that you might want more granular permissions than db_reader depending on what's in the databases he'll be using.

100MB and a million rows isn't all that big for a daily ETL process, using hadoop would be ridiculous.  What are more details about the job?  Is this supposed to...

Depending on the application it can be very common to find a problem that happened months ago and has been persisted in the data for a long time.  At some...

There are some tasks that can only be accomplished with cursors, for example loop through a result set and run a SP for every record in it.  Those are the...

It looks like they're all formatted differently, the reason is so that they can be pulled in that format without having to do it at run time.  As for why...