Deploying a DB to your Hoster
So you got a hosting account and you're ready to deploy your site/app to the web! (If you haven't yet, there are lots of great hosters out there offering Windows/ASP.NET/SQL hosting solutions)
Pushing the ASPX pages has always been pretty straight-forward, but moving the database (along with its data) from a dev box up to a hoster has been tricky (read: very hard) until recently. With the release of the first CTP of the Database Publishing Wizard, it's now an easy task.
Ibra Bordsen (a developer on the SQL Hosting Team) recently posted a great tutorial on how to use the Database Publishing Wizard to deploy a DB to a hoster. Check it out and let us know if you find it helpful.