Try making the database trustworthy first:

ALTER DATABASE <DBName> SET TRUSTWORTHY ON

I had to do this when creating a CLR procedure that accessed the file system, and so then also had...

Great article.

It is also worth noting that once an assembly is loaded in to SQL Server, the actual DLL file is no longer used because loading an assembly really does...

7-Zip is my compression tool of choice and also has GUI and CLI versions. Also supports AES encryption and the native 7z format offers the best compression I have seen....

I copy SQL Server backups over the Internet. I have two remote servers connected using a (paid for) LogMeIn Hamachi2 Peer-to-Peer VPN. I then transfer the files over...