Blog ala Vidar

SQL, AppFrame and other cool technologies

Monthly Archives: September 2008

Music, Top 10

I’ve made a top 10 list of the best songs, in my mind. The rules are simple: It has to be lovable for everyone. That rules out rap/hippetihopp (of course 😉 and death metal..
I personally think that everyone should hear all of these, and I bet even Johnny (my boss) will like them. For the record, he only listens to country, and he’s a big Dolly Parton fan…

Best lyrics: Audioslave – Like a Stone
Chris Cornell, the singer in Audioslave said the following about this song: “It’s a song about concentrating on the afterlife you would hope for, rather than the normal monotheistic approach: You work really hard all your life to be a good person and a moral persona and fair and generous……And then you go to hell anyway”

Best intro: Dire Straits – Money for Nothing
You should listen to this on a REAL stereo. Put the volume to max, and enjoy the best intro in the world. The rest of the song is also pretty good.

Easiest guitar intro: Led Zeppelin – Stairway to Heaven
This is on top 100 guitar solos, and I know it on guitar! PS! The solo doesn’t start before about 6 minutes. I don’t know this one.. I only know the intro to the song 😛

Hardest solo: Lynyrd Skynyrd – Freebird
Anyone who’s tried playing this on their guitar knows that this is very impressive!

Best live song: Metallica – Master of Puppets
This one is the only one I’m not 100% sure you’d like. It’s the hardest on the list, but imagine you’re at a Metallica concert where 40000 people are all screaming: “MASTER! MASTER! … MASTER! MASTER! … LAUGHTER! LAUGHTER! … LAUGHTER! LAUGHTER!”. Very good song, drums and not to mention the guitar solos! Mmmm

Best song, EVER: Metallica – Outlaw Torn
The S&M version of this song is much better than the original. This is heavy, but an impressive piece of work! In my mind the best song produced, and it’s even played with a symphony orcestra! Adjust the volume to max, and play along on your air-drums. One day I might shoot a video of me playing air-drums to this song. I bet you couldn’t see the difference between me and Lars Ulrich! 😀 Don’t forget to pick up your air-guitar after 5 minutes!

Best guitar solo, EVER: Pink Floyd – Comfortably Numb
If you don’t agree, you don’t know shit about music 🙂 NB! Also best lightshow!

Deepest song: Slipknot – Vermillion pt 2
Slipknot is known as a metal band, but they do have (at least) two calm songs. This and one called Circle. Vermillion pt 2 is a very sad, and beautiful song. Listen to the lyrics.

Best known: The Eagles – Hotel California
This is a song that EVERYONE’s heard before. The guitar solo is best on the oldest version, but the song in it self is much better in the newer (live) version after they got together again.

Best A capella: Queen – Bohemian Rhapsody
You have heard this before, and you’ve probably song along with it. I know I have!


I’m so tired of being sick! I’ve had a kidney stone for almost a week. It hurts, and I’m bored to death! Btw, kidney stone’s are NOT recommended, so please drink MUCH water! Anyhow, just wanted you to know that I will be back in about one week (hopefully), and if I don’t answer your phone, MSN, mail or similar, it’s because of this stupid kidney-stuff..

Hot tips after installing SQL Server 2008 management studio

After you’ve installed 2008, there’s two issues annoying my shiny metal ass:
1.) Shortcuts doesn’t work properly. CTRL + N normally opens a new window, but not anymore! To fix this, go to Tools -> Options -> Environment -> Keyboard and click “Reset to Default”. Now it works 🙂 You should think that you get default when installing, but no…
2.) For (stupid) security reasons, management studio doesn’t allow you to do changes to a table that makes it rebuild the table. Since we always have PrimKey, Created, CreateBy etc at the end of the table, when you add a field it has to be before the PrimKey-field, and therefore you need to rebuild your table. To fix this issue, go to Tools -> Options -> Table and Database Designers and uncheck “Prevent saving changes that require table re-creation”.

Both issues is already reported to Microsoft. The first one was not intentional, but the second one was “by design”. I’ve voted that this should NOT be by design. Let’s hope they’ll listen to me this time!

Windows Home Server

First time I heard about Windows Home Server was from Øystein. He was praising it like it was a new god or something. Of course, I was sceptic. Microsoft making a server for home usage? That’s THAT easy to use? BULLSHIT, I thought! A couple of months later, I went to MSDN in Stavanger, where I got a 180 days trial of it (because I’m a member of NNUG ;). I thought I could at least try it out. That ended my sceptic thoughts. 3 clicks to install the server. Everything was setup by it self. Then, put a CD in all my computers (at that time, “only” three). One click on each, and the backup of them was setup. IS IT REALLY THAT EASY? you might think. It’s easier! It’s a wonderful product. I have admitted to Øystein that I was wrong.

The main thing about Home Server is to take backup of your computers. You can configure it to keep your backups as long as you want, so if your computer crashes for some weird reason, you can just put in a CD and it will restore to what every point in time you want it to. I haven’t tested this yet, but Øystein did have to do this. It worked perfectly. You don’t need to restore the whole computer. You can restore one file if you want!

Another cool thing is the “shared folders”. All computers in your network will get a shortcut on your desktop to your shared folder on the server. You can have private folders (for your user), or you can have shared folders. This makes it much easier to share files between computers at home. You’ll always have your photos, music and videos one click away, on all your computers. One bad thing about Home Server is that it doesn’t support RAID. I found out this when I was installing the real version (not trial) after 100 attempts. I had tried almost a whole weekend to install it on 3 different RAID-controllers, with different discs.. It installed ok, but when I booted it, it gave me bluescreen. I called Øystein and he said: “Try not using RAID” 😛 Why didn’t I think of that?! You might think that without RAID you don’t have a good server. Well, not exactly. You can easily right-click a folder (inside the home server management console) and click “Duplicate”. This will ensure that your folder is duplicated to more than one disk. One of my disks actually crashed a couple of hours ago. Luckily I’m using “duplicate” on all my important stuff, so I just unplugged the hard disk and the server is up and running again! When you plug in new hard disks you get two options. Add to share, or use for backup. If you add it to your share it will just extend the capacity of your share. If not, it will backup your important files, so you can unplug it and put it in a safe or similar. Very nice feature!

Conclusion: If you have several computers in your home, and do not have backup of anything, it’s a very good solution. It’s also very nice for sharing files between computers at home.

Knowledge week

This has been a VERY busy week. Started with publishing a new build of R3. I wish I had more time to test before it was published, but now everything should be fixed at least! Next time we’re planning a freeze two weeks before the build where we’re only going to test and fix bugs. Monday – Wednesday I was at work for a total of 40 hours, to make sure everything should go as planned on TechNet, NNUG, AppEd and with the upgrade of SQL3.

On Thursday we went to Stavanger. We were 12 people, some went to MSDN and some to TechNet. I went to TechNet, where the red thread was Microsoft Virtualization with mainly Hyper-V but also a bit about Virtual PC and Virtual Server. Virtualization is something we’ve already started using in Omega and we’re expanding weekly! Less physical servers means less hardware-failures, easier maintenance and of course reduced cost! We learned some tricks and tips about virtualization. We also met one of my heroes, Jon Jahren. We showed him our plan about hardware setup for the new SQL3, and got some tips about how to improve it. For example, we had planned to split up the MDF to several RAID-arrays. According to him, there were no point in this. He recommended putting the MDF on ONE RAID-array, using RAID 10. He also mentioned that tempdb should have it’s own array (as we already planned), and of course the LDF-file should have one. Making several MDF-files on the same RAID-array was good though. One pr CPU! Jon also had a “competition”. The person who asked him a question he couldn’t answer, got a SQL Server 2008 jacket. I asked him a question which he actually didn’t answer, but he apparently forgot about it or something, so he made a new competition. “Hvor mange indianere får en plass til i et hult tre?” ….. En stamme. “How many Indians can you fit into a hollow tree?” … “One tribe”.. Tribe in Norwegian (“stamme”) is the same word as for a tree-trunk. Leif was the first to answer correctly, so he got the jacket. And, yes. I’m REALLY jealous! I’m going to send Jon a mail about it!

After MSDN/TechNet we went to Ølensvåg to have a NNUG meeting. The topic was “C# 3.0 and .NET 3.5, news and best practices” with Jan Ove Halvorsen. It was a great session! We will upload his powerpoint to NNUG’s website. After that, Johnny had a zip-talk about CR3, and everyone seemed to be very impressed. There were people from Hatteland, Ecciti, Ølen Betong and Bouvet (and Omega of course) there.

On Thursday evening we went to “Løo”. This is a nice place to get to know people. We sat up till 2am, chatting!

AppEd started on Friday morning, with a keynote from Johnny and some guidelines. After that we had a “Tell us where it hurts” session, where we got some input about what, and how, we could do things better. We discussed documentation, builds, reporting issues and a couple of other things. I think it’s great to have sessions like this, where we can discuss and get to know problems that we might not be aware of. Torgeir continued with ReportingDX where I learned a couple of new things 🙂 Johnny had a little session about what we’ve made in PIMS R3.

After lunch, we split up in two where Arild had a (very interesting) session about SSIS and Johnny had one about AppFrame Security Model. After that there were two sessions going at the same time: CR3 Development and CR3 Hardcore. I participated at hardcore. I’m amazed by how much cool words Jan Leon, Peter and Torgeir knows. Serialization, delegates, proxy object, surrogate etc. I know some cool words in SQL Server, but not that many! In these sessions I started feeling sick. Not of the session, but there’s been some problems with the water in Ølen, and some has been sick (vomiting etc). I had to get home, so I couldn’t participate at “Løo” where they had dinner etc. We planned a quiz, where we were going to elect “Norgesmester i AppFrame”. Norwegian Champion in AppFrame. Of topic: You may have noticed I’m writing AppFrame, and not Appframe. This is the new way to write AppFrame.
ANYHOW! Arild Røksund won and got a T-shirt saying “AppFrame Developer Hero”, a mouse he can connect to a USB-port that cycles on a bicycle. The faster you type on your keyboard, the faster the mouse cycles. In addition he got the title “Norgesmester i AppFrame” and 50.000 advantage points. Semion Larin and Aleksander Birkeland got second and third place. They also got the t-shirt and cycling mouse.

I didn’t feel too good when I woke up, so I waited till after lunch to get to Ølen. Before that, they had hands on labs (to play with CR3), setting up R3 and R3 web. When I got to Ølen, me and Arild had a three hour session about Database Development. We went through new features in 2005 and 2008, Service Broker, Indexing and Statistics and Query Tuning. Håvard Ravatn showed me a thing I didn’t know about CROSS APPLY. I thought you could only use it for UDF’s, but no… You can also use it for queries 🙂

Because I was sick, and JanCB also was sick, we did not upgrade SQL3 this weekend. I’m still looking forward to get it up on SQL Server 2008. The plan now is after the salary payment is done.

I’ve already started planning AppEd 2009 😀 I hope you think the same as me, that it was a big success! I also hope we can expand it, so more people can attend!