5 minutes tips

a web site to give you some useful tips to better use products and services. There are many tips about how to quickly get some tasks done in Microsoft Office Applications.

http://www.timeatlas.com/5_minute_tips/

Explore by yourself. Some tips can really save you some time.

Migration Patterns

Atlas is a moving company. A map (2010 Migration Patterns) on their website is very interesting. From the moving pattern, one can reasonably get an idea about which state are adding population and which state the population are losing population.

http://www.atlasvanlines.com/migration-patterns/

How to handle large amound of Markers in Google API

Read this blog today, this is a very good article to talk about how to handle large amounts of markers in your Google Maps Application.

One method is called MarkerClusterer. It is a simple and effective solution for displaying many Markers on the map.

More detailed can be found Xiaoxi Wu's blog. http://googlegeodevelopers.blogspot.com/2009/04/markerclusterer-solution-to-too-many.html

Interactive Demographic Maps from NY Times

Mapping America: Every City, Every Block

This is a very useful map application. users can browse local data from the Census Bureau's American Community Survey, based on samples from 2005 to 2009. User can choose from population, income, family and education category to visually check the spatial pattern of each variable and may help them better understand the demographic distribution in the area they are interested.

Learn Chinese

Would like to learn Chinese and try to find some useful learning materials, http://www.hwjyw.com/ will give you what you want. Check it out.

Customize Your Desktop - ObjectDock

Looking for a quick/fun way to add your shortcuts on your desktop, ObjectDock is a great choice.

You can download the ObjectDock from the website http://www.stardock.com/products/ObjectDock/.

Even the free version can save you a lot of time and making your desktop looks nice.

SQL - Insert Multiple Records into one tables at one time

How are you going to insert multiple records into a table at one time?

Here is the code you can do that:

Insert into Table
(Column1, Column2, Column3)

select Value01, Value02, Value03
Union ALL

select Value11, Value12, Value13
Union ALL

select Value21, Value22, Value23

It works and save time by avoiding multiple insert scripts.

Coordinate coversion

If you have some knowledge about geography, you my be familiar with different projection system. The projection system will display earth surface on the flat paper. Sometimes you may need to convert coordinates into different projection system. You can do this with GIS software. But you want to do it online, there is website for this task.

It is:

Earth Point

I found the coordinates conversion features very useful.

Envelope-free to deposit checks in ATM

Wachovia Bank now can deposit your check without envelopes. You do not have to even put the amount y0u are going to deposit. The ATM machine can read and scan checks and automatically know how much money that will be. You can deposit multiple checks at one time. It is very convenient. Then if you want a receipt, you did have a choice to get a receipt with scanned check images.

Not sure if the ATM machines in other banks have the same kind of features, I do find this new feature is very useful to customers.

Link to Wachovia bank

GIS Map templates

Would like to create a professional map, or create a map like ESRI sample map viewer, please go to the webpage to download the sample map documents.

http://resources.esri.com/maptemplates/index.cfm?fa=codeGallery

All you need to do is to change the data source and/or the coordinate system (projection).

calling a stored procedure from asp.net

If you would like to use the asp.net code to call a stored procedure from SQL, the following article will show you how to do it step-by-step.

http://www.macronimous.com/resources/calling_stored_procedures_from_ASP.NET_and_VB.NET.asp

SQL insert,

If you like to insert value in SQL table based on a selected data set from another table, you can use the following syntax:

Insert into table1 (Col1, Col2, col3)
select Col1, Col2, col3 from table2 where Col1 > 'abcde'

Ipad

read a lot of Ipad news about apple, very impressive product.

I think the following features would make it more popular.

1. Video Camera
2. GPS navigation system
3. A built-in Free drawing application, maybe there is one, but I do not know.

For multi-tasking, I do not care that much. As long as it works quickly and smoothly for each application, it is enough.

KitchenAid Pasta Roller to make Dumpling Skin

I found out a quick way to use the KitchenAid KPRA Pasta Roller Attachment for Stand Mixers to make the Jiaozi (dumpling) skin. First, use the standard mixer to make the dough. Then take the dough out and cut a big piece of dough to roll the dough into a long soft stick shape by hand. Then cut the dough by small pieces. each small piece will be made to one dumpling skin.

Then using Pasta Roller to roll the small pieces by using the thickness grade of 2, the small piece will be into an oval shape. Then adjust the thickness grade into 3 or 4, then roll the same small dough piece by the other side, the dough will be rolled into a circle (round) shape. It is very simple and easy. You can adjust the thickness grade of the roller to make the dumpling skin bigger or smaller.

Enjoy your dumpling.

common table expression (CTE) in SQL

Have you ever used the Common Table Expression in SQL query scripts? It is very useful feature. CTE make the scripts easier to read and maintain. And it is also easier to write sql scripts with CTE for complex queries. CTEs can reference themselves.

With CTE_Table as
(
select column1, column2, column3 ... from table1 join table2 on column1 = column3
)

select *, table3.column1 from CTE_Table join Table3 on .........................


The script is very clean and simple

SQL functions - UNION, EXCEPT, INTERSECT

The three functions in SQL 2005 cam combine the data from two or more tables and display them in one dataset.

Union (all) - union two or more table data together, by default it will only show the DISTINCT row data unless the "all" option is used

EXCEPT - pick the data from first table but the data not exist in the second table

INTERSECT - Pick the data rows only exist in the first table and the second table.

EXCEPT and INTERSECT function can be implemented by using the join function in SQL queries. but these two features are sometime more simplified and the code is easier to read.

Batch Geocoding

If you have many addresses and would like to geocode them, the following website provide free geocoding service. It works very well.

http://www.batchgeocode.com/

Geocoding, find the x,y coordinates and locate your address on a map. The site will add latitude/longitude to your address data. It can also display your addresses on Google map.

How to clean your glasses - A lessen

Recently I found my glasses are full of scratches and do not know what caused that. I can not see the monitor clearly but can see large objects without problems. When I looked at my old glasses. They do not have these many scratches.

Then I started noticed that maybe I have used my clothes and dry towers to clean the glasses. That caused so many scratches on the glasses. This really gives me a lessen.

I searched online and find this page very helpful for cleaning your classes and tips how to keep your glasses clean.

http://www.wikihow.com/Clean-Eyeglasses

Paint a room and windows - Do it by yourself

I am planing to paint all the interior windows by myself. Found a very useful article to follow step-by-step.

http://home.howstuffworks.com/how-to-paint-room.htm

Also, this video is very helpful too

http://www.howcast.com/videos/716-How-To-Paint-a-Wall?ref=share

if you are going to do any paint work by yourself, I highly recommend you to look at the video and article beforehand.

Good luck!

Free Internet Faxing Service by Email2Fax.com

Free Internet Faxing Service by Email2Fax.com

This internet fax service allows you to send fax for free.