FAQ: Error creating a Service-based database in Visual Studio 2008 SP1

A few of you have run into problems when trying to add a new Service-based database to your project in Visual Studio 2008 SP1. This problem has been reported to Microsoft Connect and the Visual Studio team is working on a fix, but I thought I would provide some details on a workaround in the…


DIY SQL Express SP2 Bootstrapper

I’ve waited far too long to communicate this disappointing news to everyone, so here it is… I’m not going to be releasing the SQL Express SP2 Bootstrapper manifests that I had discussed in a long ago blog posting. I’ll spare you the sob story of my efforts to create this; suffice it to say that…


Backup and Restore with User Instances

Backup and Restore is an important part of any application, but when you’re writing an application for an end-user, it becomes even more important that you do a good job of handling Backup and Restore in your code since you end-user will likely not know much about being a Database Administrator. Add to that the…


Source code for Embedding Webcast (Finally)

Updated Sample Available!   Steve Lasker (of SQL Server Compact fame) and I spent some time reworking this deployment sample for a presentation that Steve did at TechEd Barcelona at the end of 2007. You can find Steve’s post including links to all his presentations here. Of particular interest to this group is the updated Deploying Database…


FAQ: Detecting SQL Server 2005 using WMI

I’ve gotten a number of e-mails asking how to detect if SQL Express is installed on a computer. I’m finally getting around to putting this in the Blog so I don’t have to keep typing the answer. We’ve made discovery much easier in SQL Server 2005 with the addition of the SQL Server 2005 WMI…


New Starter Kit and Sample Applications

We’ve release a number of samples that will help you explore the functionality of SQL Express (and Visual Studio too). This is just the first batch, so watch this space for some additional samples to be released in the near future. See the details of each sample below. Mike WachalSQL Express team Collection Manager Starter…


Report Packs and SQL Server Express

The SQL Server team recently released eight new SQL Server 2005 Report Packs for download.  Use the Report Packs as way to get up and running on Reporting Services in SQL Server 2005 Express. The Report Packs include sample reports and databases for views into commonly used application data such as IIS logs, and SharePoint…


Various Downloads of Samples and Documentation for SQL Express

MSDN has a downloads page specific to express: http://www.microsoft.com/downloads/details.aspx?FamilyID=2adbc1a8-ae5c-497d-b584-eab6719300cd&displaylang=en   -Euan Garden Product Unit Manager SQL Server Tools


Sample: VB.Net Express and SQL Express Music Manager on MSDN

Brian has a great sample on MSDN that shows off new features in the express SKUs. It really looks cool and pretty simple in terms of code. Please give us feedback as we have more samples planned.   -Euan Garden Product Unit Manager SQL Server Tools