Upgrades, running out of disk-space, admins gone rogue…there are many things that can disrupt your Team Foundation Server’s reporting databases.
Luckily, there is a fairly quick and easy way to re-install the TFS SSRS reports and rebuild the Tfs_Warehouse and Tfs_Analysis databases. As all items are boilerplate reports and generated databases.
To do this, we will work with the following components on TFS 2015 and SQL Server 2012 R2:
· TFS 2015 SSRS Report Manager: http://Your_TFS_Machine_Name/Reports
· Tfs_Warehouse: SQL Server Database
· Tfs_Analsis: SQL Server Analysis Services Database
Did You Know that you can capture results from a Stored Procedure into a Table variable?
-- Save Time Range in central stored procedure
DECLARE @Result TABLE (ID INT)
InsertInto @Result Exec [Entity].[TimeRangeSave]@BeginDate, @EndDate, @ActivityID
Select @TimeRangeID = ID From @Result
This article describes the process of developing the entire Data Tier in Visual Studio SQL Server Data tools (SSDT.)
Many Software Development Life Cycle (SDLC) processes use hand-coded SQL publish scripts when making changes to the data tier. This process is error prone, and is not able to be versioned as easily as C# code projects. SSDT is a technology that brings the data tier in-line with C# projects, and both can be developed, versioned and released in the same manner.
This article describes how to upload your Visual Studio developed SQL Server Report Services (SSRS) RDL file from your local machine to a SSRS server. This procedure was developed for Visual Studio 2015 and SQL Server 2014, but also works with versions as old as 2010/2012.