Editions of SQL Server 2012

The edition layout of SQL Server has changed again with this release to align closer with the way organizations use the product. Following are three main editions:

  • Enterprise: This edition focused on mission critical applications and data warehousing.
  • Business intelligence: This new edition has premium corporate features and self-service business intelligence features. If your environment is truly mission critical however, this may be missing some key features you might want. The key is to leverage this edition on your BI servers and use Enterprise where needed.
  • Standard: This edition remains to support basic database capabilities including reporting and analytics.

You may wonder about the previous editions and how to move from what you have to the new plan. Following is a breakdown of deprecated editions and where the features now reside.

  • Datacenter: Its features are now available in Enterprise Edition.
  • Workgroup: Standard will become your edition for basic database needs.
  • Standard for small business: Standard becomes your sole edition for basic database needs.

Get Microsoft SQL Server 2012 Bible now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.