Tech Sharing Blog

Check out the slide show to find out which blogger are you consider as?

Popularity: 1% [?]

Do you believe that the Search engine gaint are FAIL in math?

Google search engine calculator will display the wrong answer if you try to calculate the very large number. For example 2,999,999,999,999,999 minus 2,999,999,999,999,998 should be get the answer of 1, but google give the answer of “0″. Suprise?

You will only get the correct answer  2,999,999,999,999,999 minus 2,999,999,999,999,990 which the answer is 9.

The other example is 400000000000002-400000000000001, you will get the answer of 0 instead of 1, but 400000000000002-400000000000000 you will get the correct answer of 2 from Google calculator.

Basically this post is just for fun, I’m not sure what is the story behind the calculation error, maybe is a bugs, or maybe Google have their own explaination on it.

Popularity: 1% [?]

I try to google, call, msn my friend to find out the solution when I stay back in my office until late night yesterday. But still no luck after few hours of trying.

Thinking of gave up when back to office this morning, but one of my friend suddently send me the solution via MSN. That’s the best present I received by today. I’m not sure how many people will looking for this kind of solution, but any way, will post here to share with all and you may take it if you need it.

Basically the idea is that you put all your select, update or delete statment into the variable and use the execute command to execute the whole variable.

My problem:

I have a formula store in a table which is A+B*C+D. My A = 1, B=2, C=3, D=4.

I managed to replace all my variable with the integer using cursor (This maybe not a good solution, but this is not the main discussion in this post)

The finally answer I get is 1+2*3+4. But the bad thing is in the varchar datatype. I only manage to disply 1+2*3+4 but not the answer of 11.

The solution as below:

Declare @MathFomula Varchar(100)

Set @MathFormula = ’1+2*3+4′

Exec(‘SELECT ‘ + @MathFormula  + ‘ AS Result’

Output: 11

* Remember that * and / will calculate at first before + and -

Popularity: 3% [?]

Another new launch Gmail Labs features where you may preview your messages while waiting for the Gmail to be completely load. The new features is named as

“Inbox Preview”

If you are on the high speed internet connection, then this features may not benefit you. But try to imaging that you are on the very slow internet connect which may take several minutes to only completely load your inbox. How bore you are while you waiting for that and you find nothing to do besides look at the loading bar and counting the movement of the bar.

In addition, if you only found out that there is no any new message for you to read after servaral minutes of waiting, how disappointed you are.

Gmail always try the best to make their product become more user friendly you may have a static preview of your inbox with the 10 most recent messages on the screen.

What you need to do is just to turn the Inbox Preview features on in from the Lab tab under the settings.

Popularity: 1% [?]

I believe most of the advance computer user will know how to ultilize the window run command. But for the normal user may not ultilized it but more prefer to click by mouse.

The most common use command is [cmd] and also [notepad]. By using the window run command, you may just press on [Window Key] + [R] on your keyboard and type the command.

The following are some of the window run command that you may or may not use, but I suggest if possible try to remember the most common use which will help you to save your time and also reduce the movement of your hand.

Accessibility Controls
access.cpl

Add Hardware Wizard
hdwwiz.cpl

Add/Remove Programs
appwiz.cpl

Administrative Tools
control admintools

Automatic Updates
wuaucpl.cpl

Bluetooth Transfer Wizard
fsquirt

Calculator
calc

Certificate Manager
certmgr.msc

Character Map
charmap

Check Disk Utility
chkdsk

Clipboard Viewer
clipbrd

Command Prompt
cmd

Component Services
dcomcnfg

Computer Management
compmgmt.msc

Date and Time Properties
timedate.cpl

DDE Shares
ddeshare

Device Manager
devmgmt.msc

Direct X Control Panel (If Installed)*
directx.cpl

Direct X Troubleshooter
dxdiag

Disk Cleanup Utility
cleanmgr

Disk Defragment
dfrg.msc

Disk Management
diskmgmt.msc

[More]

Popularity: 1% [?]

I just found out this usefu function in MSSQL when I try to Google for the solution to replace the null value with something else. So that I no need to do the checking again in my application. The function is call

NULLIF and ISNULL

This 2 functions are actually work opposite with each other.

NULLIF(ColumnName, ValueToCompare) accept 2 parameters, and will return the NULL value if both the expression match.

IFNULL(ColumnName, NewValue) accept 2 parameters, the first parameters is the string that you wish you check with, and the 2nd parameter that you wish to replace with.

Popularity: 3% [?]

The most recent addition to Gmail Labs is a feature that lets you quickly add Google search results to a message. Instead of opening a new tab, typing the query and copying the results, you can now search directly from Gmail. The box that shows up lets you copy the results or just the web addresses, but you can also drag the links to your message.

[More]

Popularity: 1% [?]

After the recent incident (domain name expire and status changed to Redemption period), I decide to find out what are the domain name status actually mean. It is important for all the domain name owner to know what your domain name status and also the expire date in order to avoid any down time occur at your site.

The following details I get it after Googleing for some little time, hope this will help you to understand better your domain name. There are difference status codes use for .com and .net domain name extension compare to other domain name extension, such as ORG, BIZ, US, INFO, and NAME Domain.

COM and NET Domain Name Status Codes

These are the 6 domain name status codes used for COM and NET domains:

ACTIVE: The registry sets this status. The domain can be modified by the registrar. The domain can be renewed. The domain will be included in the zone if the domain has been delegated to at least one name server.

REGISTRY-LOCK: The registry sets this status. The domain can not be modified or deleted by the registrar. The registry must remove the REGISTRY-LOCK status for the registrar to modify the domain. The domain can be renewed. The domain will be included in the zone if the domain has been delegated to at least one name server.

[More]

Popularity: 1% [?]

Last weekend I found out that my site no longer accessible, after few email conversation with the hosting company tech support, then only found out that my tech.david-cheong.net domain name has been expire.

Domain name expire is not a big issue actually, but the big issue is that the domain name is not registered by my self, so I cannot renew it or recover it. Besides that, after I keep in touch with the registrar company (1 & 1 Internet Ltd) they require for USD 40 just to recover my domain name.

Because I’m just blog for hobby, so there is no point for me to just get a domain name with USD 40. Imediately I decide to register another new domain name – david-cheong.com (it only cost me MYR 40, about 3.5 times cheaper then recover back my old domain name)

There are good and bad thing for a old site with the new domain name. The bad thing is all the SEO link will become broken and most of the reader will not get directed to my site from that link.

The good thing of that is I need to redo all the SEO stuff, after learning from all the SEO guru around the world, is time for me to apply my learning into the practical.

Anyway, today will start with all the inbound link creation and also the forum posting to announce my new domain name

tech.david-cheong.com

Popularity: 1% [?]