Microsoft® SQL Server® 2012 Bible

35

Chapter 3: Installing SQL Server

3

Data Center Edition and Workgroup Edition are no longer available in SQL Server 2012. Web Edition is only available

through hosting providers such as Amazon Web Services and Rackspace.

The core editions of SQL Server 2012 are the three main editions that can be licensed for

production, testing, Q.A., and U.A.T. environments.

Core editions is a categorization of the three main editions and must not be confused with Server Core installations.

New in SQL Server 2012, you can install SQL Server on Windows Server 2008 R2 SP1 Server Core. For more informa-

tion on SQL Server 2012 installations on Windows Server Core please refer to http://msdn.microsoft.com/

en-us/library/hh231669.aspx

The Developer Edition of SQL Server 2012 is a specialized license intended for development

purposes only and cannot be used in production environments. The free editions of SQL

Server 2012 are light-weight versions of SQL Server intended for learning, developing, and

redistributing with small applications.

With each new release of SQL Server, new features are introduced and some existing

features get shuffl ed around between editions. Understanding the available features for

each edition is key in deploying the right edition that suits your needs. For a complete list

of features supported by each edition please refer to http://msdn.microsoft.com/

en-us/library/cc645993(v=SQL.110).aspx.

In SQL Server 2012, additional features have been added to support highly scalable and

highly available database environments as well as additional tools to support Enterprise

Information Management. Some of these new features include the following:

■ (^) Column-store indexes
■ Always-on Availability Groups
■ (^) Distributed Replay
■ Data Quality Services
■ (^) Analysis Services xVelocity Engine (formerly known as Vertipaq)
■ Windows Server Core Installation Support
Edition Differences
Several differences exist between SQL Server 2012 editions ranging from database size
limitations to the number of supported processors and the maximum supported memory.
Several features such as partitioning, encryption, compression, and some advanced index-
ing options are also a key difference between SQL Server 2012 editions.
c03.indd 35c03.indd 35 7/30/2012 4:09:58 PM7/30/2012 4:09:58 PM
http://www.it-ebooks.info