Michael K. Campbell has shared some useful SQL Server goodies that are available online, in his article in DevProConnections. I picked the ones I liked -
* Scripts - TechNet's Script Repository has a vast repository of scripts provided by Microsoft and by its users/customers that you can adapt for your own requirements.
* Books - Red Gate Software which sells some great developer tools also publishes books. Some of them are available for free download in PDF format -
- SQL Server Stumpers Vol.5
- Inside the SQL Server Query Optimizer
- SQL Server Execution Plans
- Mastering SQL Server Profiler
- SQL Server Statistics
- The Red Gate Guide to SQL Server Team-based Development
- Defensive Database Programming
- Confessions of an IT Manager
- SQL Server Tacklebox
- How to Become an Exceptional DBA
- The Art of XSD
- SQL Server Hardware
- The SysAdmin Handbook - The Best of Simple Talk
- Brad's Sure Guide to SQL Server Maintenance Plans
- Exchange 2010 - A Practical Approach
- Don't Just Roll the Dice
- Protecting SQL Server Data
- Book of Red Gate (about Red Gate, not SQL Server)
* Videos
Related:Free SQL Server Videos
HOW TO try Windows Azure & SQL Azure for free (without any credit card)