This might be a no-brainer for most of you, but I have to put it up here since I’ll have to run back to it from time to time.

Here is how to run “any” program as another user, without any installs or modifications:

1. Type cmd in the Run box of the Start menu.

2. Type the following command:

   runas /user:[domain]\[user] [program]
   

   Of course, exchange [domain], [user], and [program] to the things you’ll need. For example, to start Management Console as MARCUSADMIN:

   runas /user:MARCUSOFT\MARCUSADMIN mmc
   

3. Type the password of the user you want to run under.
4. Voila! You are running the program as the other user.

Another great finding in MSBuild for me recently is the use of the XMLMassUpdate task of MSBuild Community Tasks.

For quite some time now I have always kept a separate .config-file for each environment. Even though I always has gone “hmm… but wait a while here… 90% of this file hasn’t changed from the last environment…”.

But you don’t get the time to investigate always. But now, again after some thoughtful input by colleagues, I noticed the XMLMassUpdate.

With it you can easily keep a file with the changes for each environment and then let your build script generate the right version for the environment the script is building. This means that you only need to keep the differences (deltas I think it’s called in formal speak) of the different files. Great!

Here is an great article describing how to use the...

I’ve been generating documentation from our XML-comments with Sandcastle for quite some time now. It has worked alright but there were some stuff that really annoyed me, I thought that I had to put up with it. But this is the beauty of my line of work comes into play… all of a sudden we’ve got a new team member. Christer Cederborg from Avega (of course) - a great guy and very knowledgeable in things like build scripts and other. And you get to learn from each other. This is why I am in this business - sharing and knowing. OK - Christer told me that you can use something called a response file to send commands to Sandcastle. The response file is in fact just the parameters you would send to Sandcastle the command line, but in a file. This made us go around the use...

My questions in an earlier post were promptly answered by Mark A Williams in a great way.

So what he says pretty much confirms what I thought. Although associative arrays are a great way to “bulk in” data to the database, when it comes to returning data, the array-way might not always be right.

Since you have to allocate memory for the array and size of each element in the array, associative arrays are best suited for situations when you know the size of the data that is being returned. Not that often in my experience. In other cases, you’ll be better off with a plain old DataReader.

So now I know - thanks goes to Mark A Williams.

The Swedish guru of Scrum, Henrik Kniberg, has produced some great stuff… yet again. Here you are:

• Video and slides for “10 ways to screw up with Scrum and XP”. Got the merge-slide thrown in my face of a co-worker since I have great reluctance against branches… But I sure want to be able to manage them in a nice way - haven’t seen one yet though…
• Scrum checklist - here is a truly great one-page document to get all your stuff in the right shape before starting doing Scrum.
• And of course Scrum from the trenches. Everybody must read this! Even, or maybe especially, if you hate Scrum.

I have written about this before but I’ll make a short recap since it has to do with some quite interesting stuff in Oracle.

With ODP.NET you can harness the full power of Oracle’s features such as, for example, using Associative Arrays to bulk stuff into the database. We are using this feature in my current application since it will handle big loads.

OK - so far so good. I cannot understand two things and we have now involved the full brainpower of the team and still are scratching our heads. It actually boils down to two properties on the OracleParameter-class; Size and ArrayBindSize.

• The Size-property should be (in the case of using associative arrays) set to the number of elements in the array. The strange thing though is that the value of the property must be set for output-parameters. I mean - how...

Here is a cool site with MSBuild Recipes. I might post to it from now on. Sharing is knowing.

For some time now people has been turning to me at my customer for answerers regarding TFS Build. I have learned a great deal from that but sometimes I feel like I haven’t made sure that I understood the underlying thought from Microsoft.

One of those areas is that the TFSBuild.proj-file is not your ordinary MSBuild-file. Or rather; it’s is but is run by Team Foundation Server and you get to configure it and it’s properties. This is what I though and I was actually right. Phew!

There are some properties and targets that you can override in order to customize the build process. You can think of these targets like events being fired, and you can hook into them and customize their actions. And this is quite easy once you know how.

But then I often get the question; “Ok - what can I configure”. I haven’t...

OK - this might be the coolest “useless” application I’ve seen… but it alone made me want an iPhone. Badly.

And here:

The cool thing is that Apple has created such a great mobile computing platform. Telephony is just an application among others, such as the flute.

I am still waiting for the euphonium, of course…

The Swedish brass band movement has a new champion… The king is dead - long live the king!

Stockholm Brass Band is the new Swedish Brass band champions. And that’s a real chocker for most of us. WindCorp Brass Band has been leagues before Stockholm when I’ve heard them but somehow the managed to nick the title from WindCorp.

Don’t get me wrong - Stockholm is a great band with some truly amazing players (like Håkan Björkman for example). But WindCorp has loads of experience from many, many brass band competitions - something that there is not an abundance of in Stockholm.

My congratulations to Stockholm! Well deserved! And very impressive since the preparations has been surrounded with a lot sickness and problems to get a full band to rehearsals.