SQL Server 2019 – Technical Preview
SQL Server 2019, codename Aris, is currently available for Community Technical Preview (CTP), and an evaluation version can be downloaded by clicking here. Microsoft has released a list of enhancements and new features for SQL Server 2019 that bring the performance and security of SQL Server to your choice of language, platform, and data. This blog will cover a couple of the exciting new features.
PolyBase
New connectors have been added to include querying for SQL Server, Oracle, MongoDB, and Teradata. PolyBase in SQL Server 2016 allowed queries across relational data and link Hadoop data to be queried.
Database Engine
Many enhancements were made to the database engine. A few to mention where the columnstore index performance enhancements such as automated index maintenance. Batch mode is now also supported for row store tables.
High Availability
High availability has changed for the better. Synchronous replica pairs increased from three to five with automatic fail-over. Additionally, new secondary to primary replica connection redirection was added. The redirection allows applications to connect to any replica and be redirected based upon configuration and purpose.
SQL Server on Linux
Back in March we talked about running SQL Server on Linux. Since then, there have been some improvements added to the SQL Server 2019 Community Technical Preview. For one, replication has been made available for transactional, merge, and snapshot. You can also now use active directory authentication for Linux instances. There were some additional specific improvements for Machine learning to be supported on Linux and also on a Windows fail-over cluster.
These are much welcome enhancements when it comes to running SQL on Linux.
Troubleshooting Improvements
Several troubleshooting improvements were added in Aris. As an example, Error 2628 will help provide a more specific cause to data being truncated upon inserting into a table. For a full list check out Microsoft’s documentation by clicking here.
What’s next?
Wondering how the new SQL Server 2019 features will work for you? Debating whether to upgrade or not? Contact us today and we can talk in more detail about what makes the most sense for your specific business environment.