This article describes the Database Engine features that are no longer available in SQL Server.
Discontinued features in SQL Server 2022 (16.x)
The following Machine Learning Services packages are no longer included with installation of SQL Server 2022 (16.x). Instead, you can install any custom packages as desired. For more information, see What's new in SQL Server Machine Learning Services?
Language
Package
Python
microsoftml (Python package in SQL Server Machine Learning Services)
R
olapR (R package in SQL Server Machine Learning Services)
R
sqlrutils (R package in SQL Server Machine Learning Services)
R
MicrosoftML (R package in SQL Server Machine Learning Services)
SQL Server PolyBase scale-out groups will be retired. Scale out group functionality is removed from the product in SQL Server 2022 (16.x). PolyBase data virtualization continues to be fully supported as a scale-up feature in SQL Server.
Support for Hadoop (HDFS) external data sources will be retired for SQL Server PolyBase.
In SQL Server 2022 (16.x) and later versions, Hadoop external data sources are no longer supported. You must manually recreate external data sources previously created with TYPE = HADOOP, and any external table that uses this external data source. You must also configure your external data sources to use new connectors when connecting to Azure Storage.
External Data Source
From
To
Azure Blob Storage
wasb[s]
abs
ADLS Gen 2
abfs[s]
adls
In July 2024, Stretch Database was discontinued in all supported versions of SQL Server.
Discontinued features in SQL Server 2019 (15.x)
The following database scoped configuration options are discontinued:
SQL Server 2022 introduces a range of new features and enhancements, providing powerful tools and capabilities that optimize performance and offer better control on SQL objects manipulation and creation.
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.