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…


BIDS or Bust: Writing reports in SQL Express 2008

I asked for your oppinions about a new Report Designer in one of my earlier posts in this blog. I wanted to thank everyone for taking the time to offer feedback and for those of you who even filed a bug or two. As you’ve probably already guessed from the title, our ultimate decision was…


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…


Keeping Express up to Date

Two of the tenets that were important to us as we designed SQL Server 2005 were called “Secure by Default” and “Secure by Design.” These tenets are manifest in a number of ways throughout the product. Examples in SQL Express include the fact that we install the minimum components required to get a functioning database…


Best Practice Analyzer for ASP.NET

Joe Morel, from the Developer Solutions team just blogged about the Alpha release of the ASP.NET BPA, a tool that will help users properly configure their ASP.NET sites. Those of you that build data bound ASP.NET sites know that configuring the site for data access can be particularly challenging. I encourage you to read Joe’s…


Answers to Embedded Database webcast

Asked: Can you, i.e. is it legal, to sell a product that includes the free SQL Express dB???   Answered: Absolutely, SQL Express is free to download, free to use and free to deploy, you can even sell your application that includes SQL Express. We do ask that you register for redistribution at http://www.microsoft.com/sql/editions/express/redistregister.mspx.  …


Questions from the Access to SQL Server migration webcast

  Asked: One of the most difficult tasks of the migrating process was the query upgratings. Most of them had to be all rewrited. PLease coment about queries and the sql of Access and sql of SQLServer. Answered: Access and SQL Server use different SQL dialects. When using the SQL Upsizing Wizard in Access queries…


Webcast on deploying embedded databases

Update: Q & A from the webcast is available here. I’m still working on getting the source code posted. If you missed this webcast, you can view it on demand from this page. ——————————————— I’ll be giving a webcast that describes how to deploy an embedded database using Visual Studio 2005 ClickOnce technology. The webcast…