WinSCP for occasional editing of webpages + Pageant (part of Putty tools) to supply private key. But I got to write custom wrapper to make WinSCP launch native editor. Together that makes a usable combination. HeidiSQL and KeePass2 work without any significant glitches, I use them on daily basis.

+1 to e-mail server. My father receives scans of documents every day, and since his client is Thunderbird, from time to time the size of local mailbox was exceeded (2 to 4 Gb of mailbox file was too small). I set up HMailServer (Free, Windows-based) with remote IMAP for him. His Thunderbird deletes all local copies older than two months, and IMAP server is used to access the archives (the IMAP accounts in Thunderbird are set to not to download and store local e-mail). For more "cloud-like" solutions, web-based mail client can be used.