I previously wrote about importing OpenStreetMap data into MS SQL Server, and accidentally came across another project dealing with this topic.
osm2mssql not only imports data from OSM files, but also uses the SQL Server Geography types to encode the imported data. osm2mssql is hosted on CodePlex.
Thanks for recommending osm2mssql. If you want, you can help developing osm2mssql. 🙂