Microsoft SQL Server 2022 Standard

Description

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

Option #2

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.

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.

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.Outfit your enterprise with the industry’s latest relational database management system. With the SQL server 2022 standard download, available with Software Assurance from Microsoft, get access to tools including Big Data clusters with Apache Spark and HDFS, Azure Machine Learning and Spark ML, intelligent query processing and more. Download this package here to take advantage of free installation support from Microsoft Solutions Partner, Trusted Tech Team.New to SQL Licensing? Check out our SQL Server licensing guide to find out the features that would benefit you and how to license.