Get to know the features of SQL 2017 and prepare for SQL 2008 end of support.
How to License SQL Server Standard
Option#1
SERVER + CAL:
Provides the option to license users and/or devices, with low-cost access to incremental SQL Server deployments.
Each server running SQL Server software requires a server license.
Each user and/or device accessing a licensed SQL Server requires a SQL Server CAL that is the same version or newer - for example, to access a SQL Server 2012 Standard Edition server, a user would need a SQL Server 2012 or 2017 CAL.
Each SQL Server CAL allows access to multiple licensed SQL Servers, including Standard Edition and legacy Business Intelligence and Enterprise Edition Servers.
Option#2
PER CORE:
Gives a more precise measurement of computing power and a more consistent metric, regardless of whether solutions are deployed on physical servers on-premises, or in virtual/cloud environments.
Core based licensing is appropriate when customers are unable to count users/devices, have Internet/Extranet workloads, or have systems that integrate with external facing workloads.
To license a physical server—when running SQL Server in aphysical OSE—all physical cores on the server must be licensed.
A minimum of four core licenses are required for each physical processor on the server.
Downloadthe full Microsoft SQL Server 2017 Licensing guide
SQL Server Features: Standard vs. Enterprise
SQL Server 2017 Features
Standard
Enterprise
Scale
Maximum number of cores
24 Cores
OS Max
Maximum buffer pool size per instance
128 GB
OS Max
Maximum Columnstore segment cache per instance
32 GB
OS Max
Maximum memory-optimized data per database
32 GB
OS Max
Maximum database size
524 PB
524 PB
Production use rights
Unlimited virtualization (benefit of Software Assurance)
Programmability
Programmability and developer tools: T-SQL, SQL CLR, Service Broker, JSON, XML, graph data support
Access to Power BI Report Server (benefit of Software Assurance)
Advanced Analytics
Connectivity to open source Python and R, limited parallelism
Full parallelism of R and Python analytics and the ability to run on GPUs
Machine Learning for Hadoop/Spark and Machine Learning for Linux, a software assurance benefit
Hybrid Cloud
Stretch Database
EIT Ware has full licensing experts available to assist you in purchasing the correct licensing model for your needs. This is a digital download product that will be sent directly to your inbox. Whether you are upgrading your 2008, 2012, 2014 or 2016 edition, thisSQL Server 2017 downloadwill provide you with all database tools to improve your data and store it securely. Advanced SQL queries have never been easier with a new feature implemented in the most recent version called automatic database tuning - which will work towards improving notifying query performance problems, and will also recommend solutions for you. Contact us at and we will be happy to get you taken care of!
FAQ
What do I get with my purchase?
You receive a product key, download link and install instructions.
How do I get the download?
Most products are delivered digitally via email within 30 minutes of purchase.
What if I need help?
We provide installation support free with all purchases. Just reach out if you need help, we're here!