*Microsoft Software Licensing terms require a minimum of 4 cores to be licensed with the core model*
Secure Your Data With SQL Server
Query and analyze your data using industry-leading performance and security.
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 2017 Standard Edition server, a user would need a SQL Server 2017, 2019, or 2022 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
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.
SQL Server Features: Standard vs. Enterprise
| SQL Server 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 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 | ||||
| Support for SQL Server Java extension | ||||
| Industry-leading performance and availability | Free DR replicas in Azure and on-premises | |||
| Intelligent Query processing: Scalar UDF inlining, table variable deferred compilation, approximate count distinct | ||||
| Intelligent Query processing features: row mode memory grant feedback, batch mode for row store and automatic tuning | ||||
| Automatic read-write connection re-routing | ||||
| In-Memory Database: memory-optimized tempdb | ||||
| In-Memory Database: Persistent Memory support | ||||
| Accelerated Database recovery | ||||
| Support for Kubernetes deployment | ||||
| Secure and reliable | Always Encrypted with secure enclaves | |||
| Transparent database encryption | ||||
| Data classification and auditing | ||||
| Vulnerability assessment | ||||
| Quick business insights | Azure Data Studio to manage SQL Server including support for T-SQL using Notebooks | |||
| SQL Server Analysis Services Direct Query | ||||
Microsoft SQL Server has been one of the premier leaders in database technology for years.
Store and retrieve data with the powerful and intuitive Microsoft SQL Server Standard. Available here as a two-core license with Software Assurance from Microsoft, this software package is an excellent investment for those looking to expand their business on the server side. (Note that Microsoft software licensing terms require a minimum of four cores to be licensed with the core model.) Order here at Trusted Tech Team to take advantage of free installation support from a Microsoft Cloud Solutions Partner.
New to SQL Licensing? Check out our SQL Server licensing guide to find out the features that would benefit you and how to license.
Related products
Uncategorized
Uncategorized
Uncategorized
Uncategorized
Uncategorized
Uncategorized
Uncategorized