Description
Secure Your Data With SQL Server 2019 Query and analyze your data using industry-leading performance and security. Download the infographic 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 2019 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 a physical 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. Download the full Microsoft SQL Server 2019 Licensing guide SQL Server Features: Standard vs. Enterprise SQL Server 2019 New Features Standard Enterprise Compute and storage Maximum number of cores 24 OS Max Maximum memory utilized per instance 128 GB OS Max Maximum size 524 PB 524 PB Intelligence over all your data SQL Server 2019 Big Data Clusters with Apache Spark and HDFS built into SQL Server engine Data virtualization using PolyBase (including additional data sources like Oracle, Teradata, MongoDB, and other SQL Server databases) Unified AI platform to train and operationalize models with SQL Server ML Services Azure Machine Learning and Spark ML Choice of language and platform Compatibility certfication UTF-8 Support
