Here is a good article on SQL Server 2005 Partitioned Tables and Indexes.

I have a common Virtual PC 2007 problem with dual monitors for my SQL VMs... when I most need to use my Virtual PC software, often the console goes insane when using a dual monitor, and though I can limp along by using Virtual PC from the system tray...

Though this article is a bit outdated, it is helpful in setting up the Terminal Services settings for a SQL Server VM: http://www.microsoft.com/technet/prodtechnol/win2kts/maintain/optimize/secw2kts.mspx

I have been having trouble installing SharePoint on the same Server as SQL 2005 due to port 80 conflicts. If you search on "SharePoint" in SQL BOL (Books On Line) there are some good links to configure both on the same machine. Here is some initial...

Here is a nice way to determine SQL Server Version Information aside from @@version: SELECT SERVERPROPERTY ( 'productversion' ), SERVERPROPERTY ( 'productlevel' ), SERVERPROPERTY ( 'edition' )

Here are the AdventureWorks Samples for SQL 2005 and 2008 . Here is a good pointer to the AdventureWorks Sample Databases overview for SQL 2005. I also found that there is a SqlRun_Tools.msi file under the setup disk ..\Tools\Setup that willl...

Here is a nice link about how to determine space consumed by a SQL Server database for each table by Nigel Rivett: and some other useful scripts :