This product refers to CAL service (Client Access License) to be able to grant users and devices the right to access Microsoft server software installed on a machine. SQL Server 2022 (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. SQL Server 2022 features: SQL Server Database Engine. SQL Server Database Engine includes the Database Engine, the core service for storing, processing, and securing data, replication, full-text search, tools for managing relational and XML data, in database analytics integration, and PolyBase integration for access to heterogeneous data sources, and Machine Learning Services to run Python and R scripts with relational data. Analysis Services. Analysis Services includes the tools for creating and managing online analytical processing (OLAP) and data mining applications. Reporting Services. Reporting Services includes server and client components for creating, managing, and deploying tabular, matrix, graphical, and free-form reports. Reporting Services is also an extensible platform that you can use to develop report applications. Integration Services. Integration Services is a set of graphical tools and programmable objects for moving, copying, and transforming data. It also includes the Data Quality Services (DQS) component for Integration Services. Master Data Services. Master Data Services (MDS) is the SQL Server solution for master data management. MDS can be configured to manage any domain (products, customers, accounts) and includes hierarchies, granular security, transactions, data versioning, and business rules, as well as an Add-in for Excel that can be used to manage data. Machine Learning Services (In-Database). Machine Learning Services (In-Database) supports distributed, scalable machine learning solutions using enterprise data sources. In SQL Server 2016, the R language was supported. SQL Server 2022 (16.x) supports R and Python. Data Virtualization with PolyBase. Query different types of data on different types of data sources from SQL Server. Azure connected services. SQL Server 2022 (16.x) extends Azure connected services and features including Azure Synapse Link, Microsoft Purview access policies, Azure extension for SQL Server, pay-as-you-go billing, and the link feature for SQL Managed Instance. The following features were improved in SQL Server 2022: Analytics Availability Security Performance Query Store and intelligent query processing Management Platform Language SQL Server 2022 Standard edition delivers basic data management and business intelligence database for departments and small organizations to run their applications and supports common development tools for on-premises and cloud, enabling effective database management with minimal IT resources.
