Hier eine kurze Empfehlung nützlicher SQL Server Tools:
BIDS Helper
(http://www.codeplex.com/bidshelper)
A Visual Studio.Net add-ins with features that extend and enhance the functionality of the SQL Server 2005 BI Development Studio. (BIDS)
New features for SSAS, SSIS.
SQL Dependency Director
(http://www.codeplex.com/SQLDependency)
SQL Dependency Director helps you track Microsoft SQL Server Object Dependencies.
SQL Dependency Director will help you see where a certain objects such as a Stored Procedure or Table is used in various Stored Procedures, Views, Functions, Jobs and SSRS Reports.
It is also planned to add the ability to chart the objects and their dependencies in the graphical format.
ReportServer Explorer
(http://www.codeplex.com/RSSExplorer)
This windows application lets you manage a Microsoft Reporting Servicer server. It supports both SQL 2000,SQL 2005 and SQL 2008, even when running in SharePoint Integration mode.
DTLoggedExec
(http://www.codeplex.com/DTLoggedExec)
DTLoggedExec is a tool that allows you to run a Sql Server Integration Services (SSIS) Package producing a full and detailed logging informations of execution status and package runtime data.
SSIS Package Manager – PacMan
(http://www.codeplex.com/pacman)
PacMan – The SQL Server Integration Services Package Manager is a utility designed to permit batch operations on arbitrary sets of SSIS packages. Users can select a single package, a Visual Studio project or solution or a file system folder tree and then validate or update all selected packages in one operation.
Vulcan
(tba)
Vulcan is a Business Intelligence Framework built on top of Sql Server Integration Services and Sql Server Analysis Services for quickly creating BI solutions.
SQL Server 2005 Partition Management
(http://www.codeplex.com/sql2005partitionmgmt)
Sliding Window technique is commonly used with partitioned tables to manage large data volumes. It allows efficient loading of new data and archival or removal of the old data. The challenges in a sliding window scenario is to create the staging table(s) correctly for efficient partition SWITCH operations.
Microsoft SQL Server Metadata-Driven ETL Management Studio (MDDE)
(http://www.codeplex.com/SQLServerMDDEStudio)
Originally an internal MSIT solution that has been released as an open source project, the Microsoft SQL Server Metadata-Driven ETL Management Studio (a.k.a. MDDE) provides a tool for rapidly generating SQL Server Integration Services (SSIS) packages from a shared central metadata repository. MDDE is a software factory for SSIS packages that leverages the SSIS API to provide a templating engine that accelerates ETL development.
Wer eine freie und kostengünstige Alternative zu Microsoft Project sucht, kann mit 
