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…

1

"LIMIT" in SQL Server

I’ve recently come across a number of folks in different contexts who were trying to figure out how to acheive the equivalent of MySQL’s “LIMIT” clause in SQL Server.  The basic scenario is that you want to return a subset of the results in a query from row number X to row number Y. The…

47

SQL Server Hosting Toolkit Launched

The SQL Server group at Microsoft has just launched the SQL Server Hosting Toolkit with the release of the Database Publishing Wizard Community Technology Preview 1. The objective of the SQL Server Hosting Toolkit is to enable a great experience around hosted SQL Server.  The Database Publishing Wizard works toward this mission by making it easy to upload a…

3