SQL Server 2019 was introduced at Ignite 2018, a Microsoft event in Florida, and is packed with news for users. With the new release, companies that use the tool can better manage the structured and unstructured data they manage, using a single database to do so.

Some of the expectations for the release are its direct run on Azure or on-premise, support for Big Data clusters managed by Kubernetes, and the use of Machine Learning.

In this post, we’ll show you everything we already know about SQL Server 2019 and how it can ease your company’s workflows. Check it out!

What changes in SQL Server 2019?

In the public preview of SQL Server 2019 you can see the major changes made by Microsoft. Internal optimizations ensure better performance than the previous version, such as the use of dynamic memory in all queries.

Unlike the one available in the 2017 version (a memory tuning based on the statistics of previous runs), the upgrade makes it possible to process about 1000 columns very quickly and using aggregate functions.

Always Encrypted, a solution developed by Microsoft to automatically encrypt SQL Server data, is also very useful and very different from the one used in the 2016 version. It now uses a technology called Secure Enclaves that allows encrypted data to be operated in functions in an aggregated way. It temporarily removes data encryption, but the values themselves cannot be viewed during calls, thus remaining protected.

What are the benefits of SQL Server 2019?

Among the main differences that SQL Server 2019 brings to companies, we cannot fail to highlight some of them, which are shown next.

Increased intelligence on data

With SQL Server 2019 you can gain insight into all your company data. As Microsoft embraces Open Source, Big Data analyses for users are made more simply because they manage the data environments in the release.

Developers, engineers, and data analysts find a single source for all data, whether structured or not, and can use their favorite tools to analyze them or choose SQL Server Machine Learning when it comes to performing advanced analysis.

Higher performance

Thanks to intelligent query processing, SQL Server 2019 performance is better, and its persistent memory support makes interactions more responsive. Lightweight software infrastructure is standard on the new tool, thus getting statistics on your queries is an almost instantaneous process.

New security features

The new security features are also a highlight. We have already mentioned Always Encrypted with Secure Enclaves, which protect sensitive data without preventing the execution of aggregate functions. Another major change provided by the feature is the increased protection against malware for encrypted data.

Because SQL Data Discovery is now a native tool, data auditing support is greater and helps your business to comply with GDPR and other compliance standards. This will make all the difference regardless of the platform where you choose to install SQL Server 2019 on (Windows, Linux or Docker).

SQL in Linux

The biggest differences regarding this update are the use of SQL Server on Linux. Since 2017 it is possible to install on this platform, but the versions used there have always had fewer features than their Windows counterpart. In this upgrade, although some features are still missing, Microsoft has made a considerable portion of them available to Linux installations.

Data replication and the use of the Machine Learning package are some of these features. Support for OpenLDA (which opens the way for access to SQL Active Directory) is another big change.

Why is the new SQL Server better than the other options on the market?

Anyone who has doubts about adopting SQL Service over MySQL can rest easy because he or she will make the right choice when choosing the Microsoft tool. Although MySQL is a free program, it does not offer support options like those offered by Microsoft.

Even though there are many common features, there is less control over data in MySQL and inserting data and deleting entries is much more difficult. SQL Server has always had more robust security options than MySQL, but the update reinforces that and makes the solution even more attractive for data protection.

The two options are the most popular in the market, but the one offered by Microsoft is much more interesting for companies, although it has a higher implementation cost.

How to install and upgrade?

To install or upgrade to SQL Server 2019, simply follow the Microsoft guidelines that are available on the release site. Choosing a type of installation (Windows, Linux, Docker or Big Data Analytics) the users will register on the platform with their required data and they can download the tool.

When it is complete, just open the file (in Windows) and choose which option best suits your company, between Basic and Custom. If you only need to download the setup, choose Download Media to upgrade other machines.

In the Custom version you only have to choose the location of the installation and follow the instructions. Upgrading the data and backup directories is easy, and when all of this is resolved, just open Preview to connect to SQL Server 2019.

SQL Server will allow you to gain intelligence on any type of data, because it will integrate all of them into a single hub. It also promises far better performance than previous versions and advanced security options that will help your business protect the data it has and make decisions faster.

SQL Server 2019 can be installed on Windows, Linux, and Containers and is now available for preview on the Microsoft website.

Did you understand the new features of Microsoft SQL Server 2019? Need help with migration? Contact us!