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.