Microsoft SQL Server 2019 - The powerful DBMS from Microsoft
With the Microsoft SQL Server 2019, Microsoft's database management software takes things to the next level. Building on the architecture of the popular previous version, the developer from the USA has optimised the performance, revised numerous details and added many new functions for even better flexibility and performance. SQL Server is now available in two versions. Whereas small and medium-sized business can purchase the Standard Edition of Microsoft SQL Server 2019, large companies will benefit from the many additional features of the Enterprise Edition.
Optimally equipped for Big Data and the Cloud, with SQL Server 2019
Following on from SQL Server 2017, Microsoft has placed its focus more firmly on topics such as Big Data, machine learning and work in the Cloud. Thanks to the integration of the "Apache Spark" Big Data framework and the "Hadoop Distribute File System (HDFS)", companies that purchase the Microsoft SQL Server 2019 wil be optimally equipped to deal with their more extensive Big Data workloads in the future. At present these are still the two most significant frameworks. In addition, the container orchestration software Kubernetes makes possible the flexible execution of workloads. In the current version this functions both locally and via various public clouds.
Another plus when struggling with large data quantities of up to 100 Terabytes are the new functions such as Data Warehousing and Online Transaction Processing (OLTP), as well as the revised PolyBase storage technology. From now on it will be possible for users to issue reuests for data that is stored in Hadoop or Azure Blob Storage. The attractive package is supplemented with expanded support for Azure Storage and the Cloudera and Hortonworks-Hadoop clusters. Thanks to new connectors, users can also conveniently use SQL Server to search databases such as Oracle, MongoDB and Tera Data.
Other new features of SQL Server 2019 at a glance
- Expanded functionalities for chart processing.
- SQL Server 2019 supports the direct execution of Java code.
- SQL Operations Studios have been renamed Azure Date Studio.
- Complex ETL processes (extract, transform, load) have been done away with, thanks to comprehensive data virtualisation.
- Introduction of "Secure Enclaves" in addition to the "Always Encypted" feature provides even better protection for sensitive data.
- Better index management ensures the reduction of performance bottlenecks and downtime.
- Expansion of high-availability groups increases the number of replicas in parallel operation from 3 in SQL Server 2017 to 5 in the current version.
Licensing of Microsoft SQL Server 2019
With regard to licensing, in SQL Server 2019 Microsoft also refers back to the model of the 2017 version. As before, companies that purchase Microsoft SQL Server 2017 can choose between two licensing variants. As usual, when purchasing SQL Server Standard, companies can choose between licensing by processor core (core licensing_ or licensing by server and the corresponding access licences, (Server/CAL licensing). However, in the case of the Enterprise Edition only licensing by core is possible.
With regard to CAL licensing, companies can choosebetween User CALs and Device CALS.User CALs are permanently bound to one user, who can access SQL Server 2019 from any workstation. Device CAls on the other hand are licensed to individual devices. These can in turn be used by any number of employees. Both licence types can be freely combined with one another, which enables the construction and operation of tailored systems.