Insufficient data from Andrew Fryer

The place where I page to when my brain is full up of stuff about the Microsoft platform

SQL Server 2008 editions

SQL Server 2008 editions

  • Comments 2
  • Likes

One of the things I think is odd about Microsoft is the hard line placed between developers and IT Professionals as each discipline needs to understand the other to a certain extent and also in smaller organisations one person ends up doing both roles.

So I was pleased to be asked to a NxtGen (A developer user group)  meeting in Coventry to take part in their mini launch of the Windows / SQL Server / Visual Studio 2008. As you can see they even went to the trouble of handing out chocolate (even though I am not a dementor) for the occasion.


There were a  a couple of questions in my session were about what is in each edition of SQL Server 2008. There is one page on the SQL Server 2008 site for this here

And to answer the specific questions, Resource Governor, Transparent Data Encryption and Compression (both for the database and backups) are only in enterprise edition.  One other thing I didn’t mention was that enterprise edition is licensed for unlimited virtualisation, so you license the physical server and then you can run as many virtual machines on it as you need.

  • dude, that was it? darn, i thought you were going to give a summarized explanation about what each edition is capable of. Microsoft's website is always speaking in technical jargon that sometimes it's hard to get what you need and fast.

    I'm hoping Apple gets into the server business. Maybe things will become easier. (just my opinion) ^_^

  • Oliver

    The editions are really simple:

    Express -  free and basic,

    Standard  - small and medium business

    Enterprise  - for enterprise sized businesses.

    if we only had one edition it would be massive overkill in size and complexity for a small business and you would rightly accuse us of bloat, or it wouldn't be massively scalable in the data centre.

    My only comment about Apple would be they have been around as long as we have, and you could reasonably argue Linux is a sevrer based OS.


Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment