SQL with Manoj

 
Today on 24th September 2018 Microsoft announced the released of first CTP version of SQL Server vNext i.e. SQL Server 2019 CTP 2.0.
 

SQL Server 2016 & 2017 brought Machine Learning feature by adding R and Python support for Data Analytics and Scientists.

And now SQL Server 2019 has added Big Data capabilities under a unified platform by adding support for Apache Spark and HDFS, providing support for managing and querying unstructured data with structured/relational data.

Thus giving you an out-of-box end-to-end hybrid data platform with different types of workloads like OLTP, OLAP, DW/BI, Advance Analytics, Big Data and ML & AI on your data.

 
And just like the previous SQL Server 2017 the new SQL Server 2019 version will also run both on Windows & Linux.
 

Download SQL Server 2019 CTP bits:

To download the SQL Server 2019 you can Register and Download the Free evaluation version (180 days).

Or, directly download the web installer EXE (~3.7 MB): SQLServerVNext-SSEI-Eval.exe
 

Check version and SQL build:

select @@version

Microsoft SQL Server vNext (CTP2.0) – 15.0.1000.34 (X64)
Sep 18 2018 02:32:04
Copyright (C) 2018 Microsoft Corporation
Enterprise Evaluation Edition (64-bit) on Windows 10 Enterprise 10.0 (Build 16299: ) (Hypervisor)

New Features & Enhancements:

1. Deploy Big Data clusters with SQL Server & Spark by leveraging Polybase [more info]

2. Build and rebuild CCI online (Clustered ColumnStore Indexes)

3. Resumable online index create operation to pause and resume later from where the operation was paused or failed, instead of restarting from the beginning.

4. Row mode memory grant feedback

5. Approximate COUNT DISTINCT (for big data scenarios)

6. Batch mode on RowStore without ColumnStore index

7. Table variable deferred compilation (for better cardinality estimates)

8. New DMV sys.dm_db_page_info system function returns page information

9. Database scoped default setting for online and resumable DDL operations (ELEVATE_ONLINE or ELEVATE_RESUMABLE)

10. Always On Availability Groups – upto 5 synchronous replicas (3 till now)

11. New Polybase connectors or SQL Server, Oracle, Teradata, and MongoDB

12. Support for MERGE DML and Edge Constraints in SQL Graph

13. Expanded support for persistent memory devices (by bypassing the storage stack of the operating system using efficient memcpy operations)

14. SQL Data Discovery and Classification [more info]

… and many more, I’ll discuss about these features in my coming posts.
 

Feature Selection Page:

References:

>> SQL Server 2019 official Page

>> MSDN Blog announcement

>> Docs for SQL Server 2019