Tips | Tech Sharing Blog

Insert image into Gmail

By David on April 19, 2009

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.

enabled images in gmail labs Insert image into Gmail

Enabled images inserting in Gmail labs setting

After you enabled the features, you will get the new toolbar icon like this:

inserting images in gmail Insert image into Gmail

Inserting images toolbars icon

In order to insert the photo into your email, you must make sure you are in the rich formatting mode, else you will not get the images inserting logo show up. Just click on the logo, you can insert imges in 2 difference way: by uploading image file from your cmputer or just providing the image URLs.

Keep in mind that Gmail doesn’t show URL-based images in messages by default to protect you from spammers, so if you’re sending mail to other Gmail users, they’ll still have to click “Display images below” or “Always display images from …” to see images you embed.

uploading photo in gmail 300x180 Insert image into Gmail

Uploading photo progress in Gmail

More From david_cheong

david_cheong Recommends

Bankruptcy Lawyer Cost: Why You Need To Pay A Lawyer To Represent You | MY Lawyers Time (My Lawyers Time)
GumGum.com – Make Money From In-Image Advertising (SiteBuilderTips.com)

Popularity: 1% [?]

MS SQL Server – Index Optimization checklist

By David on April 15, 2009

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 in mind and should go through. This is the foundation of the index optimization but it mean and help you a lot, if you already follow and apply all the checklist below, then you may need to try out more experiment to get more optimize:

Index optimization checklist:

Create Index on frequently used columns in T-SQL Code. Columns used in WHERE, ORDER BY and GROUP BY are good candidate for Indexes. Create Index on columns which are used in JOIN Condition.
Remove any un-necessary Indexes. As Index occupies hard drive space as well as it decreases performance of the entire insert, updates, deletes to the table.
Smaller Index Key gives better performance than Index key which covers large data or many columns
Index on Integer Columns performs better than varchar columns.
Clustered Index must exist before creating Non-Clustered Index.
Clustered Index must be created on Single Column which is not changing and narrow in size. Best candidate is primary key.
Non-clustered Indexes increases performance of the query that returns fewer rows and rows has wide selectivity spectrum.
Each table must have one Clustered Index.
If column have low selectivity avoid creating Index on that column as it slow down the rows modification and system will not get benefit from Index.
Multiple Columns Index or Covered Index should be ordered as Most Selective column on left and gradually decreasing selectivity as they go right.
Use SORT_IN_TEMPDB option when table is created if tempdb is on different disk. This will increase the performance to create Index.
Rebuild Index frequently using ALTER INDEX and De-fragment Index to keep performance optimal for Indexes.

More From david_cheong

david_cheong Recommends

10 WordPress Plugins To Improve a WordPress Blog (Build a Blogg)
Search Engine Optimization Specialists (World Class Media)

Popularity: 2% [?]

T-SQL: Concatenate something + null=null

By David on April 11, 2009

mssql2005 T SQL: Concatenate something + null=null This whole morning just spent about 1 hours+ just to try out one very simpel query on MS SQL 2005.

I keeping get the null value whenever i run this query, even in my program or run directly from the MS SQL 2005 management studio.

Finally I found out that is you are concatenate null values, either the concat null yields null setting of sp_dboption or SET CONCAT_NULL_YIELDS_NULL determines the behavior when one expression is NULL.

With either concat null yields null or SET CONCAT_NULL_YIELDS_NULL enabled ON, String + NULL returns NULL. If either concat null yields null or SET CONCAT_NULL_YIELDS_NULL is disabled, the result is String?

This is the case 1

Update tableA
set field1 + ‘My value’
where field2 = 1

This is the case 2

select ‘test ‘ + null + ‘ string’

returns
————
NULL

This is the solution

set concat_null_yields_null off
select ‘test ‘ + null + ‘ string’

returns
————
test string

More From david_cheong

david_cheong Recommends

Is working out a good way to meet people of the opposite sex? | Sportize.me (Sportize.me)
Making Money With Cell Phones, My First Month Running A Mobile Site (SiteBuilderTips.com)

Popularity: 1% [?]

New in Gmail Labs – Undo Send

By David on March 23, 2009

Undo Send – Another amazing new labs features developed by Gmail team.

Most of the people are waiting for this features long long time ago. Most of the time we only notice that we make some mistake in the email immediately after we click on the “Send” button.

Now with Undo Send features, you may still stop and undo the send within 5 seconds after the button clicked. But bear in mind that this features can’t let you pull back the email that’s already done; it can only holds your message for 5 seconds so that you may still recover back the recent make mistake.

How to get this features?

Login to your Gmail account
Go to Settings
Go to Labs tab
Go to Undo Send in the long labs features list
Click the Enable radio button
Save the change

[More]

More From david_cheong

david_cheong Recommends

12 Tips On How To Stop Foreclosure Now. | MY Lawyers Time (My Lawyers Time)
Workers’ Compensation in New Jersey | MY Lawyers Time (My Lawyers Time)

Popularity: 1% [?]

Paypal fee calculator

By David on March 23, 2009

Paypal Fee Calculator is a small and simple tools for you to calculate the amount of money that you going to charge your customer if you want to transfer the finance charges to them.

Paypal fee calculator available in 2 difference mode which are simple mode and advance mode. If you just want to find out how much your customer need to pay to you using the Paypal account without involve any currency convertion, then just enter to the simple mode.

What you need to do is enter finance charges at the bottom of the page, then enter the amount you wish to received at the top of the page. The Paypal calculator will help to you calculate how much you should ask your customer to pay to you in order to get a exactly the amount.

[More]

More From david_cheong

david_cheong Recommends

Bankruptcy Lawyer Cost: Why You Need To Pay A Lawyer To Represent You | MY Lawyers Time (My Lawyers Time)
What to Expect During A Lawyer Consultation | MY Lawyers Time (My Lawyers Time)

Popularity: 1% [?]

Google Search Result Page

By David on February 24, 2009

Google Result page is one of the world highest page view webpage every single day. But are you really understand and know every single component and information appear on the page?

Google result page is actualy filled up with the information and links which is relate to the search query that you enter at the search text box.

resultspage Google Search Result Page

The result page is actually contain Google Logo, Statistics Bar, Tips, Search results, Page title, Snippets, URL of result, size of the text portion of the web page, Date, Indented Result, More result and more.

[More]

More From david_cheong

david_cheong Recommends

5 SEO Strategy Tips! – Google Panda + Freshness (World Class Media)
29 Worst Practices & Most Common SEO Failures. (Synergy)

Popularity: 1% [?]

Email signature SEO

By David on February 23, 2009

A small tips for all the website owner. You may include your web blog url, web site url or RSS link in your email signture to help you in attracting some free traffic to your site.

You may design the signature in HTML form with the editor tools such as Macromedia Dreamwaver or Microsoft front page, then attach it in your email client. But for Gmail Webmail user, you need a tools such as WiseStamp to help you to attach it, as by default Google don’t allow HTML signature.

With the website url and the RSS link provided, you may attract your receiver who are actually wish to know you better. It may be useful for those who like to send the forwarded email to your friend.

I did this few weeks ago and it did help me in increasing my web blog traffic and also increase the subscriber number for by feed.

Hopefully this small tips can help you all.

my signature in gmail Email signature SEO

My sample siganture in my Gmail

More From david_cheong

david_cheong Recommends

5 SEO Strategy Tips! – Google Panda + Freshness (World Class Media)
Traffic Without SEO = Money (Build a Blogg)

Popularity: 1% [?]

Gmail shortcut key

By David on February 23, 2009

Gmail are provided with the full access/navigate the webmail using your keyboard shortcut key. The keyboard shortcuts actually help you to save time by allowing your hand just stick on your keyboard.

But in order to avoid to crash with your browser or system shortcut key, Gmail pre-define shortcut may be not so familiar for you. You need to remember your most common use key such as next/previous email, send email, delete email, reply email.

How to turn on the keyboard shortcuts?

Login to your Gmail
Click on setting on the top right corner
Go to general
Select the “Keyboard shortcuts on”
Save the change

The following is the shortcut key that may be useful for you:

[More]

More From david_cheong

david_cheong Recommends

Key Questions To Ask Your SSD Lawyer (My Lawyers Time)
How To Find A Good Lawyer For Your Specific Case | MY Lawyers Time (My Lawyers Time)

Popularity: 1% [?]

Customize your ad unit font face in AdSense

By David on February 23, 2009

Google AdSense official blog had announce that now the site owner can customize the font face for Google AdSense ad unit. This is a great news for all of the webmaster because now you have more flexibility when you design the ad to be place in your website.

“However, you can also select custom font faces for specific ad units that you’ve created with the Manage Ads feature. When creating new ad units, you’ll be prompted to select between the default ‘Standard AdSense font family’, your new account-wide font face (if you’ve selected one), or another font face. You can also change the appearance of existing ad units, by visiting the Manage Ads page of your account and updating your font choices for specific ad units. Once you’ve changed the font face of an ad unit away from the default, those selections will be maintained even if you change your account-wide settings later.”

Click here to read more detail

font control settings Customize your ad unit font face in AdSense

font control manageads Customize your ad unit font face in AdSense

More From david_cheong

david_cheong Recommends

Working out with your significant other | Sportize.me (Sportize.me)
3 tips for your safety in weight exercises (Sportize.me)

Popularity: 1% [?]

What is bounce rate to do with SEO?

By David on February 22, 2009

bounce rate What is bounce rate to do with SEO? According to Google, the bounce rate is the percentage of single-page visits at your website and the visitor left your site from the entrace page without contribue any single click.

Google is using this metric to measure the visit quality. The higher bounce rate generally indicated that the site entrace page aren’t relevant to your visitor. So the more relavent your page content with the keyword, you may keep them to stay at your page with a longer time.

What to do with the Bounce Rate with Google Ranking?

From the Google defination, Google actually look at the bounce rate very seriously when they are ranking your page.So if you page contain the keyword with the high bounce rate, Google will lower your page ranking for that particular keyword. This is because your page content is none related to that particular keyword.

On average, the bounce rate around 50% is consider normal.

How to reduce the bounce rate?

The bounce rate is a value helping you to measure the quality of your website traffic. By analyzing the bounce rate (using the free tools such as Google Analytics), you are able to to fix the problem of your web pages and ultimately increase your website traffic.