In this tutorial Timmy Kokke shows how to create a smoke effect like the one used in the Silverlight Logo.
There are some techniques to render smoke by using 3D modeling software. But creating this effect in a tool like Expression Design is easier than it looks.