Here’s how we migrated our TFS 2008 to TFS 2010. This is not an in-place migration. What is generally recommended as upgrade path is to backup the TFS 2008 DBs, restore them in the new TFS data tier and then install TFS 2010. This will migrate all the projects at once. However, we wanted to keep the TFS 2008 environment running for a while, so this path did not do. We first set up a new machine (and a new domain, but that is a whole other story) with TFS 2010 and WSS 3.0. The database tier was on ......
Just to clarify the different tools that you can use to update/recreate the Team Foundation Server warehouse (relational database and OLAP cube). Warehouse Web Service You can browse and invoke it here (always locally from TFS): http://localhost:8080/Wareh... The Run operation will launch processing of the warehouse (you can check the status of the warehouse with the GetWarehouseStatus operation: it goes from ProcessingAdapters, ProcessingOlap and finally Idle). Processing ......
Here is a little script I find useful. It drops all tables, views and stored procedures in a database. exec sp_MSforeachtable 'DROP TABLE ? PRINT ''? dropped'' 'GO /* Drop all non-system stored procs */declare @name varchar(128)declare @SQL varchar(254) SELECT @name = (select top 1 name FROM sysobjects WHERE type = 'P' And category = 0 order by name)while @name is not nullbegin select @SQL = 'drop procedure [dbo].[' + rtrim(@name) +']'exec (@SQL) print 'Dropped :' + @name SELECT @name = (select top ......
I have spent quite some time latetly creating two SQL Server Reporting Services reports that read data from a Web services. Given that I had to solve a couple of non-trivial issues and that I did not find much documentation, I have written a few tips in this article. Tip 1: How to specify the value of the WS complex type parameter? Tip 3: How to pass another dataset as XML to the Web service? Tip 2: How to read XML from a database without truncation of the results? Technorati tags: SQL Server, SSRS, ......
I have spent quite some time latetly creating two SQL Server Reporting Services reports that read data from a Web services. Given that I had to solve a couple of non-trivial issues and that I did not find much documentation, here are a few tips. Tip 1: How to specify the value of the WS complex type parameter? My Web service received some XML as input and returned some other XML. To create the data source, just specify XML as type and the Web service URL as connection string. This is well documented ......
Most of my experience with job interviews has been as the interviewed but lately there were two occasions where I was the interviewer. Together with a colleague we had to check the technical knowledge of several people applying for a position not directly in our company but for which we have to provide the candidates. Our role was to test the person's knowledge on BizTalk and SQL Server (BizTalk being my subject). I realized several things: I totally empathize with the person and want them so much ......
I have been working on a POC with BTS2006 and data sources adapters (ODBC, DB2, SQL Server - I'll try to post about these later) for the past two weeks and encountered several problems. Nothing serious, but they caused me some pain. At one point I created a map in a transform shape with three source files. The idea being to create a sort of "merge" of the three documents. I selected the files, the mapper opened, I created the links between sources and destination and all was fine. Sources: Message1, ......