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

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.

DSCN9785

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.