Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted December 3, 2018

SQL Server 2019 Community Technical Preview (CTP) 2.1 is Available Now

By Gregory Larsen

At the PASS Summit in Seattle, Microsoft announced the release of the CTP 2.1 for SQL Server 2019.  This is the second community technology preview released for SQL Server 2019. Here is a list of the new features included in this new CTP version:

  • Deploy and manage R and Python scripts as an application inside a SQL Server 2019 big data cluster
  • Improves Intelligent query processing by adding scaler UDF inlining
  • Improves truncation error messages by include table and column names, as well as truncated value
  • Adds support for UTF-8 collations to the setup process
  • Improves diagnostic data for long-running queries that wait on synchronous statistics update operations
  • Provides static data masking to sanitize sensitive data in copies of your database
  • Implements a new Hybrid buffer pool which improves I/O latency by using persistent memory (PMEM) device  
  • Adds support for using derived tables and views in graph match queries
  • Introduces new client tool named Azure Data Studio to support administering and managing cross-platform database management systems

You can download the latest bits of CTP 2.1 from https://www.microsoft.com/en-us/sql-server/sql-server-2019

To find out more about all the new features released in this CTP 2.1, check out the following webpage:  https://docs.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-ver15?view=sqlallproducts-allversions#databaseengine

With this new version of SQL Server, you now have better query processing and more support for big data.  If you are a data professional, you should consider looking at what this new exciting release is all about.

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM