Today we have released VS 2008 and TFS 2008 SP1 to Web. You can download them from

Server: (Targeting Team Foundation Server 2008 Application Tier, Team Build and Proxy)

http://www.microsoft.com/downloads/details.aspx?FamilyId=9E40A5B6-DA41-43A2-A06D-3CEE196BFE3D&displaylang=en

Client: (Targeting Team Foundation Client 2008 and VS editions)

http://www.microsoft.com/downloads/details.aspx?FamilyId=FBEE1648-7106-44A7-9649-6D9F6D58056E&displaylang=en

One of the main Features that our Team worked on is the Support for SQL Server 2008. In order to use Team Foundation Server with SQL Server 2008 you have two paths

1. Fresh installation of Team Foundation Server 2008 SP1 using integrated install method. I have covered the steps needed in a previous post http://blogs.msdn.com/aabdou/archive/2008/05/13/team-foundation-server-sp1-beta-now-available.aspx
2. Upgrading an existing TFS Server 2008 Instance to use SQL Server 2008. In order to do so there are two different approach depending on when you apply SP1:
   1. If SP1 has been already applied to the Server you need to
      1. Backup your Databases
      2. Perform SQL Upgrade from 2005 to 2008 from the SQL Server 2008 Media (Note that TFS will not be functional during this period and until the next Step Completes Successfully)
      3. Run TFS 2008 Repair from Add/Remove Program.
   2. If SP1 has not been applied to the Server then you need to
      1. Backup your Databases
      2. Perform SQL Upgrade from 2005 to 2008 from the SQL Server 2008 Media (Note that TFS will not be functional during this period and until the next Step Completes Successfully)
      3. Install TFS 2008 SP1 patch.