Skip to main content

Nokia Holiday



This is my entry for Nokia N8 Holday Competition

Firstly, Ovi Maps. Preload all the places you want to go and you’ll never lost no matter where you are. Then if wifi or phone signal is around, ‘Check In’ will be my travel log for my friends and family through many popular social networks. Ovi Maps can also help you with weather forecast, where to grab lunch or having romantic dinner and suggest a good nice place to sleep.

What makes a good holiday if you can’t capture all those sweet moments ? With N8’s 12mp and 720p HD quality video, those scenes won’t miss by the Carl Zeiss lense and compliments it with Nokia Panorama to capture those beautiful long sunny beaches or to show how long is Qingdao Haiwan Bridge in China.

Lastly, going for holiday doesn’t mean leaving everything behind. What if you forget to ask your neighbour to look over your house or maybe your boss wants to congratulate you for winning a project for the company ? That’s when Skype comes in with saving calls even when your roaming service is unavailable. Sorry 'Angry Birds', but you're just too addictive for me to bring you along. Happy holiday.

p/s: If i win can Nokia pairs it with BH-905i, promise i'll make a quality review of it. Just trying my luck.

Comments

Popular posts from this blog

Why I Can't Move/Import VM in XenServer.

Ok this is what i found out, the metadata export/import via ' Backup, Restore and Update ' menu in xsconsole OR using ' xe vm-export filename=xxx metadata=true vm= ' will export all vm's metadata eventhough you've specify the vm in the latter, the former is ok because it is backup & restore tool. Problem happens when you want to restore the metadata or import to another xenserver. If you follow the method from 'Backup and Restore' in the reference guide, it should be ok if you're using pool because all pools are using shared storage; and if you don't use pool, your xenserver store all the VMs in the shared storage ONLY, means the Local SR is not use at all. This way, you wont face any problem. But, what if you have a mix of local & shared storage use. 

SQL using partition and connect by clause.

select id, max(ltrim(sys_connect_by_path(gred,' , '),' , ')) as mygred from (select b.KJ19SIJIL||b.KJ19KOD as id, b.KJ19GRED as gred, row_number() over(partition by b.KJ19SIJIL||b.KJ19KOD order by b.KJ19GRED) as myrow from kj19setara b) start with myrow = 1 connect by prior myrow = myrow -1 and prior id = id group by id order by 1;

SQL Tips : EXTRACT function as alternative to TO_CHAR

You want to create a sql to list data group in year (datetime datatype). Example as below : The table is smp.SC03F_TEMP with over 10 million rows. Usually, if there something deals with date we will use to_char function. As an alternative, you can use extract function to extract certain part of the date. In belows example, we extract the year of a column. As we can see the time taken is almost half for 10 million rows. Happy trying. select count(*) from smp.SC03F_TEMP; -- 10,866,921 records select count(*), to_char(A.SC03TARIKH, 'YYYY') from smp.SC03F_TEMP a group by to_char(A.SC03TARIKH, 'YYYY'); -- Time taken 54sec