What's new in SQL Server 2019?
Microsoft announced the latest preview of SQL Server 2019 on this September and Celebrating 25 years of SQL Server Database Engine since SQL Server first shipped on Windows NT in 1993. In every release of SQL server, Microsoft makes inner optimizations that enhance performance. In this release there is no License or support it only available for experiments.
SQL Server 2019 makes a brought together information stage with Apache SparkTM and Hadoop Dispersed Record Framework (HDFS) bundled together with SQL Server as a solitary, coordinated arrangement. SQL Server 2019 continues to push the boundaries of security, availability, and performance for all your data workloads new compliance tools, higher performance on the latest hardware, and high availability on Windows, Linux, and containers. Improved PolyBase empowers you to inquiry different databases like Prophet, Teradata, and Mongo DB specifically from SQL Server without moving or replicating the data.
The following features are added or enhanced in new SQL Server 2019 preview.
Big Data Clusters
SQL Server enormous information groups furnish adaptability by the way you connect with your huge information. You can question outer information sources, store huge information in HDFS overseen by SQL Server, or force information from various information sources into the group. You would then be able to utilize the information for AI, Machine Learning, and different investigation undertakings. The accompanying segments give more data about these situations. Read more over here.
New changes on query processor which are available with database compatibility level = 150 keeping in line with our database compatibility based upgrade promise.
UTF-8 support: UTF-8 full support for the widely used character encoding as an import or export encoding, or as database-level or column-level collation for text data. UTF-8 is allowed in the CHAR and VARCHAR datatypes and is enabled when creating or changing an object’s collation to a collation with the UTF8 suffix. you can find more here.
Platform of choice
A platform of choice indicates a platform that runs on multiple operating systems.Sql Sever 2019 introduce new connectors for PolyBase to external data for Oracle, Teradata, MongoDB and itself which allows us to create a unified data platform using the SQL Server database engine.
Find more about on Microsoft official page
Click to download the Preview SQL Server 2019 for Windows, Linux, or Docker.