SQL Server 2019 preview combines SQL Server and Apache Spark to create a unified data platform
Now, for the first time ever, SQL Server 2019 creates a unified data platform with Apache Spark and Hadoop Distributed File System (HDFS) packaged together with SQL Server as a single, integrated solution.
With SQL Server 2019, you can take on any data project, from traditional SQL Server workloads like OLTP, Data Warehousing and BI, to AI and advanced analytics over big data.
SQL Server – Insights over all your data
Simplify big data analytics for SQL Server users.
It comes with everything you need to create a data lake, including HDFS and Spark provided by Microsoft and analytics tools, all deeply integrated with SQL Server and fully supported by Microsoft.
Give developers, data analysts, and data engineers a single source for all your data – structured and unstructured – using their favorite tools.
Now, you can run apps, analytics, and AI over structured and unstructured data – using familiar T-SQL queries or people familiar with Spark can use Python, R, Scala, or Java to run Spark jobs for data preparation or analytics – all in the same, integrated cluster.
Break down data silos and deliver one view across all of your data using data virtualization.
Using the new PolyBase, you can break down data silos and easily combine data from many sources, including Oracle, Teradata, MongoDB, PostgreSQL, and others, using virtualization to avoid the time, effort, security risks and duplicate data created by data movement and replication.
Enhanced performance, security, and availability
The SQL Server 2019 relational engine will deliver new and enhanced features in the areas of mission-critical performance, security and compliance, and database availability, as well as additional features for developers, SQL Server on Linux and containers, and general engine enhancements.
Getting started
Find additional resources and get started today by visiting the links below:
- Preview SQL Server 2019 for Windows, Linux, or Docker.
- Sign up for the Early Adoption Program to get advice and support for your project from SQL Server engineering, or to try SQL Server 2019 big data clusters.
- Download Azure Data Studio to get started with new SQL Server big data features like data virtualizations and notebooks.
Source
Thanks to ASAD KHAN (https://cloudblogs.microsoft.com/sqlserver/2018/09/24/sql-server-2019-preview-combines-sql-server-and-apache-spark-to-create-a-unified-data-platform/)
Any feature for deploying OLAP cubes directly from Python?
Gianmarco Giunti