Microsoft has announced that SQL Server 2019 is now generally available. The new version has more support for running on Linux and in containers, and improved PolyBase technology.

The announcement was made at Microsoft's Ignite 2019 conference; the preview version of SQL Server 2019 was announced at last year's Ignite conference.

Big data clusters is new in this release. These provide a way to package Apache Spark and Hadoop in with SQL Server so you can use Spark with SQL Server over both relational and non-relation data stored in SQL Server, HDFS and other systems. BDC uses the Kubernetes container platform, making it relatively easy to deploy.  You can also run advanced analytics and machine learning with Spark, use Spark streaming to data to SQL data pools, and use Azure Data Studio to run Query books that provide a Jupyter-like notebook experience.

PolyBase is another area of improvement. PolyBase was introduced in SQL Server 2016 to give a way for a SQL Server instance to process Transact-SQL queries that read data from external data sources. This started in SQL Server 2016 with support for Hadoop and Azure Blob Storage. SQL Server 2019 adds support to query external data in other SQL Server instances, as well as Oracle, Teradata, MongoDB,and Azure Cosmos DB (based on MongoDB). Microsoft says this means SQL Server will be a single point of contact for multi-platform OLTP, NoSQL, data warehouse and data lake workloads.

Other improvements to the more general core of SQL Server 2019 include a better query optimizer that can add extra resources while a query is running; and support for persistent memory. The main improvement for developers is the ability to use Java from SQL Server scripts and stored procedures, as well as R and Python.  

More Information

SQL Server 2019 Homepage

Related Articles

SQL Server 2019 Includes Hadoop And Spark

SQL Server 2017 GA For Linux And Windows

Microsoft R Server 9.1 Adds ML Enhancements

SQL Server vNext Improves SSAS

SQL Server On Linux! 

To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on Twitter, Facebook or Linkedin.

Comments

Make a Comment or View Existing Comments Using Disqus

or email your comment to: comments@i-programmer.info