Microsoft SQL Server Editions Review and Feature Comparision

There is the lot to come along with SQL Server. We have discussed some of the features of SQL Server in our earlier post. But for now what is for sure is that there are three editions of it. SQL Server will be available in three editions: Enterprise, Business Intelligence, and Standard.

Here are some details for the three editions:

sql-server-2012 image

SQL Server Enterprise edition:

Enterprise edition sits on top of the hierarchy. This edition will feature all the new services SQL Server 2012 is introducing. When it comes to licensing enterprise edition, you will only be able to purchase CPU core licensees. Enterprise edition will be useful for running business and mission-critical applications as it is loaded with all the latest improvements, some specially designed for large and complex data processing. The Enterprise Edition of SQL Server 2012 will include all the features of the BI Edition as well as the Standard edition.

SQL Server BI edition (Business Intelligence edition)

This is the latest on the stack. It has many moving parts and will include features of standard edition plus some more. There is no CPU core license available for the BI Edition. If you need a CPU license for the BI Edition, you’ll need to look to the Enterprise Edition (as it includes all the BI edition features). BI also includes the database engine as well with a slight number of cores that are supported. While the standard edition supports 16 cores for the database engine, the BI edition supports up to 20 cores for the database engine.
Some of the features BI edition will include are:

  • Data Quality Services
  • Power View
  • Master Data Services
  • Advanced Analytics
  • Semantic Model
  • Power Pivot for SharePoint Services

SQL Server Standard edition:

Standard edition is inherited from SQL server 2008 R2 and will be available in both a Server+CAL license model or a CPU Core license model. There will be considerable improvements to this edition as well compared to the standard edition of SQL Server 2008 R2. The first one is the possibility, in fact, much-expected availability of Data mirroring in the standard edition. Also, the number of cores is limited to 16 on the standard edition.

The summary of the above three edition licensing is as follows:

  • Core-based Licensing for Enterprise
  • Server + CAL (Client Access License) licensing for Business Intelligence
  • Choice of core-based licensing or Server + CAL licensing for Standard

The feature comparison is listed below on the comparison chart.

If you are looking forward to exploring more about the licensing policies, download the six pages Licensing Datasheet from Microsoft.

Posted by on , in Category General with Tags
Azharuddin Khan, being a technology enthusiastic, loves writing blogs and updating them. Currently pursuing his Bachelors in Information Technology, he also loves in extending support via providing hardware solutions.