36
Part I: Laying the Foundations
■ (^) Enterprise Edition: SQL Server 2012 Enterprise Edition provides the highest level
of scalability for large mission-critical application workloads. It provides sup-
port for the highest amount of memory and number of processors than any other
edition to support an organization’s entire consolidated and virtualized database
infrastructure. Enterprise Edition includes several powerful tools for complex data
analytics, large data warehouses, and end-to-end Business Intelligence solutions.
■ (^) Standard Edition: SQL Server 2012 Standard Edition is tailored for small to mid-
sized organizations, capable of providing reliable data management and essential
Business Intelligence capabilities.
■ Parallel Data Warehouse: SQL Server 2012 Parallel Data Warehouse is a highly
scalable appliance-based data warehouse solution. Parallel Data Warehouse pro-
vides cost-effective performance through a massively parallel processing (MPP)
architecture that enables an organization to easily scale from terabytes of data to a
petabyte range of data.
■ (^) Web Edition: SQL Server 2012 Web Edition is a cost-effective database solution to
support web applications, websites, and web services. It is only available through
hosting providers such as Amazon and Rackspace.
■ Developer Edition: SQL Server 2012 Developer Edition includes all the functional-
ity of Enterprise Edition for development, test, and demonstration purposes. It is
not intended for production environments. You can purchase Developer Edition
licenses for approximately $50. It is the most cost-effective way for developers to
develop and test all the features available in SQL Server 2012.
■ (^) Evaluation Edition: SQL Server 2012 Evaluation Edition is a free 180-day trial
license of SQL Server 2012 with all the functionality of Enterprise Edition. You can
download the 180-day Evaluation Edition of SQL Server 2012 at http://www.microsoft
.com/sqlserver/en/us/get-sql-server/try-it.aspx.
■ (^) Express Edition: SQL Server 2012 Express Edition is a free redistributable edi-
tion ideal for learning, managing, and developing small database applications. SQL
Server 2012 Express Edition is limited to 10GB of storage per database.
■ Express LocalDB Edition: SQL Server 2012 Express LocalDBEdition is a new, free,
lightweight version of Express Edition that has a fast zero confi guration installa-
tion and fewer prerequisites. It runs in user mode and includes all features found in
Express Edition.
■ Compact Edition: SQL Server 2012 Compact Edition is a free redistributable edition
that can be embedded in mobile devices, desktops, and web clients.
Downgrading Later
A good SQL Server 2012 deployment plan eliminates the possibility of having to undo, redo,
or make major changes to the confi guration of a SQL Server installation. It some cases, you
may be forced to change an existing installation to a different edition or version of SQL
Server.
c03.indd 36c03.indd 36 7/30/2012 4:09:59 PM7/30/2012 4:09:59 PM
http://www.it-ebooks.info