Mindmajix

SQL Server 2014 editions

Similar to the previous version, SQL Server 2014 is available in three principal editions. All three editions have tighter alignment than their predecessors and were designed to meet the needs of almost any customer. Each edition comes in a 32-bit and 64-bit version. The principal editions, as predecessors and were designed to meet the needs of almost any customer. Each edition comes in a 32-bit and 64-bit version. The principal editions, as shown in Figure , are the following:

  • Enterprise edition
  • Standard edition
  • Business Intelligence edition

Screenshot_17

The main editions of SQL Server 2014.

Enterprise edition

The Enterprise edition of SQL Server 2014 is the uppermost SKU and is considered the premium offering. It is designed to meet the highest demands of large-scale data centers and data warehouse solutions by providing mission-critical performance and availability for tier 1 applications and the ability to deploy private-cloud, highly virtualized environments and large, centralized, or external-facing business-intelligence solutions.

Note The Datacenter edition included in the previous version of SQL Server is now retired. However, all capabilities of the Datacenter edition are in the Enterprise edition of SQL Server 2014.

The Enterprise edition features include the following:

  • A maximum number of cores, subject to the operating system being used
  • Unlimited virtualization
  • AlwaysOn to achieve advanced high availability
  • Unlimited virtualization for organizations with software assurance
  • Support for the new columnstore indexing feature
  • Advanced auditing
  • Transparent data encryption
  • Compression and partitioning
  • In addition, all the features and capabilities of the Business Intelligence edition are available, including:
  • Reporting Analytics
  • Multidimensional BI semantic model
  • Data quality services
  • Master data services
  • In-memory tabular BI semantic model
  • Self-service business intelligence

Standard edition The Standard edition is a data-management platform tailored toward departmental databases and limited business-intelligence applications that are typically appropriate for medium-class solutions, smaller organizations, or departmental solutions. It does not include all the bells and whistles of the Enterprise and Business Intelligence editions, although it continues to offer best-in-class manageability and ease of use. Compared with the Enterprise and Business Intelligence editions, the Standard edition supports up to 16 cores and includes the following features:

  • Spatial support
  • FileTable
  • Policy-based management
  • Corporate business intelligence
  • Reporting
  • Analytics
  • Multidimensional BI semantic model
  • AlwaysOn 2-Node failover clustering to achieve basic high availability
  • Up to four processors, up to 64 GB of RAM, one virtual machine, and two failover clustering nodes

Business Intelligence edition

The Business Intelligence edition offers organizations the full suite of powerful BI capabilities, such as scalable reporting and analytics, Power View, and PowerPivot. It is tailored toward organizations that need corporate business intelligence and self-service capabilities but do not require the full online transactional processing (OLTP) performance and scalability found in the Enterprise edition. Here is a high-level list of what the Business Intelligence edition includes:

  • Up to a maximum of 16 cores for the Database Engine
  • Maximum number of cores for business-intelligence processing
  • All of the features found in the Standard edition
  • Corporate business intelligence
  • Reporting
  • Analytics
  • Multidimensional BI semantic model
  • Self-service capabilities
  • Alerting
  • Power View
  • PowerPivot for SharePoint Server
  • Enterprise data management
  • Data quality services
  • Master data services
  • In-memory tabular BI semantic model
  • Basic high availability can be achieved with AlwaysOn 2-Node failover clustering Specialized editions

 

Specialized editions

Above and beyond the three principal editions of SQL Server 2014, Microsoft continues to deliver specialized editions for organizations that have a unique set of requirements. Some examples include the following:

Developer

The Developer edition includes all the features and functionality found in the Enterprise edition; however, it is meant strictly for the purpose of development, testing, and demonstration. Note that you can transition a SQL Server Developer installation directly to production (without reinstallation) by upgrading it to SQL Server 2014 Enterprise.

Web

Available at a much more affordable price than the Enterprise and Standard editions, the SQL Server 2014 Web edition is focused on service providers hosting Internet-facing webservices environments. Unlike the Express edition, this edition doesn’t have database size restrictions, it supports four processors, and supports up to 64 GB of memory. SQL Server 2014 Web edition does not offer the same premium features found in the Enterprise and Standard editions, but it still remains the ideal platform for hosting websites and web applications.

 Express

This free edition is the best entry-level alternative for independent software vendors, nonprofessional developers, and hobbyists building client applications. Individuals learning about databases or learning how to build client applications will find that this edition meets all their needs. In a nutshell, this edition is limited to one processor and 1 GB of memory, and it can have a maximum database size of 10 GB. Also, Express is integrated with Microsoft Visual Studio.

Note: To compare the different editions of SQL Server 2014 based on their key capabilities, review “Features Supported by the Editions of SQL Server 2014” at http://msdn.microsoft.com/en-us/library/cc645993(v=sql.120).aspx and http://msdn.microsoft.com/en-us/library/ms144275(v=sql.120).aspx .


 

0 Responses on SQL Server 2014 editions"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.