SQL 2005 Virtual Labs

http://technet.microsoft.com/en-us/bb499681.aspx

Here is a list of SQL 2005 Virtual labs. It is easy to use and setup.

SQL Internals Viewer

SQL Internals Viewer is a free tool for looking at how the SQL Server Storage Engine structures, allocates, and organises data internally. It can be downloaded from www.sqlinternalsviewer.com.

Good read (and picture) of SQL 2005 Symmetric Encryption

http://www.sqlservercentral.com/columnists/mcoles/sql2005symmetricencryption.asp

Using Non-Standard Port for SQL Server

SQL Server 2005 Service Pack 2: Extending the Functionality of Your SQL Server 2005 System

Download SQL Server 2005 SP2

Download SQL Server 2005 Express Edition SP2

Download the Updated SQL Server 2005 Books Online
--> Well books online.

Download SQL Server 2005 Feature Pack (February 2007)
--> The Feature Pack is a collection of standalone install packages that provide additional value for SQL Server 2005. It includes: latest versions of redistributable components for SQL Server 2005, latest versions of add-on providers for SQL Server 2005, latest versions of backward compatibility components for SQL Server 2005

Download Updated Samples and Sample Databases
--> 100 over new samples for all SQL 2005 services (Database Engine, including administration, data access, Full-Text Search, Common Language Runtime (CLR) integration, Server Management Objects (SMO), Service Broker, XML, Analysis Services, Integration Services, Notification Services, Reporting Services, Replication

Download SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies ---> this download allows you to run complete reporting functions within a SharePoint site. No need for report center site that is provided by SRS 2005 installation.
http://blogs.msdn.com/sharepoint/archive/2007/02/19/microsoft-sql-server-2005-sp2-reporting-services-integration-with-wss-3-0-and-moss-2007.aspx


Download SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007
--> Provides Excel and Visio add-in for Data Mining and Table Analysis

SQL Server on VM

In case you are wondering about running production SQL Servers on a VM (VMWare or Microsoft's Virtual Server), here is a good blog post.
http://sqlblog.com/blogs/rick_heiges/archive/2007/02/16/sql-server-on-vm.aspx