Skip Ribbon Commands Skip to main content

​SQL Server 2012

 

The SQL Server 2012 release will simplify your options with three main editions that are closely aligned with how you use SQL Server across workloads. SQL Server 2012 will also deliver licensing which enables you to more easily take advantage of the benefits of public and private cloud through virtualization and license mobility.

 
Simplified Licensing
SQL Server 2012 will offer two licensing options – one that is based on computing power, and one that is based on users or devices (see table below for the mapping of the new licensing options per edition).
  
Flexibility and Innovation
Cloud-optimized licensing with the ability to license a single Virtual Machine (VM) or license a server for maximum virtualization as well as the flexibility to move your VMs from server to server, or to hosters or the cloud.
 
Industry-leading TCO
We continue to provide outstanding value at any scale among all major vendors. SQL Server 2012 will offer compelling product features and capabilities within three main editions with no costly add-ons required to run your Mission Critical and Business Intelligence applications.

 
SQL Server 2012 Editions
Three main editions, namely Enterprise, Business Intelligence and Standard, will be available:
• Enterprise for mission critical applications and data warehousing
• Business Intelligence (new) for premium corporate and self-service Business Intelligence capabilities
• Standard for basic database capabilities, reporting and analytics

 

The Business Intelligence edition will include all of the Standard Edition’s capabilities, and Enterprise will include all of the Business Intelligence Edition’s capabilities.
 
With the release of SQL Server 2012, the following three editions will be retired:
• Datacenter – its features will now be available in Enterprise Edition
• Workgroup – Standard will become our edition for basic database needs
• Standard for Small Business – Standard becomes the sole edition for basic database needs
  
Key licensing changes with SQL Server 2012
With SQL Server 2012, we will offer the following licensing options:
• Core-based Licensing for Enterprise
• Server + CAL licensing for Business Intelligence
• Choice of core-based licensing or Server + CAL licensing for Standard
  
The table below shows a feature comparison among the three main editions.
 
SQL SERVER 2012 CAPABILITIES​ Enterprise​ Business Intelligence​ Standard
Maximum Number of Cores​ OS Max*​ 16 Cores-DB OS Max-BI​ 16 Cores ​
Basic OLTP​ x​ x​ x​
Programmability (T-SQL, Spatial Support, FileTable)​ x​ x​ x​
Manageability (SQL Server Management Studio, Policy-based Management) ​ x​ x​ x​
Corporate Business Intelligence (Reporting, Analytics, Alerting, Multidimensional BI Semantic Model)​ x​ x​ x​
Enterprise data management (Data Quality Services, Master Data Services)​ x​ x​
Self-Service Business Intelligence (Power View, PowerPivot for SPS)​ x​ x​
In-Memory Tabular BI Semantic Mode​ x​ x​
Advanced Security (Advanced auditing, transparent data encryption)​ x​
Data Warehousing (ColumnStore, compression, partitioning)​ x​
High availability (AlwaysOn)​ Advanced Basic**​ ​Basic**
  
*SQL Server 2012 Enterprise Edition server licenses - whether newly purchased or upgraded with Software Assurance - will be subject to a 20 core per server license maximum.
**Basic includes 2 node Failover Clustering.
 
Contact a software licensing expert today!
Phone: 1-800-444-9890
Email: sales@softwareone.com