Archive for May, 2008
Thursday, May 29th, 2008
Have you ever experience with excel limitation that only allow you to store up to certain row of data ?
If not, then I just want to share with you that Excel limit only 65,536 rows per worksheet. If you have more than 65,536 records, then you no choice, need to put it in another worksheet and this will be troublesome.
The easiest way to get rid of this limitation is to put your data in csv file.There are no limitation on how many records you want to put into it.
Using SQL Query Analyzer, you can export your result set to textfile but not to csv file.
(more…)
Posted in SQL/ETL, Tips & Tricks | 5 Comments »
Tuesday, May 27th, 2008
I already upgrade my ubuntu to Hardy Heron last month. But then, I still order for FREE ubuntu CD throught ShipIT. I request for 5 CD’s 
Yesterday I received it and already give the CD’s to my bos and my colleague. I still have 2 extra CD to keep it for myself.
If you have your home network configuration similar to me then you can straight away enjoy your internet connection using Live CD. No additional configuration required. But this only applicable if you are connected using RJ45 cable and not the wireless connection.
I think it would be much much helpful if ubuntu by default comes with wireless capabilities
Wow, we can add new program even we are using Live CD.
Have you got your ubuntu CD ?
Posted in *nix, My Life | 4 Comments »
Friday, May 23rd, 2008
Got this email from my colleague, I think it’s worth to share it here.
———–
An earthquake, magnitude 8.0, struck Sichuan province of China at 2:28PM, May 12, 2008. The epicenter of the earthquake, Wenchuan, is about 90 miles from Chengdu.
The earthquake released more energy than 500 atomic bombs, 30 times more than the Kobe earthquake in Japan, 1995. By May 19, there are more than 32,000 confirmed dead, more than 20,000 still missing, and more than 4.7 million houses collapsed or heavily damaged.
Within hours, people rushed to rescue. Blood donation lines run for 100 yards, and people waited hours to donate blood; within 24 hours, all major blood banks ran out storage space. The highway to the earthquake struck city Dujianyang (20 mile from Chengdu) was almost jammed one hour after the earthquake, not by people fleeing the aftershocks, but by volunteers, led by over 1,000 taxi drivers, came from Chengdu to rescue.
Chen Guangbiao, owner of a big construction company 1,500 miles from the disaster area, just 2 hour 30 minutes after the earthquake, started transporting 60 construction machineries and led 120 volunteers to rescue. They arrived at the disaster area 24 hours later, almost the same time as Army Engineering Corp.
(more…)
Posted in My Life | 6 Comments »
Saturday, May 17th, 2008
Recently, as data cleansing exercise I need to convert 7 digit phone number. Well, this because there are old records that still using 7 digit instead of new 8 digit numbers. Lucky, there are freeware converter that can solve my problem.
Below are the sample how the software works.
Now, my big problem is that I have about 120,000 record to convert. As my post title suggest, yes…. i solved it using my simple automate program using AutoIT
(more…)
Posted in My Life | 12 Comments »
Friday, May 16th, 2008
Ubuntu adalah salah satu sistem operasi yang berasaskan Linux. Walaupun nama ubuntu tidak berapa sedap didengar oleh telinga tetapi IMHO ianya adalah sistem operasi yang cukup hebat.
Terdapat beratus-ratus versi Linux yang terdapat dipasaran dan anda patut tahu yang Ubuntu mendapat tempat pertama dalam senarai rangking yang dikeluarkan oleh DistroWatch.
Berita baik ialah, saudara zul telah menerbitkan e-Maj secara percuma untuk anda mengetahui dengan lebih lanjut apakah kehebatan Ubuntu.
Anda boleh klik gambar dibawah untuk download e-majalah tersebut atau boleh juga download di sini
Download counter :
(more…)
Posted in *nix, My Life | 2 Comments »
