Microsoft SQL Server 2019 is now generally available
MS SQL Server 2019 brings enhancements in the core SQL engine, offers a scale-up and scale-out system with built in support for Big Data (Apache Spark, Data Lake), state of the art data virtualization technology, and with built-in machine learning capabilities.
SQL Server 2019 is designed to solve many business challenges including:
Store enterprise data in a data lake and offer SQL and Spark query capability overall data
Reduce the need for Extract, Transform, and Load (ETL) applications by eliminating data movement
Integrate and secure machine learning applications with scalable performance
Reduce the need for application and query changes to gain a boost in performance
Increase confidential computing of data through hardware enclaves
Increase application and database uptime and availability through features like ADR (Advanced Database Recovery)
Extend the power of the T-SQL language in a secure and robust fashion
Run applications and deploy databases across multiple operating systems and platforms with compatibility
Reduce the risk of upgrades while using new SQL capabilities when you are ready though inbuilt database compatibility levels
SQL Server 2019 also supports big data cluster deployment that comes with additional capabilities of big data, data virtualization, data-mart and enterprise data lake.
Enterprises today have data scattered across a variety of platforms and data sources but need to access this data in a consistent manner. This has led to the need to build complex and expensive Extract, Transform, and Load (ETL) applications often moving the data into a central database platform like SQL Server.
SQL Server 2019 has solutions for these challenges by providing data virtualization. Applications and developers can use the familiar and consistent language of T-SQL through external tables to access structured and unstructured data from sources like Oracle, MongoDB, Azure SQL, Teradata, and HDFS. SQL Server 2019 eases the burden of establishing these data sources with built-in driver support. Polybase extends this functionality allowing you to access a host of other data sources using the ODBC driver of your choice. Because external tables act and look like tables you can join data across these sources with local SQL Server tables to provide a seamless experience. In addition, external tables provide some of the same capabilities as local SQL Server tables including using familiar security and object management techniques.
SQL Server 2019 extends the functionality of Polybase by providing a complete analytics platform powered by Big Data Clusters. In addition, a Big Data Cluster deployment includes a Data Pool which can be used to build a data mart of cached results from queries from external tables across or outside the cluster or data directly ingested from sources such as IoT data.
How much does SQL Server 2019 cost? You can find out in SQL Server Price calculator.