While I continue to procrastinate, here are some excellent spatial resources to peruse.
First, David Lean, a Microsoft evangelist, has very comprehensive list of spatial posts over on his Dave does Data blog. He covers a wide range of spatial methods, the builder/sink API, as well as some pointers on creating spatial applications.
Second, John O’Brien, a Microsoft MVP, has a couple articles (here and here) showing how to do some cool data visualization right in Management Studio.
Finally, Johannes Kebeck continues with a couple recent posts on creating maps in Virtual Earth based on data coming from SQL Server.