There have been a couple of great Dexterity related posts on the blogsphere recently.
So, to make sure you get to see them I am posting the links here for you.
Please have a look at Sivakumar Venkataraman's post on using References with Dexterity. It amazes me how many people still don't know that this feature is available (especially the Update Reference Information on Compile option). It is covered in the Dexterity Training manuals (links available here), but still people forget it exists.
Mariano Gomez creates another informative article on using stored procedures from Dexterity to leverage the power, flexibility and performance of SQL server. Have a read and try it for yourself.