Deploying SQL Server Reporting Services or Analysis Services on a Remote Server in TFS2008

In TFS 2005 the SQL Server Reporting Services (SSRS) had to be on the Application Tier and SQL Server Analysis Services (SSAS) had to be on the Data Tier.  With TFS 2008 you can deploy these on remote servers.  This is documented in the TFS Installation Guide in the section titled: “How to: Customize Deployment…


Nice site for SQL tips

An old friend of mine has started a site called Computation Press at Which has some good papers on SQL tuning tips.