You can create a VPN connection through a batch file. At this website you can see how to do that: http://www.aeonity.com/frost/howto-windows-xp-vpn-into-remote-location

From the batch file you can use the SQLCMD command to execute other queries. Through scheduled tasks you can execut the batch file at a certain time or multiple times.