RC of SQL Server Hosting Toolkit released!

Hey folks.  This week we posted the Release Candidate for the SQL Server Hosting Toolkit to the web!  This includes both the Database Publishing Wizard and the Database Publishing Services. New in this release: –          Integration into Visual Studio 2005 and Visual Web Developer Express 2005.  You can now right-click on a database in the VS…


New CTP of SQL Server Hosting Toolkit released

Today, we’re excited to announce the release of the 2nd CTP of the SQL Server Hosting Toolkit! This CTP contains both a dramatically enhanced Database Publishing Wizard as well as the new Database Publishing Services. Major enhancements to the Database Publishing Wizard include support for almost all database-level objects and data types, a wizard-based GUI,…


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…


"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…


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…


Troubleshooting SQL Server 2005 Express Connection Issues

The folks at Teratrax posted a good set of instructions for troubleshooting any issues you might be having connecting to an instance of SQL Server 2005 Express: http://www.teratrax.com/articles/connecting_sql_server_express.html


Shape a TechEd Talk: "Peeking Inside SQL Server 2005 Engine"

Hi folks.  I’m giving a TechEd talk here in Boston titled “DAT421: Peeking Inside SQL Server 2005 Engine” tomorrow morning at 8:30 am in room 102AB.  We’ll be looking at how you can better understand what’s happening and what’s happened on your SQL Server by using the Dynamic Management Views, the Default Trace and other technologies in…


SQL Server Everywhere

We’re launching the first CTP of SQL Server Everywhere today! SQL Server Everywhere is a new, lightweght database you can load within the process of your application.  We first announced this new SKU a few months ago, and it’s an exciting addition to the SQL Server platform, providing a great solution for apps that use…


Looking to Meet Hosters at TechEd

If you work for a hoster that provides database services and will be at TechEd in Boston this coming week, shoot me a note.  I’m interested in discussing ways we can improve your experience with SQL Server…