What does SQL Server 2019 offer?

The new SQL Server 2019 offers even higher availability of data through queries in record time as well as a range of applications such as Managed Self-Service Business Intelligence and the possibility of interactive data visualizations that further increase the efficiency of data analysis. This also includes the provision of cloud-based solutions.

Big Data clusters are particularly worth mentioning, with which scalable clusters of containers for SQL Server as well as Spark and HDFS can be provided. The open source solution Kubernetes is used as container orchestrator, with which the provision of containers can be scaled and monitored as required.

The query of external data sources via Big Data Cluster is possible as well as the use of data for AI (artificial intelligence), machine learning and various other analysis tasks. Big Data also makes it easy to combine or analyze large and high-quality relational data volumes.

The 2019 Server Edition can also be used to process not only structured but also unstructured data sets, and interfaces to SQL Server-compatible databases such as Oracle can also be used. In addition, SQL Server 2019 allows the integration of Java for the first time. Also included in the Standard are features such as Transparent Data Encryption (TDE), which encrypts various data and log files in real time, and Accelerated Database Recovery (ADR).

Complete your CALs for SQL Server 2019 needs with Wiresoft! With a Device or User CAL from Microsoft you get access to the comprehensive functions and services of the current 2019 and 2016 SQL Server Standard. Especially small and medium-sized companies benefit from the favourable licensing with CALs compared to the Core Licenses. Currently you can find Microsoft device as well as user licenses for the SQL 2019 Standard Edition.

The new SQL Server Edition 2019 at a glance

With SQL Server Edition 2019, you get comprehensive processing capabilities and services, as well as today's sophisticated protection for large amounts of data while maintaining fast availability, even if it is stored locally in different database systems.

This enables employees to execute complex queries and evaluations to which they are specially authorized in the shortest possible time. Licensing through a corresponding CAL protects sensitive data from unauthorized access, whether from internal or external sources, which is particularly important in times of complex attacks on databases.

Additional functions in SQL Server 2019

Compared to SQL Server 2016, the Standard Version 2019 offers additional functions and features for processing, virtualization and protection of critical and complex data volumes.

You can now query extensive datasets contained in data silos without having to move or replicate the corresponding data beforehand. Intelligent database features help you update an SQL Server database, whether on-premise or in the cloud. The risk of application incompatibility is minimized, if not eliminated, through database compatibility certification.

SQL Server 2019 also provides built-in data classification and protection, monitoring, identifying, and alerting you to suspicious actions. In addition, you can not only encrypt confidential data, but also perform extensive calculations on it. Administrators have the option of activating user-defined data access using roles.

The most important new features of SQL Server Version 2019

The following innovations make the processing, virtualization and protection of sensitive data in your company even more comprehensive than before. You will also benefit from the special advantages of using AI (artificial intelligence) technologies. For example, AI and machine learning tasks can be used for data retrieval.

Big Data Cluster

Big data clusters now allow both structured and unstructured data to be combined using the Apache Spark framework and Hadoop Distributed File System (HDFS) to obtain new information.

This allows users to provide scalable clusters of SQL Server, HDFS and Spark containers available on Kubernetes.

SQL Server Big Data Clusters allow you to perform AI and machine learning tasks on the data stored in the HDFS storage pools and data pools.

App deployment allows you to make applications available as containers. These apps can be used as Web services, allowing access to the data stored in a big-data cluster.

Database Virtualization in SQL Server 2019

Data stored in other databases such as HDFS, Oracle or various Azure services can now be easily queried using database virtualization without the need to replicate or move them. SQL Server 2019 introduces new connectors to data sources with this edition.

Intelligent Query Processing (IQP)

Intelligent Query Processing (IQP) improves query performance, speeding up processes without additional application changes.

In-Memory OLTP (Online Transactional Processing)

With online transaction processing, the in-memory database provides key features for configuring persistent memory and optimizing tempdb metadata storage, which also improves performance for mission-critical workloads.

Always Encrypted with Secure Enclaves

Always Encrypted protects sensitive customer data with secure enclaves. Databases on the SQL Server can now be stored completely encrypted. Only the client and the owner of this data can access it.

SQL Server Language Extensions

With the SQL Server 2019, Microsoft is now making it possible for the first time to use Java code within the database management system.

ADR - accelerated database recovery

Faster database recovery - ADR (Accelerated Database Recovery) - also greatly improves database availability, which is especially beneficial for time-consuming transactions.

What CALs are available for SQL 2019? Information about the Microsoft licensing system

The Microsoft licensing system is mostly based on CALs - Client Access Licences. This separates the use (license) of a software from its implementation in the company. In order to use the services of Microsoft SQL Server Standard 2019 Version, you need (besides the further possibility to license cores) a corresponding number of CALs.

A CAL grants only authorized users access to the SQL server. Third parties who do not have a corresponding access license are thus denied access to the server, which also means additional security and protection of sensitive data against unauthorized access.

Difference between User CALs and Device CALs for SQL Server Standard

Wiresoft offers the following Client Access Licenses for the SQL-Server Standard 2019 for small to medium sized companies: User CAL and Device CAL - the user- or device-related license. Below you will find a summary of the main differences between both licensing options.

SQL Server User CAL

A Microsoft User CAL for SQL entitles a specific individual user to access the current SQL Server version. The User CAL is therefore not linked to a specific device, but can, for example, be used either from a PC at the workstation OR from a laptop or other terminal device while travelling or in the home Office. User licensing makes the use of SQL Server particularly flexible.

SQL Server Device CAL

The Microsoft Device CAL, on the other hand, is a device-related license, meaning that only a single computer is authorized to access the SQL Server, for example a PC in your company OR a laptop or other end device such as a tablet. Every authorized user can access the SQL Server for this licensed device. The licensing of individual users is not necessary.

Which is the best type or combination of the two CAL versions for your company may of course differ from case to case. The number of employees as well as the preferred way of use in your company is of particular importance:

If your employees access the Windows SQL Server predominantly at their own workstations, the Device CAL is the most suitable license form. If employees access the SQL server flexibly from different devices or workstations (mobile, stationary), then you will benefit most from User CALs.

Buy SQL Server 2019 CALs at a reasonable price from Wiresoft

At Wiresoft you will find Device or User CALs for Microsoft SQL Server version 2019 at a very reasonable price. So you can cover or extend your demand for the respective SQL Server licenses. If you have questions about your licensing for Microsoft SQL Server Standard, please contact us. We will create an individual and inexpensive CAL combination for you.

Whether SQL device or user license: All our Microsoft license products are original and originate from Europe. At Wiresoft you profit by purchasing unused software licenses, which we have purchased from other companies and checked for authenticity for you - many of our customers have confirmed this. For further information about our SQL Server CALs offer, please contact us: