What new in SQL Server Language Extensions?

THIS TOPIC APPLIES TO:yesSQL Server noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Language extension capabilities are added to SQL Server in each release as we continue to expand, extend, and deepen the integration between external languages and the data platform.

New in SQL Server 2019 preview

This release adds the support for Language Extensions in SQL Server. For more information about all of the features in this release, see What's New in SQL Server 2019 and Release Notes for SQL Server 2019.

Release Feature update
CTP 3.0 New CREATE EXTERNAL LANGUAGE for registering external language (for example, Java) in SQL Server.
New supported Java data types.
CTP 2.5 New Microsoft Extensibility SDK for Java.
CTP 2.4 Linux support for CREATE EXTERNAL LIBRARY (Transact-SQL).
The environment variable that specifies the location of the Java interpreter has changed from JAVA_HOME to JRE_HOME.
CTP 2.3 New supported Java data types.
On Windows only, Java code can be accessed in an external library using the CREATE EXTERNAL LIBRARY (Transact-SQL) statement. Learn more: How to call Java from SQL Server.
CTP 2.2 No changes.
CTP 2.1 No changes.
CTP 2.0 Java language extension on both Windows and Linux is new in SQL Server 2019 preview. You can make compiled Java code available to SQL Server by assigning permissions and setting the path. Client apps with access SQL Server can use data and run your code by calling sp_execute_external_script, the same procedure used for R and Python integration on SQL Server Machine Learning Services.
Failover cluster support is now supported on Windows and Linux, assuming SQL Server Launchpad service is started on all nodes. For more information, see SQL Server failover cluster installation.

Next steps