Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to:
SQL Server
This article describes the Database Engine features that are no longer available in SQL Server.
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 Big Data Clusters will be retired. See information in Introducing SQL Server Big Data Clusters.
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.
The following database scoped configuration options are discontinued:
DISABLE_BATCH_MODE_ADAPTIVE_JOIN
DISABLE_BATCH_MODE_MEMORY_GRANT_FEEDBACK
DISABLE_INTERLEAVED_EXECUTION_TVF
For current configuration options, see ALTER DATABASE SCOPED CONFIGURATION.
In July 2024, Stretch Database was discontinued in all supported versions of SQL Server.
In July 2024, Stretch Database was discontinued in all supported versions of SQL Server.
No other features were discontinued in SQL Server 2017 (14.x).
SQL Server 2016 (13.x) is a 64-bit application. 32-bit installation is discontinued, though some elements run as 32-bit components.
Compatibility level 90 is discontinued. For more information, see ALTER DATABASE (Transact-SQL) compatibility level.
ActiveX subsystem is discontinued. Use command line or PowerShell scripts instead.
Startup parameters -h
and -g
. For more information, see Database Engine Service Startup Options.
Secure Sockets Layer (SSL) encryption is discontinued. Use Transport Layer Security (TLS) instead. For more information, see Configure SQL Server Database Engine for encrypting connections.
The precompute rank server configuration option was discontinued beginning with SQL Server 2008 (10.0.x). The article was removed from documentation.
In July 2024, Stretch Database was discontinued in all supported versions of SQL Server.
Events
Mar 31, 11 PM - Apr 2, 11 PM
The biggest SQL, Fabric and Power BI learning event. March 31 – April 2. Use code FABINSIDER to save $400.
Register todayTraining
Module
Introduction to SQL Server 2022 T-SQL enhancements - Training
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.
Certification
Microsoft Certified: Azure Database Administrator Associate - Certifications
Administer an SQL Server database infrastructure for cloud, on-premises and hybrid relational databases using the Microsoft PaaS relational database offerings.