Some of my favorite sites...
SqlServerCentral.com - The best, most helpful community website for Microsoft SQL Server information.
SQLIS.com has lots of good SSIS and DTS tips and how-tos.
SQLShare.com has hundreds of short, targeted videos on a wide variety of SQL Server topics
ConnectionStrings.com - The place to find any connection string you will ever need.
Utilities
Here's a listing of a ton of free SQL Server utilities. Enjoy!
CoreFTP Mini SFTP Server - great zero-config mini server for testing SFTP processes
PuTTY and PSFTP - client tools for securely connecting to SSH and SFTP servers.
Notepad++ is Windows Notepad on steriods. 'Nuff said.
SSIS Tools
Konesans.com produces a great Trash Destination and Data Generator for SSIS, among other tools
BIDS Helper is a Visual Studio add-in with some nice features for SSIS.