ISNULL, NULLIF MsSQL function

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…

Google search features in Gmail

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…

List of domain name status code

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…

Web

New domain name – tech.david-cheong.com

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…

Insert multiple record into table

In SQL, basically there are two ways to Insert data into a table; one is insert it one row per time, another way is insert multiple rows at a times. For the first method (insert one row per time) is the most common way to insert data into database that…

Get the number of row in database table

Normally to get the number of row for a particular table, where we will do is as the following query: select count(*) from Table_name Yes, you may get your result very fast if your table is very small, but if your table is more then 100k rows, then you may…

Suggest more recipients

Have you ever experient that you may mistakenly left our some important recipient that you wish you to send an email to. Or you may spend your valuable time just to enter/key in the same recipients email address again and again or just spent your time to think who are…

Insert image into Gmail

Gmail labs has just release another useful and long waited features by Gmail user – Images inserting features. Now you may easily insert the images into your email inlines. Just turn on the “Inserting images” features on from the Labs Tab in your Gmail setting. After you enabled the features,…

Google Data Center Video

Are you even thinking of how the Google data center look like? How are they actually host the most stable system by providing such as good search result and response to all the internet user. Recently Google has released a video showing a data center of theirs. This is one…

MS SQL Server – Index Optimization checklist

I believe all the DBA know that how important is “Index” in the database if you would like to optimize the database server performance. It maybe a pain for your server if you create the index wrongly. Here are some check lists on the index optimization that you should bear…