MSSQL 2005 Cluster Installation

A brief steps on setting up MSSQL 2005 SQL DB Installation in a Microsoft 2-node Clusters.

1. Login to node1.
Click setup.exe
Install the SQL DB services.

2. Upon completion on node1.
Login to node2.
You need not have to install the DB services.
Just install the client tools.
Please note that the C:\program files\microsoft sql server\ folder will be created automatically at step 1.

3. Applied sp2.

Presto!

COE $2

COE has dropped to $2. COE is the certificate to own a car in Singapore. So that means eventually it is cheaper to own a car. But resale value will be lesser.

Delete Windows Files Permanently Eraser

Try www.heidi.ie or www.dban.org

Download the eraser tools. It's free. Very nice tools.

This will help to eliminate embarrassment moment like the recent Hong Kong's actor Elison Chan nude pictures circulated online.

Oracle Level 12 tracing

We can enable level 12 tracing by
exec sys.dbms_system.set_ev(&sid, &serial, 10046, 12, '')

and then stop it with
exec sys.dbms_system.set_ev(&sid, &serial, 10046, 0, '')

Normal level tracing
execute sys.dbms_system.set_sql_trace_in_session (&sid,&serial,true);

How To Flash the WRT54G v8 / WRT54GS v7

This guide was obtain by googling. Alternative, from dd-wrt.com

How To Flash the WRT54G v8 / WRT54GS v7


1.
configure your local lan ethernet address to 192.168.1.100 and connect your local ethernet to your WRT54Gv8/GSv7 on one of the 4 switch ports
2.
plugoff the power cord from the WRT54G v8/GSv7
3.
push the reset button while replugin the power cord and hold the button for about 20 seconds
4.
open your browser and open http://192.168.1.1
5.
use the firware upgrade dialog to flash vxworkskillerGv8.bin / vxworkskillerGSv7.bin
6.
after the dialog is shown that you need to plugoff the power cord, remove the power cord and replug it in
7.
wait for about 1 - 2 minutes
8.
plugoff the power cord again and replug it in.
9.
enter "tftp -i 192.168.1.1 put dd-wrt.v24_micro_wrt54gv8.bin" on your local windows console and press enter
(for linux, tftp 192.168.1.1; mode octet;put dd-wrt.v24_micro_wrt54gv8.bin)
10.
the file will now be transfered to your router and be flashed. after this is done, dd-wrt will automaticly boot and you can reach
your router at http://192.168.1.1

WRT54G ver 7 firmware hacking

Forget about hacking WRT54G ver 7. Because they don't use boadcom chip. ROM is only 2MB which is insufficient to store for some drivers upgrade.


Other version might work though.

You can refer to dd-wrt for other models upgrade. Good luck.

E-concierges like Globeshopper, Comgateway and vPost

Citibank's Globeshopper, ComGateWay & VPost
http://www.borderlinx.com/citi/sg/en/index.html

You will need a Citibank credit card to register using the above page.

As for ComGateWay, for Singapore residents, you will need a Amex, DBS or HSBC credit card.

http://www.comgateway.com

https://www.vpost.com.sg/vpostusa05/index.html

Reference:
http://www.zest.sg/forum/shopping-f14/citibank-s-globeshopper-comgateway-vpost-t22.html

Strike 4D!

First time in my life history, striking a 4D number. Consolidation prize.

Something nice to share with family with Haagen Daz ice cream.

Hurray. When will be the next?