This is real good news. MSDN library which used to be subscriber only downloads are now free.

You can download MSDN Library May 2006 Edition @ http://www.microsoft.com/downloads/details.aspx?FamilyId=373930CB-A3D7-4EA5-B421-DD6818DC7C41&displaylang=en

Updated content sets in the May 2006 Edition include:

• Visual Studio 2005 Team Foundation Server
• SQL Server 2005
• Microsoft Knowledge Base
• Internet Information Server SDK
• Internet Security and Acceleration Server SDK
• And More...

Microsoft SQL Server 2005 Everywhere Edition CTP is the compact database for rapidly developing applications in both native and the managed environment that extend enterprise data management capabilities to desktop applications

Download

I found this wonderful tool info from ScottGu's recent post. I would have to say This Tool Rocks!. The main idea about SQL Prompt is it provides Intellisense style auto-completion for Microsoft SQL Server editors. It will tell you the exact formatting you should use for your SQL commands, while you are writing them and will therefore help you write fast, perfectly formatted SQL statements. SQL Prompt improves the productivity of all SQL script creation. SQL Prompt can be downloaded free until 1st September 2006 and we are providing forum support on the SQL Prompt support forum. A web help file is also available.

Download here