What's new in SQL Server 2019

Microsoft has announced the new version of SQL 2019

These are the new features and updating:

Big data clusters
 

1. Deploy a Big Data cluster with SQL and Spark Linux containers on Kubernetes (CTP 2.0)
2. Access your big data from HDFS (CTP 2.0)
3. Run Advanced analytics and machine learning with Spark (CTP 2.0)
4. Use Spark streaming to data to SQL data pools (CTP 2.0)
5. Use Azure Data Studio to run Query books that provide a notebook experience (CTP 2.0)
6. Deploy Python and R apps (CTP 2.1)
    

Database engine

1. UTF-8 support (CTP 2.0)
2. Resumable online index create allows index create to resume after interruption (CTP 2.0)
3. Clustered columnstore online index build and rebuild (CTP 2.0)
4. Always Encrypted with secure enclaves (CTP 2.0)
5. Intelligent query processing (CTP 2.0)
6. Java language programmability extension (CTP 2.0)
7. SQL Graph features (CTP 2.0)
8. Database scoped configuration setting for online and resumable DDL operations (CTP 2.0)
9. Always On Availability Groups - secondary replica connection redirection (CTP 2.0)
10. Data discovery and classification - natively built into SQL Server (CTP 2.0)
11. Expanded support for persistent memory devices (CTP 2.0)
12. Intelligent query processing adds scalar UDF inlining (CTP 2.1)
13. Truncation error message improved to include table and column names, and truncated value (CTP 2.1)
14. UTF-8 collations support in SQL Server setup (CTP 2.1)
15. Use derived table or view aliases in graph match queries (CTP 2.1)
16. Improved diagnostic data for stats blocking (CTP 2.1)
17. Hybrid Buffer Pool (CTP 2.1)
18. Static data masking (CTP 2.1)
19. Support for columnstore statistics in DBCC CLONEDATABASE (CTP 2.0)
20. New options added to sp_estimate_data_compression_savings (CTP 2.0)
21. SQL Server Machine Learning Services failover clusters (CTP 2.0)
22. Lightweight query profiling infrastructure enabled by default (CTP 2.0)
23. New PolyBase connectors (CTP 2.0)
24. New sys.dm_db_page_info system function returns page information (CTP 2.0)
25. Support for columnstore statistics in DBCC CLONEDATABASE (CTP 2.0)
26. New options added to sp_estimate_data_compression_savings (CTP 2.0)
     

SQL Server on Linux

1. Replication support (CTP 2.0)
2. Support for the Microsoft Distributed Transaction Coordinator (MSDTC) (CTP 2.0)
3. Always On Availability Group on Docker containers with Kubernetes (CTP 2.0)
4. OpenLDAP support for third-party AD providers (CTP 2.0)
5. Machine Learning on Linux (CTP 2.0)
6. New container registry (CTP 2.0)
7. New RHEL-based container images (CTP 2.0)
8. Memory pressure notification (CTP 2.0)

Master Data Services

1. Silverlight controls replaced (CTP 2.0)
    

Security

1. Certificate management in SQL Server Configuration Manager (CTP 2.0)
    

Tools

1. SQL Server Management Studio (SSMS) 18.0 (preview) (CTP 2.0)
2. Azure Data Studio (CTP 2.0)
3. Azure Data Studio (CTP 2.1)

Big data clusters

SQL Server 2019 preview Big data clusters enables new scenarios including the following:

1. Use SparkR from Azure Data Studio on a big data cluster. (CTP 2.2)
2. Deploy Python and R apps. (CTP 2.1)
3. Deploy a Big Data cluster with SQL Server and Spark Linux containers on Kubernetes (CTP 2.0)
4. Access your big data from HDFS (CTP 2.0)
5. Run Advanced analytics and machine learning with Spark (CTP 2.0)
6. Use Spark streaming to data to SQL data pools (CTP 2.0)
7. Run Query books that provide a notebook experience in Azure Data Studio. (CTP 2.0)

It's much more for Development:

Download: https://go.microsoft.com/fwlink/?linkid=2038320

Further information: https://docs.microsoft.com/en-us/sql/azure-data-studio/what-is?view=sqlallproducts-allversions