IntroductionMicrosoft SQL Server 2012 is Microsoft's first cloud-ready information platform. It gives organizations effective tools to protect, unlock, and scale the power of their data, and it works across a variety of devices and data sources, from desktops, phones, and tablets, to datacenters and both private and public clouds.SQL Server 2012 that allow you to greatly enhance performance and
availability at a low total cost of ownership, unlock new insights with pervasive data discovery across the organization and create business solutions fast—on your terms.
I will briefly explain the about each Editions of SQL Server 2012 in my blog
Editions of SQL Server 2012
SQL Server 2012 is obtainable in three main editions. All three editions have tighter alignment than
their predecessors and were designed to meet the needs of almost any customer with an increased
investment in business intelligence. Each edition comes in a 32-bit and 64-bit version. The main
editions,
are as following:
- Standard edition
- Business Intelligence edition
- Enterprise edition
let us see short description about each edition
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; however, it continues to offer best-in-class manageability and ease of use. Compared to the Enterprise and Business Intelligence editions, the Standard edition supports up to 16 cores and includes the following:
- Spatial support
- FileTable
- Policy-based management
- Corporate business intelligence
- Reporting
- Analytics
- Multidimensional BI semantic model
- Basic high availability can be achieved with AlwaysOn 2-Node Failover Clustering
- Up to four processors, up to 64 GB of RAM, one virtual machine, and two failover clustering
nodes
Business Intelligence Edition
For the first time in the history of SQL Server, a Business Intelligence edition is offered. 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 trying to achieve corporate business intelligence and self-service capabilities, but that do not require the full online transactional processing (OLTP) performance and scalability found in the Enterprise edition of SQL Server 2012. Here is a high-level list of what the new 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
Enterprise Edition
The Enterprise edition of SQL Server 2012 is the uppermost SKU; it is meant to meet the highest demands of large-scale datacenters and data warehouse solutions by providing mission-critical performance and availability for Tier 1 applications, the ability to deploy private-cloud, highly virtualized environments, and large centralized or external-facing business-intelligence solutions.
The Enterprise edition features include the following:
- Maximum number of cores is subject to the operating system being used
- Advanced high availability can be achieved with AlwaysOn
- Unlimited virtualization if the organization has software insurance
- Support for the new columnstore indexing feature
- Advanced auditing
- Transparent Data Encryption (TDE)
- Compression and partitioning
- Includes all of the Business Intelligence edition's features and capabilities:
- Reporting
- Analytics
- Multidimensional BI semantic model
- Data-quality services
- Master data services
- In-memory tabular BI semantic model
- Self-service business intelligence
so above all the editions the sql serever 2012 is better than preveious versions.so use it and enhance your performance i hope this blog is useful for readers.If you have any suggestion regarding this article then please contact me i will improve it
References