SQL Server Licensing Guide: Everything You Need to Know

Overview

SQL Server 2019 (15.x) builds on previous releases to grow SQL Server as a platform that gives you choices of development languages, data types, on-premises or cloud environments, and operating systems. Find out what’s new in SQL 2019.

SQL Server Licensing

Versions

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 datacenter capabilities for mission-critical database, business intelligence, and advanced analytics workloads.

What's New for 2019

  • Big Data Clusters – Deploy scalable clusters of SQL Server, Spark, and HDFS containers running on Kubernetes
  • Data virtualization with PolyBase – Query data from external SQL Server, Oracle, Teradata, MongoDB, and ODBC data sources with external tables, now with UTF-8 encoding support
  • Intelligent Database – Intelligent Query Processing improves performance and scalability of all your database workloads without any changes to your application or database design
  • Support for persistent memory (PMEM) devices
  • In-Memory Database technologies that leverage modern hardware innovation to deliver unparalleled performance and scale
  • Monitoring improvements unlock performance insights over any database workload, just when you need them
  • Enhancements to graph and spatial data types, UTF-8 support, and a new extensibility framework that allows developers to use the language of their choice to gain insights across all their data
  • Unicode support – Support businesses across different countries and regions
  • New Java language SDK – Simplifies the development of Java programs that can be run from SQL Server
  • Language Extensions – Execute external code with the extensibility framework
  • Expands upon Always Encrypted with in-place encryption and rich computations by enabling computations on plaintext data inside a server-side secure enclave
  • Vulnerability assessment to track compliance of SQL Server instances and Azure SQL Database instances with recognized security best practices

Standard

Enterprise

Mission critical performance
  • Disk-based OLTP
  • 24 cores max and 128 GB max memory
  • 2-node single database failover (non-readable secondary)
  • Query Store
  • Temporal
  • Operating system max cores and memory
  • Enhanced in-memory
  • OLTP performance
  • Operational analytics
  • Enhanced AlwaysOn with no domain join (WS 2016)
  • Query Store
  • Temporal
Security
  • Row-level security
  • Dynamic data masking
  • Basic auditing
  • Separation of duties
  • Policy-based management
  • Always Encrypted
  • Row-level security
  • Dynamic data masking
  • Enhanced separation of duties
  • Enhanced SQL Server auditing
  • Transparent data encryption
  • Policy-based management
Data ware-housing
  • PolyBase (compute node only)
  • Support for JSON
  • Enhanced in-memory ColumnStore
  • PolyBase in scale-out configuration (head and compute nodes)
  • Deployment rights for APS
  • Distributed query processing
  • Support for JSON
Business intelligence
  • Basic tabular (16GB memory per instance)
  • Web portal experience
  • Modernized reports
  • Pin reports to Power BI
  • Enhanced multidimensional models
  • End-to-end mobile BI on all major platforms
  • Enhanced direct query
  • In-memory analytics
  • Advanced data mining
  • Advanced tabular
  • Web portal experience (all reports in one place)
  • Modernized reports
  • Pin reports to Power BI
  • Enhanced multidimensional models
Advanced analytics
  • Single-threaded for RRE
  • Connectivity to R Open
  • In database advanced analytics
  • R integration with massive parallel processing for performance and scale
  • Works with in-memory technology
  • Run in database or standalone
  • Connectivity to R Open
Hybrid cloud
  • Stretch Database
  • Backup to Azure
  • Stretch Database
  • Enhanced backup to Azure
  • Enhanced HA and DR with Azure – ease of use, no domain join (Windows Server 2016)
  • SSIS integration with Azure Data Factory and Azure SQL Data

Standard

Standard

Enterprise

Maximum number of cores

24 Cores

Unlimited

Mission critical performance
Maximum number of cores

128 GB

OS Mac

Maximum size

524 PB

524 PB

Basic OLTP

Manageability (Management Studio, Policy-Based Management)

Basic high availability (2-node single database failover, non-readable secondary)

Enterprise data management (Master Data Services, Data Quality Services)

Advanced OLTP (In-memory OLTP, Operational analytics)

Advanced HA (Always On – multi-node, multi-db failover, readable secondaries)
Security
Data ware-housing
Business intelligence
Advanced analytics
Hybrid cloud

Features

Standard

Enterprise

Mission critical
performance

Maximum number of cores

Maximum memory utilized per instance

Maximum size

Basic OLTP

Manageability (Management Studio, Policy-Based Management)

Basic high availability (2-node single database failover, non-readable secondary)

Enterprise data management (Master Data Services, Data Quality Services)

Advanced OLTP (In-memory OLTP, Operational analytics)

Advanced HA (Always On – multi-node, multi-db failover, readable secondaries)

24 cores

128 GB

524 PB

Unlimited

OS Max

524 PB

  • Row-level security
  • Dynamic data masking
  • Basic auditing
  • Separation of duties
  • Policy-based management
  • Always Encrypted
  • Row-level security
  • Dynamic data masking
  • Enhanced separation of duties
  • Enhanced SQL Server auditing
  • Transparent data encryption
  • Policy-based management
  • PolyBase (compute node only)
  • Support for JSON
  • Enhanced in-memory ColumnStore
  • PolyBase in scale-out configuration (head and compute nodes)
  • Deployment rights for APS
  • Distributed query processing
  • Support for JSON
  • Basic tabular (16GB memory per instance)
  • Web portal experience
  • Modernized reports
  • Pin reports to Power BI
  • Enhanced multidimensional models
  • End-to-end mobile BI on all major platforms
  • Enhanced direct query
  • In-memory analytics
  • Advanced data mining
  • Advanced tabular
  • Web portal experience (all reports in one place)
  • Modernized reports
  • Pin reports to Power BI
  • Enhanced multidimensional models
  • Single-threaded for RRE
  • Connectivity to R Open
  • In database advanced analytics
  • R integration with massive parallel processing for performance and scale
  • Works with in-memory technology
  • Run in database or standalone
  • Connectivity to R Open
  • Stretch Database
  • Backup to Azure
  • Stretch Database
  • Enhanced backup to Azure
  • Enhanced HA and DR with Azure – ease of use, no domain join (Windows Server 2016)
  • SSIS integration with Azure Data Factory and Azure SQL Data

Get the most from your Office

Enhancements that help you create & communicate– Work from just about anywhere.

Office for PC
Office for Mac

Microsoft 365 plans include the complete suite of Office applications, plus other services that are enabled over the Internet, including extra cloud storage with OneDrive and Skype minutes for home use. With Microsoft 365 you get the full, installed Office experience on PCs, Macs, tablets (including Windows, iPad, and Android) and smartphones. Microsoft 365 plans are available as a monthly or annual subscription and include 5 device installs. With Office 365, upgrades are always included with your subscription.

Office 2019 suites, including Office Home & Student and Home & Business, include applications such as Word, Excel, PowerPoint, and OneNote; they are available as a one-time purchase for use on a single PC or Mac. The applications are not automatically updated; to get the latest version, you must purchase Office again when the new version becomes available.

Compatibility
Product Does not work with
Office 2016 (HS/HB/PRO) Visio 2013/2019/365 or Project 2013/2019/365
Visio 2016 (Standard and Professional) Office 2013/2019/365 or Project 2013/2019/365
Project 2016 (Standard and Professional) Office 2013/2019/365 or Visio 2013/2019/365

Microsoft Office and Microsoft 365 give you access to the programs you need to work, play, and stay connected. From the power to create documents and presentations, to the ability to design database apps and stay in touch via email, Office simplifies the way you work online, and off.

What you might not realize, is that Office comes in a variety of versions designed for different needs, uses and computers. But before you buy, let’s compare Microsoft Office versions so you can choose the right software for all the things you do.

Microsoft 365 Apps for Business: Designed for use on up to 5 PCs or Macs, as well as 5 tablets – including iPad, Android, or Windows, and 5 phones. In the package, you’ll receive access to Word, Excel, OneNote, PowerPoint, Outlook, Publisher and Access. In addition, you’ll automatically receive the latest Office updates (including Office 2019), and get 1TB of OneDrive cloud storage, free Microsoft Answer Desk support and 60 minutes of Skype calling per month.

Microsoft 365 Personal: When you compare Office versions, Microsoft 365 Personal gives you all the same great features you’ll find in Microsoft 365 Business, but on just one PC or Mac and one tablet device, instead of up to five of each.

Office 2019 Home & Student: Microsoft Office 2019 features new, modern versions of Word, Excel, PowerPoint, and OneNote that are designed to help maximize your productivity and give you rich authoring features, design controls for pixel-perfect layouts and intuitive tools to help you make the most of your data. Plus, because you’ll have access to your docs in the cloud whenever you need them, you can work when, how and where it suits you best. And for those times when collaboration is critical, you can even share documents and get your team on the same page. (Designed for use on one PC.)

Office 2019 Home & Business: With the same great features as Office 2019 Home & Student, as well as Outlook, Office 2019 Home & Business gives you everything you need to get more done — and stay connected with friends, family and colleagues around the globe.

Office 2019 Professional: Now you can do your best work – anywhere, anytime and with anyone. In addition to the 2019 versions of Word, Excel, PowerPoint, Outlook, and OneNote, Office 2019 Professional includes new iterations of Publisher and Access, which can help increase your productivity so you can do more in less time. Best of all, with your documents stored online, collaborating with teams around the world is easy.

In general, when you compare Office vs. Microsoft 365, the most important thing to note is that Microsoft 365 is always up to date, so you’ll never have to purchase upgrades or wonder if you’re using the most recent version.

[1] Microsoft 365 is compatible with Windows 7 or later, and Mac OS X 10.10. Application availability and features that come with Microsoft 365 vary by platform and device; current Office application versions for Microsoft 365 are Office 2019 for Windows and Office 2019 for Mac. Visit www.office.com/information for full system requirements, including compatible tablets and smartphones for Microsoft 365.

[2] Available on PC only.

[3] Skype available only in select countries; see FAQ for details. Calling to select countries only. Excludes calling to special, premium and non-geographic numbers.