Sun after rain - steamy roof
May 17th, 2012Handy SQL
May 14th, 2012Created this SQL-statement used for one of our JIRA-instances. Needed to get rid of a lot of open sub-tasks where the parent task had been cancelled. The statement also shows usage of inner join and self-join.
Code:
U PDATE jiraissue ji1, jiraissue ji2 | |
INNER JOIN issuelink il | |
SET ji1.resolution = 9, ji1.issuestatus = 6 | |
WHERE ji1.resolution IS NULL | |
AND ji1.id = il.destination | |
AND ji1.issuestatus = 1 | |
AND il.source = ji2.id | |
AND ji2.resolution = 9; |
Todays view
May 14th, 2012Dive!!! "Stupe læll"
May 12th, 2012Crazy mothafucka if you ask me!!
Communal duty work
May 11th, 2012Askerrunden 2012
May 8th, 2012Last Sunday I participated in Askerrunden, 67 kilometers in...Asker...quite happy with the result all in all. 33 of 39 ain't no good, but the time was ok. Sick two weeks ago, so I was very happy that I was able to hang in there together with a few others. Was not able to help them as much as I wanted, but they helped me a lot...
Found this video, have to work harder next year so I can get a part in the movie as well :-)
Got a Nissan Micra you want to get rid of?
May 5th, 2012Have been watching all episodes of Team Bachstad, Mongol Rally 2011. Loved it! A natural follow up after having watched Long Way Round and Long Way Down.
You can participate this year as well...and need to use a...Nissan Micra....
To tackle the worst roads in the world you you need a chariot with an engine size of under 1 litre (ish). There is nothing like staring down the bonnet of a Nissan Micra at hundreds of miles of dirt track and foot-high rocks.
http://www.theadventurists.com/the-adventures/mongol-rally
Off course you can do it as a charity ride as well, like the Norwegian girls CookingCharityChicks are supposed to do
Also, a lot of clips to be found on Youtube
Mixed signals from Mother Earth
May 5th, 2012Introducing Simen for Fjellstadbakken
May 4th, 2012Simen and I out on Wednesday evening, introducing him for Fjellstabakken and the single track down to Skullerudstua, also known as the last part of Terrengsykkelrittet. The pictures are pretty bad, but have to use them since it is Simens first time on single track.







