New Kid on the Block : SQL Server 2008 Web Edition

You may have heard rumblings at a conference or user group meeting about a new SKU of SQL Server that will be shipping soon: Web Edition.  But what is it, exactly?  Some information on this edition has recently been released by Ireland Licensing, and I will try to sum it up for you here.  (There is also some brief information on the official SQL Server site.)

Basically, it has higher scalability than Express or Workgroup Editions : it supports up to 4 CPUs, no artificial limit on RAM, and unlimited database size.  They also talk about a way to automate transaction log backups to a standby server, and better support for PHP (which seems to me at least to just be a driver that could be available through all SKUs or even completely separately?  You can read more about the PHP driver for SQL Server 2005, which was just recently released, on their blog or at CodePlex).  There is also a new database publishing wizard that is probably just an overhaul of the copy database wizard in SQL Server 2005 (which has its share of problems, as many of you are aware).  This, too, I am sure will be available in most SKUs, as will policy-based management and data collection.  Just to clarify that most of the additional features they are talking about are not exclusive to Web Edition (but some will not be available on Express).

The post seems to imply that Web Edition might only be supported on Windows Server 2008 and beyond, or at least that some of the scalability enhancements will only be realized on that platform.  Maybe it's the enhanced PHP driver that is designed for Windows Server 2008?  Not sure, they are a bit sketchy on the details.

Still waiting on pricing, which should be available soon for all SKUs.  And while it makes sense, you may be sad to learn that this edition appears to only be available through service provider licensing (or volume licensing).  And like a really aggressive and unhealthy diet, there will be no CALs here.  There are also licensing restrictions against using this edition for business applications such as CRM.  I wonder how they plan to enforce that one, and how explicit the wording will be in the actual EULA.

Aaron Bertrand

I am a passionate technologist with industry experience dating back to Classic ASP and SQL Server 6.5. I am a long-time Microsoft MVP, write at SQLPerformance and MSSQLTips, and have had the honor of speaking at more conferences than I can remember. In non-tech life, I am a father of two, a huge hockey and football fan, and my pronouns are he/him. If I've helped you out, consider thanking me with a coffee. :-)

4 Responses

  1. AaronBertrand says:

    You'd be surprised how many people think that the ASP.Net user account counts as a single CAL.  I was merely differentiating that with Standard/Enterprise you can buy a 5 CAL license, throw it behind a web farm, and try to get away with it; while that licensing model is not available with Web edition from a purchase perspective as opposed to a usage perspective.

  2. Saggi Neumann says:

    CALs can't be used with internet applications, so it makes sense that there are no CALs in the web edition…

  3. AaronBertrand says:

    Thanks Euan!

  4. Euan Garden says:

    Database Publishing Wizard has nothing to do with Copy Database Wizard, it was written because CDW does not work for hosted scenarios.
    The first version was released some time ago on codeplex, then a  version was included in VS2008, this is an update to that I presume which handles new DDL etc.
    Somewhere I have the source for the prototype, it scripts DDL and then inserts so you can re-run the scripts on a hosted machine.
    -Euan