SQL Server Express WebLog

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 Read More...

Microsoft has announced the release of SQL Server 2008 and that means it time for another post about SQL Server Express. The press release indicated that SQL Express is already available, but those of you who have followed the link have found that it Read More...

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 Read More...

Now that SQL Server 2005 SP2 has been released I thought I should make good on my promise to explain more about how we handle Windows Vista User Access Control in SQL Express SP2. I explained earlier that UAC works by removing the administrator ACEs from Read More...