Visual Studio for Database Professionals can not use variables in build

I was happy to find that Visual Studio for DB Professionals (SP1) allowed you to add variables for your database scripts on a configuration level.
Great! I thought I could generate SQL scripts for my entire database depending on it being a production or test target. How useful!
Well.. not really…
As try as I might, I could [...]

Run TFS Team Build with project from Team Edition for Database Professionals

I like Team Edition for Database Professionals… if you do ANY management of Sql Server databases then you should take a look and ask yourself if your life wouldn’t be easier to use it.
I then thought “Wouldn’t it be cool to build these database projects on TFS?”
Yeah.. it would, but it isn’t as simple as [...]

Hiding certain Team Builds for certain users

The good thing about MSDN Forums is that you get questions you may not otherwise ever think about, and by so doing you increase your knowledge about the subject.
One poster wanted to know how to ‘hide’ particular team builds from particular users, but allow them to execute other builds in the same Team Project in [...]

Adding SMTP alerts to TFS

I didn’t have the information about the email server before setting up TFS, but figured it would be easy to set up afterwards…. wrong
Well, actually it *is* easy, but just isn’t straightforward to find.
Find your TFS service web.config file.. on my machine it is here:
C:\Program Files\Microsoft Visual Studio 2005 Team Foundation Server\Web Services\Services\web.config
and [...]

MSI Build error with TFS Server & WiX

(This is a post migrated from Dotnetjunkies )
I found that my WiX 3.0 project was not building on my Team Foundation Server build machine.
For the benefit of search engines, the exact line was:
“light.exe(0,0): error LGHT0216: An unexpected Win32 exception with error code 0×659 occurred: This installation is forbidden by system policy. Contact your system administrator”
At [...]

Update TFS Reports

(This is a post migrated from Dotnetjunkies )
I made some changes to my Team Foundation Server builds, and wanted to check out the nice new reports.. only to see they havn’t been updated yet.
Kevin Castle has a good overview of this, explaining that the data warehouse does not update itself right away. There is a web [...]

Connect to Team Foundation Server with an IP Address

(This is a post migrated from Dotnetjunkies )
I have a virtual machine image of TFS in workgroup mode that I want to try out some project settings on before promoting to the production TFS server I have on the domain. However, it seems that attaching Visual Studio Team Explorer to this machine is not possible [...]

New blog about Team Foundation Server

I have been blogging for about 3 years at dotnetjunkies.com, and although it wasn’t very reliable the community seemed strong.
Well, now posts to Dotnetjunkies are far and few between, and I don’t have great confidence in its future.
Also, technically there are no great improvements to the site, and it is a little bit painful to [...]