I just finished my first SQL 2008 Spatial Article for Virtual Earth.
It is very introductory taking you though creating a table, importing some basic data and a VE application based on a well structured ASP.NET AJAX Web service model. I do a simple query for points within the current map view. I also add a spatial index. I hope you enjoy it, the full source code and data to import is available.