Martin Fowler (the patterns / agile king) has a great video of a talk he delivered on Domain Specific Languages at JAOO 2005. Check out this video. It will give you a great overview including practical simple examples. No stone will be left unturned including Embedded DSL, pros, cons, language choices, etc.

Check it out!