Archive for July, 2007
Thursday, July 26th, 2007
Trigger is special set of SQL code where activation is caused by modifications to the tables. (by an INSERT,DELETE or UPDATE).
Trigger is associated with database table, so if you want to find it from your SQL Enterprise Manager or your SQL Query Analyzer, you need to go table by table to find where the trigger is. [see below picture]
If you don’t want to find it that way, no worries. There is easy way how to find it. Just use simple query and all your triggers associated to which table will be list down.
(more…)
Posted in Database | No Comments »
Wednesday, July 25th, 2007
Hi guys,
I know something new today. Do you know that we have a duplicate data in malaysia postcode ? What i mean is that, there is one postcode tagged to two states in Malaysia.
I don’t know this until today when I do my extraction query to give a pool of data to user and I cannot get the data as per what I expected because of this thing. It take me hours to figure this out.grrrrr….
I did a search in Pos Malaysia website and guess what ?
(more…)
Posted in My Life | 4 Comments »
Friday, July 20th, 2007
Years come and go….but guys, do you notice that today is a special day ? …
* 20072007*
It happens only once in a lifetime…
Just want to wish you guys a very wonderful day. May our dreams come true…
Posted in My Life | No Comments »
Friday, July 20th, 2007
Imagine you’re a single father. You have been evicted, and you have nowhere for your child to sleep. What would you do ?
The Pursuit of Happyness, is based on the astounding true story of Chris Gardner’s, a homeless single father
Althought this movie has been on scene a while ago, I just had a chance to watch it with my family recently.
A scene that really touched me was at the subway bathroom, where Chris and his son sometimes spent the night on the floor.
Look at these happy face, might as well make us feel happy too right .
So, what do you think will make you feel happy in your life ?
(more…)
Posted in My Life | 2 Comments »
Friday, July 13th, 2007
Update : Download UDPv270.zip. This file has been downloaded times
—————
Previously I lost my 128MB Kingston usb disk (yeah…it’s more or less than 5 year I use it). All my important and sensitive data inside gone…
Of course, whoever take/found it would easily open and see all the data.
Then I bought 1GB Pendrive 
for RM35. Oklar,It’s consider cheap compared to last few years.
Do you know that we can actually make this device password protected and make it more secured ?
(more…)
Posted in Tips & Tricks | 21 Comments »