Textpad has to be my number one tool, although I am willing to migrate to a newer text-editor. It just is easy for me to search/replace thru many folders/drivers, regular expressions, macro programming.
Compare-It, is a file comparing tool. Let's say you have a code on development server and code on production, and you need to see what's different. Or I have also used it to compare stored procedures, after saving them as text files. Just a very nice file comparer.
I recentally got the Multi-IE Package, that installs multiple versions of IE on your pc, each in it's own folders.
For database querying, I use a great query tool called Advanced Query Tool, I like it because it makes it easier to design, visualize queries, test them, on each database server you have.
I have been playing with this SQL Server Monitoring Tool, called SQL Stripes, which is a freeware/shareware
that provides a powerful console for managing multiple servers running Microsoft SQL Server ™
I also love this trial version of Toad for SQL Server, it has a very powerful, sql tuning component. Basically, you give it a query that you think could be re-written for better performance, and it will try re-writing that query many times, until it has the sql query version, that provides the best solution. I can't yet afford this tool, but it is a very wonderful tool for improving performance of your sql queries.
For FTPing, I use FileZilla, it just is a very easy to use, and open source costs, make it a very nice and powerful ftp client.
There are a lot of nice tools out there, what are your favorites?