WorldTicketShop

Tiesto is back in Copenhagen again!
This guy is amazing and his concerts are always awesome!

So, while I was Binging him, I found the WorldTicketShop website.
Immediately I remembered that I have been there before, when I was checking for tickets for a concert at another country and I remembered that they are EXTREMELY overpriced! Almost doubled priced!! So, I wanted to test again and see if they overcharge for Tiesto's concert in Copenhagen..

The official ticket-selling website for this concert is BilletNet and their price is ~63€.

The price at WorldTicketShop is 179€!

* Both prices include tax, but not shipping..

Friendly advice: AVOID WorldTicketShop..

Restart after install/update on Mac

This an informational post for all the windows users out there.

Well, I am also working on windows and I was tired of listening to all mac users bragging about many things..
One of those things, is that on Mac you don't have to restart after installing applications.. That's also the case for Mac-updates..
More precisely, a mac-friend of mine, told me that I can forget the "restart" functionallity on Mac, cause you never do it!

All this, sounds nice, until you get a mac and you realize the truth..

Of course you have to RESTART your MAC!!

When you are getting the latest updates, you have applications that require restart!
I was shocked when I saw the message, but, well, that's the case.


Oh, and the worst part is that
you DON'T have the option to select "Don't install and NEVER bother me again"!!
You will get those updates in your update list, until eventually one day you are so pissed, that you install them..

For example, I am not using the wireless on my desktop computer, but I cannot avoid installing the update.

Welcome to Mac World..

Hello world!

That's my first post from my new iMac!
I already feel more cool :-)
Finally, I got a new and decent computer!!

I was thinking to try to keep this blog alive, by posting my iMac experiences once in a while..

To start with,
* The 27'' screen is AMAZING!
* The mouse is so cool!
* The remote control is even more cool!
* And of course it's fast (even though for the same money maybe you can get something faster)

I am closing this post only with the positive observations, but I have quite a few negative as well..

Does Firefox suck?

I am(was actually) a great fan of Firefox..
From a user's perspective Firefox rocks!
* there are countless add-ons
* it's faster than IE
* it's competing IE (and no one likes Microsoft)
* it had tabs before IE
* it's customizable

But, from a software developer's perspective, Firefox sucks!
* there are much lesser events that IE!
for example, OnPropertyChange, which is triggered as soon as the element is being changed (and not after the change). Lovely event, missing from Firefox.
* there are some events that are partially supported!!
for example, OnKeyPress is supported for input fields, but NOT for tables. According to some people, it's not usable since it's not editable.. However, when you are creating a table that uses navigation arrows, you need this feature to capture the arrow keystrokes.

It seems that Firefox is trying to limit the freedom of the developer either because it will make Firefox slower or because they have decided that some functionality shouldn't be available to developers...

Of course there are solutions, but they are workarounds that shouldn't be needed..

So, bottom line, we should all praise Microsoft! :)

Skiing period has started!!

I want to make clear that I am still a beginner in snowboarding..



Tomorrow I am going snowboarding again and I hope I can shot a better video :)
(where I will hopefully go faster!)

by the way, I am not spending my free time on programming anymore, but on socializing.. however, I guess that I will get back to ruby and java soon..

History is rewritten!

Ha, you thought that the famous quote
"I have not failed. I've just found 10,000 ways that won't work"
is from Thomas Edison????

No no no no!
According to OffRadio, it was Albert Einstein who said it!!!

Off-radio is a great internet radio station from Greece.
So, I think they should stick to playing perfect music...
And if someone is not sure about something, he should ask!
Or do some research :)

Anyways, I hope that soon I will have my first working example of Ruby On Rails system!! It's coming really really slowly, because I have been through major changes in my life!! Such as, following danish lessons :)

Status Update

I just saw my last post and I realized that the two solutions that I had found to keep me occupied and away from my problems, were not very effective..

1. I played World Of Warcraft for about 10-12 hours.. The monthly card was just a waste of money.

2. I worked with www.samanat.com only for 10-12 hours.. The monthly payment at the webhotel was not worth it..

However, I am very happy this period. Loads of plans and traveling and having fun!

Soon I will start working again at www.samanat.com, which is not working because it's without webhotel now :(
I will start (hopefully soon) with a demo of what one can do with ruby on rails..

Oh, and I am looking for summer sports! I am planning to learn windsurfing :)

Getting away with it all messed up..

A lot of things are going really bad in my life those days..
Some people can argue that there are always more that can go wrong, but for the time being, I am not happy..

I am sad, confused, disappointed, nervous, angry, anxious, and the list goes on..

To avoid thinking of everything that makes me feel bad and all the adjectives above, I did 2 things.

1. I bought www.samanat.com and I am thinking of what to upload and how my personal website should look like.. Now I just put an "under construction" page..

2. and more efficient solution: I started World Of Warcraft again..

James - Getting Away With It (All Messed Up)

Concerts in Vienna

Two weeks ago I went to Vienna for a weekend break. Since I have been living in Scandinavia for the last 3 years, I am used to planning my trips in advance. This doesn't imply that I am following my plans, but that's another story.. The story here is about booking online tickets for a concert in Vienna's Opera.

AVOID http://www.viennaconcerts.com
This website looks nice and serious and comes first at google's results if you search for "concerts in vienna".. However, there are some small details that noone ever reads in the terms and conditions.

I booked a ticket for "The Magic Flute" and I paid 43€. I was going to get the ticket from the box office, just before the start of the performance..
It was only when I got the ticket in my hands that I realized that I paid 13.30€ more than the price of the ticket!

The price of the ticket was 29.70€!!!
Believe it or not, I had to pay 45% more than the original price!

Then I read the terms and conditions and I could see that
"Opera / Musical Prices
...
The net difference between prices listed at www.viennaconcerts.com and the face value of the opera tickets is generally 25%. For some ticket categories, due to high demand, the difference might be higher than 25% but not higher than 34 EUR / ticket. Very few performances and/or ticket categories where this difference is higher than 34 EUR / ticket are clearly marked as "incl. special purchase fee"."

Yeah.. Thanks.. I am happy I didn't pay double price..

Just avoid ViennaConcerts website..

How to create a SQL script that executes other SQL scripts

Yesterday I was facing the following problem..
I have several sql scripts that I want to call from a single sql script.
I am using SQL Server 2005.
I have found two ways of doing it. The first one is by directly calling the scripts one by one, and the second is by calling all the scripts in a folder.

First of all, you need to set your server to accept 'xp_cmdshell' commands.
This is done by the following code

USE MainDB

GO
EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sp_configure 'xp_cmdshell', 1
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sp_configure 'show advanced options', 0
GO

Now, let's assume that you have a folder at D:\Test, which has 3 files,
Test1.sql
Test2.sql
Test3.sql

The first way, which is the easiest way to execute this files by a sql script is by the following

USE MainDB

EXEC master..XP_CMDShell 'osql -E -i D:\Test\test1.sql'
EXEC master..XP_CMDShell 'osql -E -i D:\Test\test2.sql'
EXEC master..XP_CMDShell 'osql -E -i D:\Test\test3.sql'

If you want to run all the scripts in a folder, then you can use the following script

USE MainDB

CREATE TABLE ##SQLFiles ( SQLFileName VARCHAR(2000))
GO

INSERT INTO ##SQLFiles
EXECUTE master.dbo.xp_cmdshell 'dir /b "D:\Test\*.sql"'
GO

DECLARE cFiles CURSOR LOCAL FOR
   SELECT DISTINCT [SQLFileName]
   FROM ##SQLFiles
   WHERE [SQLFileName] IS NOT NULL AND
         [SQLFileName] != 'NULL'
   ORDER BY [SQLFileName]

DECLARE @vFileName            VARCHAR(200)
DECLARE @vSQLStmt             VARCHAR(4000)

OPEN cFiles

FETCH NEXT FROM cFiles INTO @vFileName
WHILE @@FETCH_STATUS = 0
BEGIN
   SET @vSQLStmt = 'master.dbo.xp_cmdshell ''osql -E -i "D:\Test\' + @vFileName + '"'''
   EXECUTE (@vSQLStmt)

   FETCH NEXT FROM cFiles INTO @vFileName
END

CLOSE cFiles
DEALLOCATE cFiles
GO

DROP TABLE ##SQLFiles
GO

This code will work if you don't need a username and password to connect to your database.. If your configuration is more complicated, you will have to add some more parameters to the osql. Read more here

Graduated!

Finally, I graduated..
I am not sure if I am happy for that.
Lately I have been planning to travel with Erasmus program to Australia! Since, I have graduated, I don't have this option anymore :(

But, anyway, it's good when things that are supposed to be done, are finally done!

Now, let's study something else..
Psychology and Law seem to be the main competitors..

News

It's been a long time, so I will just post the headlines of my news.

• No news about the flash project.. Still not sure if I passed/graduated or not.
• I have applied for a position as Teaching Assistant again from September.. It was fun :)
• I am considering some new projects for the summer.. Mainly websites..
• Still working at the bar of my kollegium on Thursdays and Saturdays.
• Still working at EasyTime International
• I start to like running medium distances (5km).. Competition is the best motivation!
• I, finally, applied for a visa to US and A. I have booked an appointment and on the 13th of July, I will go to the US embassy to try my luck..

I will come back with something more interesting soon.. I hope :)