Escape from boredom

rblog

Current Blog

rblog

rblog

Something about music

Music

“They Shoot Music”, pretty cool http://theyshootmusic.at/semi-acoustic-video-sessions/ Discovered the webpage while searching for Kaizers Orchestra

[video:youtube:6A8aTSy6T2Q]

And then, this 30 minutes movie about Den Svenske Björnstammen, really do enjoy them!

Nordmarka Rundt – a very nice ride

Sport

On Sunday I participated in Nordmarka Rundt, almost 150km from Årvoll via Sollihøgda, Jevnaker, Nittedal and back to Årvoll. Did the race together with my friend Bendik, and the combination of quality time with good a friend and hours on the bike in nice weather is just super!

Quite happy with race as well, we did not race full speed all the time, but did many kilometers together with Rye Lill40 and later with Lørenskog CK confirming that I’m prepared for Trans Germany in two weeks. Off course, I could always be even more prepared, but…good enough. Ended up with the time 4:19. Then when finished we enjoyed the baguette and coca cola handed to the racers, and then when at home Elin had made cinnamon buns finishing up a very good day just perfectly.

Handy SQL

Work/Geek

Created 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.

 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;

Hjem