Some of my favorites...
ConnectionStrings.com - The place to find any connection string you will ever need.
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.
JumpstartTV.com has hundreds of short, targeted videos on a wide variety of SQL Server topics
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.
Conference Publications
SSIS Scripting - Notes from my presentation at SQL Saturday Baton Rouge (08/01/2009)
SSIS - Beyond the Basics - Notes from my presentation at SQL Saturday Baton Rouge (08/01/2009)
SSIS Scripting - Notes from my presentation at the North Texas SQL Server User Group (06/18/2009)
Unconventional ETL Using SSIS Scripting - Notes from my presentation at SQL Saturday Pensacola (06/06/2009)
Unconventional ETL Using SSIS Scripting - Notes from my presentation at SQL Saturday Tampa (01/24/2009)
SMO Programming - Notes from my presentation at SQL Saturday in Jacksonville (5/3/2008)