Microsoft SQL Server 2014 Licensing Explanation

Type "sql server 2014" into our search, or bookmark this page to return to it in the future. If you require support please call 800-318-1439, or email support@mychoicesoftware.com.

SQL Server 2014 enables high-performance, in-memory security technology across OLTP, data warehousing, BI and analytics workloads for up to 30x faster transactions and 100x query performance gains. Use SQL Server 2014 for enhanced high availability with up to eight readable secondaries, greater security and scalability, and hybrid backup and disaster recovery across on-premises and cloud.

Microsoft SQL Server licensing made simple.

Standard

The most affordable way to get sql, this option is great for small (1 – 30) users or devices.

Requirements:
  • 1 users CAL for each user in the organization that accesses the information
  • 1 device CAL for each server accessing the system outside of the host system
Microsoft Store: $93100
Your price: $82999

Standard 2 Core

Microsoft SQL 2 Core license comes with unlimited users and can be enhanced by speeding up storage and memory. Cost effective when you have more than 31 users on a system.

Requirements:
  • Minimum purchase of 2 licenses, each covering 2 cores for a total of 4
Microsoft Store: $3,71700
Your price: $3,35299
Purchase Purchase

Business Intelligence

Business Intelligence edition comes with the full suite of analytical tools to get the most out of your data. Business intelligence licenses are typically bolted on to existing database farms and licensing is by user and device not by Core.

Requirements:
  • 1 users CAL for each user in the organization that access’s the information
  • 1 device CAL for each server accessing the system outside of the host system
Microsoft Store: $8,90800
Your price: $7,55999

Enterprise 2 Core

Microsoft SQL Enterprise 2 Core license comes with unlimited users and can be enhanced by speeding up storage and memory.

Requirements:
  • Minimum purchase of 2 licenses, each covering 2 cores for a total of 4
Microsoft Store: $14,25600
Your price: $13,70999
Purchase Purchase

Standard

SQL Server Standard provides core data management and business intelligence capabilities for non-critical workloads with minimal IT resources.

Enterprise

SQL Server Enterprise delivers comprehensive high-end datacenter capabilities for demanding database and business intelligence requirements.

Business Intelligence

SQL Server Business Intelligence empowers organizations to build and deploy secure, scalable and manageable self-service corporate BI solutions.

Features Enterprise Business Intelligence Standard
Maximum number of cores OS Max 16 cores-DBOS Max-AS&RS2 16 cores
Maximum memory utilized per instance OS Max 128 GB 128 GB
Maximum size 524 PB 524 PB 524 PB
Programmability (T-SQL, data types, FileTable)
SQL Server Management Studio
Policy-based management
Basic OLTP
Basic security (Separation of duties, basic auditing)
Basic high availability3
Built-in data connectors
Basic data integration (SSIS, designer transforms)
Basic reporting4
Basic corporate BI (Analytics, multidimensional semantic model, data mining)
Self-service business intelligence (Alerting, Power View, Power Pivot for SharePoint Server)
Advanced corporate BI (Tabular BI semantic model, advanced analytics and reporting, in-memory analytics engine, advanced data mining)
Enterprise data management (Data Quality Services, Master Data Services)
Advanced data integration (Fuzzy grouping and lookup, change data capture)
Advanced security (SQL Server audit, transparent data encryption)
Data warehousing (In-memory columnstore, compression, partitioning)
Advanced high availability (AlwaysOn, multiple, active secondaries; multi-site, geo-clustering)
Advanced transaction processing (In-memory OLTP)
1 Specifications are for SQL Server Express core.
2 Analysis Services & Reporting Services.
3 Basic includes log shipping, database mirroring, Windows Server Core support and two-node Failover Clustering.
4 Basic reporting is available in Express with Advanced Services.


Software assurance in the Microsoft realm has always meant buy the next version for half off with purchase of a current version license and the software assurance licensing at once time. In SQL it holds a special meaning as well, it allows users to receive Microsoft support on their SQL server installations as well as granting audit data base server abilities. Software Assurance must be purchases within 90 days of your original open license purchase and grants 2 years of upgrades as well as standard support.

SQL Server Core Factor Table*  
Processor Type Core Factor
All processors not mentioned below 1
AMD Processors 31XX, 32XX, 33XX, 41XX, 42XX, 43XX, 61XX, 62XX, 63XX Series Processors with 6 or more cores 0.75
Single-Core Processors 4
Dual-Core Processors 2
* This is an example of how to calculate core license requirements and the core factor table. The core factor table is subject to change.

Feeling a little lost? Have some questions? Call us at 800-318-1439 (between 6am and 5pm PT), or use the handy form below and we'll get back to you as soon as possible.