Wednesday, December 31, 2008
I recently started reading Ron Jeffries Extreme Programming Adventures in C# (http://www.amazon.com/Extreme-Programming-Adventures-DV-Microsoft-Professional/dp/0735619492). Since quite a little more then a year I Agile Development Methodologies caught my eye. Recently I am starting to dig deeper in TDD and XP. In this series of posts I will let you follow me on my journey.
Monday, December 01, 2008
Simply upgrade your Visual Team System 2008 WITH team explorer installed to SP1
Saturday, October 04, 2008
The first one was the 2 Services (Microsoft Office Project Eventing Service and the Queue service) not starting this happens when the machine is not connected to the internet and tries to get some certificates from:
When you try to start them manually you get "Service did not respond in a timely fashion" and in the Eventlog you have: "Unexpected exception occured".
This can be solved by using this woirkaround:
Manually add the CRLs from the above Urls to the server manually (assumes
you've downloaded them locally first):
certutil -addstore CA CodeSignPCA.crl
certutil -addstore CA CodeSignPCA2.crl
Resolution Workaround (don't try this unless you've exhausted everything
We haven't tried this yet, but it is our hunch that if you cannot allow the
server access to the internet that it may be possible to fool .Net into using
locally hosted .crl files. This could only work if the restrictions that
prevent the service account and server reaching the internet still permit a
loop-back request to itself (calling web pages from the local server).
The way to do this is to add this to your HOSTS file on the servers:
or make sure you are connected to the internet for the easy solution :p
the other one was that jobs got stuck in the queue in "Waiting to be processed status". This I solved by running the service under the same credentials as the SSPService account.
that all for now folks :)
Monday, April 14, 2008
Spend some few days setting up a continous integration for a database project. Found some stuff on the internet but they got it all wrong :)
I am using Team Foundation Server 2008.
The only thing you need to do is modify the TFSBuild.proj
Modify the following sections. This enabled the automatic generation of a sql script that will be copied in the Drop Folder.
Find the SoltionToBuild tag and add the properties as shown below:
Add the default configuration to the ConfigurationToBuild ItemGroup as shown below (make sure to match it to your settings in the Configuration Manager)
The list of configurations to build. To add/delete configurations, edit this value. For example,
to add a new configuration, add the following lines:
The Include attribute value should be unique for each ConfigurationToBuild node.
<ConfigurationToBuild Include="ReleaseAny CPU">
<!--Include the configuration to build this generates a .sql file in the drop folder-->
Next add the following section to the end of the TFSBuild.proj file. the %3B is the escape character for ';' in MSBuild
<TargetConnection>Data Source=.%3BIntegrated Security=True%3BPooling=False</TargetConnection>
Targets="ReBuild;Deploy" /> <!—Need to specify the Rebuild target otherwise fails -->
If you modify your source folder setting in the workspace - defaults to $(SourceDir)- make sure that you override your SolutionRoot property
by adding the following
Thats all there is to it :)
Coming up automatically generate an upgrade script to deploy to production systems... I installed the Database Team Edition on the build agent but I am not quite sure if its necessary I will investigate this... I dont know if its default part of ms build
Wednesday, February 13, 2008
This guide proved to be very usefull: