Sales & Support

Mon-Fri 5AM-4PM PT

800-318-1439
American Flag

Owned & Operated

My Choice Software
Log In
|
0
HOLIDAY BONUS DAYS - Earn 2X Choice Rewards Points* + 15% OFF*
Code
EOY24
Exp 12/31

Exclusion Details

Microsoft SQL Server 2014 Licensing Explanation (SpiceWorks)



Welcome to the SpiceWorks SQL Server Secret page. On this page SpiceWorks users are granted the deepest discounts available on SQL server on the web. We are providing pricing at cost for SpiceWorks Users.

Overview | Licensing | Versions | Comparison | Software Assurance | Per Core Explanation | Contact
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
My Choice Software: $83999

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
My Choice Software: $3,35299

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
My Choice Software: $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
My Choice Software: $13,70999
Back to top

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.
Back to top
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.
Back to top

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.
Back to top
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.
Back to top
Feeling a little lost? Have some questions? Use the handy form below and we'll get back to you as soon as possible.


Back to top






Added To Cart

You haven't added any items to your cart.
Total $0.00

*Promotions while supplies last. Limit (1) per customer. Excludes Open Value, CSP, Bluebeam, physical & subscription products. Rewards points activate 30 days after purchase.