SQL Server 2008 Upgrade Whitepaper

The SQL Server Engineering team has released a masive white paper that details upgrading to SQL Server 2008. It’s all good information, but if you’re reading this blog you’re probably interested in chapter 10, which specifically covers SQL Server 2008 Express. You can find more information here. – Mike


Getting SQL Server 2008 Express on a DVD

A small but persistent group of developers has been asking for SQL Server Express to be released on media, most commonly from those folks who live in areas without broadband Internet (yes, there are still such areas) for whom downloading an 80 MB package can be an endurance challenge. One of the benefits of the…


Announcing the SQL Express 2008 Installation Package

Update: The SQL Express 2008 Installation Package (Express Wrapper) is no longer available. Currently the best way to install SQL Server Express is to use Web Platform Installer.   FYI: SQL Server MVP Andrea Montanari has posted his own summary of the experience of using this tool including screen shots of the UI. A quick and…


FAQ: Switching between SQL Server 2008 edtions

There is an extra step that you need to take when upgrading from one edition of SQL Server 2008 to another, for example when upgrading from Express to Express with Tools. This extra step is called Edition Upgrade (sometimes SKU Upgrade) and the net result is that you have to run the install wizard twice…


SQL Server 2008 Express is now live!

I promised an update on SQL Express availability in my last post about the release of SQL Server 2008 so here it is. SQL Server 2008 Express is now available along with the release of the .NET Framework 3.5 SP1, which is a prerequisite and Visual Studio Express SP1. As I mentioned, there are two…


What’s up with SQL Server 2008 Express editions

<?xml:namespace prefix = w ns = “urn:schemas-microsoft-com:office:word” /> Microsoft has announced the release of SQL Server 2008 and that means it time for another post about SQL Server Express.<?xml:namespace prefix = o ns = “urn:schemas-microsoft-com:office:office” /> The press release indicated that SQL Express is already available, but those of you who have followed the link have…


SQL Server 2008 Express RC0

It’s time for another release post, this time for RC0 of SQL Server 2008 Express and SQL Server 2008 Express with Advanced Services. Here is the information that everyone is waiting to hear about the SQL Express product line. (Note: If you’re the impatient type you can skip to the end of this post to…


SQL Server Express and Hosting

Several questions have come up lately regarding whether SQL Server Express is an appropriate product to be used in a hosting environment.  Here are the answers:   ·         User Instances (also known as RANU) available with SQL Server Express Edition, are NOT RECOMMENDED for hosting environments.   ·         Shared hosting: SQL Server Express Edition is…


Understanding SQL Express behavior: Idle time resource usage, AUTO_CLOSE and User Instances

I’ve gotten a number of questions recently asking how SQL Express uses resources during idle time, and how that behavior impacts the way SQL Express behaves “on first connection” after being idle for a period of time. While many of these questions have been related to web hosting, the behavior is a general behavior for…


SQL Express SP2 available on Microsoft Update

Just a quick not to let you know that the SP2 update for SQL Express, SQL Express with Advanced Services and SQL Express Toolkit are being published to Microsoft Update today. These are automatic updates and will apply to computers based on your Microsoft Update settings for automatic updates. (i.e. Notify, Download and Notify or…