SQL Server 2019: Do I need all the new features that it offers?

What is Microsoft SQL Server 2019 Enterprise?

Microsoft SQL Server 2019 Enterprise is currently the most complete and up-to-date version of Microsoft's relational data platform. It offers all the latest database, reporting and analysis functions that are mandatory and frequently used in a modern company that requires a powerful relational database management system (RDMS). It is used in particular in enterprise resource planning systems, ERP software and CRM systems.

In addition to the high-availability solutions AlwaysOn, Big Data Cluster and Service Broker, SQL Server 2019 Enterprise Edition not only offers comprehensive data security and data protection, but also data integrity with extensive communication interfaces and maximum scalability at the same time.
If you already know you need SQL Server 2019 Enterprise, you can find the best deal on the market by clicking here.

What's new in SQL Server 2019 Enterprise?

version is not only an extension of the functions and features contained in the previous version, but has been supplemented with many innovative functions: The Enterprise Edition in particular offers maximum performance and scalability.

These improvements also apply to the areas of compliance and security, but are also reflected in the end-to-end execution of business-critical processes as well as in many new analytics functions to process and evaluate large amounts of data, as is often the case in Big Data management.

Enhancements in SQL Server 2019 Edition Enterprise include high reliability and availability through query execution in record time and data protection through advanced security features. Here, among other things, managed self-service data exploration with interactive visualisation of relevant data helps to increase the efficiency of data recovery and processing, complemented by various intelligent cloud solutions.

With SQL Server 2019 Enterprise, unstructured data sets can be processed in addition to structured data sets, which is made possible for the first time through the integration of Java as well as the use of interfaces to compatible databases such as Oracle.

The innovative features of SQL Server 2019 Enterprise

In addition to data aggregation, the functions of SQL Server 2019 Enterprise that are particularly worth highlighting include monitoring for systematic data collection in logging and data measurement, as well as intelligent processing of search queries.

Especially for larger data volumes, Intelligent Query Processing (IQP), a feature that effectively speeds up query processing, is a highlight. The speed of SQL Server 2019 Enterprise has also been increased in many other database operations and further functions have been added. In the following, we will go into more detail about the individual new functions:

1) Data virtualisation with Big Data clusters

The new Big Data Cluster feature for SQL Server 2019 Enterprise uses AI technologies to analyse large collections of data in near real-time, as is often the case in large enterprises. Big Data Cluster also provides all the tools needed to train machine learning models. Big Data Cluster (BDC) is a Linux-based container network consisting of SQL Server and Apache Spark, deployed via Kubernetes or Azure Kubernetes Services. Python and R applications are also used here.

PolyBase, the function already known from the previous version of SQL Server 2016 for processing Transact-SQL queries from external data sources, has also been expanded to include access to Oracle, MongoD and Terradata.

2. AlwaysOn on SQL Server 2019 Enterprise

Already introduced in previous versions of SQL Server 2019 Enterprise Edition, AlwaysOn is a high availability solution based on the Windows Cluster Service with up to five nodes, providing enhanced high availability without the need for shared storage as with failover clustering. AlwaysOn offers the possibility to store multiple secondary databases that can run redundantly in multiple data centres.

3. Service Broker for Developers

Service Broker is a framework for developing highly scalable applications with asynchronous communication based on SQL Server. Service Broker is scalable and designed as a framework so that it can be used, for example, to send messages within a database or from one database to another. Applications developed on the basis of Service Broker can also be scaled via instances at a later date.

4. availability of Java on SQL Server 2019 Enterprise

In the SQL Server 2019 Enterprise Edition, Java code can also be used for the database management system for the first time through the integration of Java Runtime. This means that compiled Java code can now be executed directly in SQL Server without having to be migrated beforehand. Based on the SQL Server language extensions, the integration of other programming languages is also possible.

5. secure enclaves for secure data encryption

With Secure Enclaves, SQL Server 2019 Enterprise extends the possibilities that Always Encrypted already offers for encrypting data from the client to the DBMS. Data encrypted in this way cannot be viewed even by database administrators with extended rights.

6. performance improvements in SQL Server 2019 Enterprise

• Intelligent query processing optimises the processing of queries, especially of large data sets.
• Intelligent Performance increases the speed of execution of database operations.
• Database Snapshot creates a snapshot of the database that can be used to document the database status as part of an assessment or report.
• The last query plan statistics provide an up-to-date overview of the last query execution plans.
• The lightweight query profile infrastructure has been improved and is now enabled by default in SQL Server Management Studio.
• Accelerated Database Recovery speeds up the recovery of the database after a reboot or transaction rollback.

7. general features of SQL Server 2019 Enterprise Edition:

• Maximum database size: 524 PB
• Big Data Cluster with integrated Apache Spark and HDFS
• Data virtualisation with PolyBase (including Oracle, Teradata, MongoDB)
• Unified AI platform for training working models with SQL Server ML Service
• Machine learning integration through connectivity with Python and open source -R, with full parallelism of R and Python analyses and the ability to run on GPUs.
• Adaptive query processing

8. scalability of SQL Server 2019 Enterprise

The maximum operating system per instance or storage is available for each of the following features and specifications in SQL Server 2019 Enterprise Edition:
• Computing capacity of the SQL Server database engine used by a single instance.
• Analysis Services or Reporting Services computing capacity used by a single instance.
• Memory per SQL Server DB Engine instance for the buffer pool.
• Memory per SQL Server database engine instance for buffer reservation.
• Memory-optimised data size per database in the SQL Server database engine
• Memory per Analysis Services instance
• Memory per Reporting Services instance
• Maximum size of the relational database: 524PB
• Clustered or non-clustered columnstore indices.
• In-memory database: with in-memory OLTP, memory-optimised tempdb metadata and persistent memory support.
• Stretch database
• Partitioning of tables and indices
• Intelligent database: automatic optimisation, batch mode for row storage, feedback on row and batch storage allocation, delayed compilation of table variables and inlining for user-defined scalar functions.

10. high availability of relational database management systems (RDBMS):

• Server Core support
• Copy of the database
• Compression of backups and database snapshots
• Always On Failover Cluster Instances as well as Always On Availability Groups,
• Basic availability groups
• Retrieving pages and files online
• Optimised database query and resumable online index recovery
• Adding storage space while the system is in operation
• Failover server for failover, high availability and failover in Azure.
For more information, visit the official Microsoft website, click here.

11. SQL Server 2019 Enterprise Core Licensing

The per-core licensing introduced by Microsoft with the 2016 server version also applies exclusively to the SQL Server 2019 Enterprise Edition. Therefore, the usual licensing per server/CAL is generally not possible here.

Compared to previous versions, where it did not matter how many cores a processor contained, Pro-Core licensing uses a different standard: Now the number of cores is decisive for determining the licensing requirements. The Pro-Core licensing model also applies to hybrid use and cloud deployment.

With cloud-compatible licensing, one core licence applies to each of the two cores (as opposed to previously, where one licence was required per processor).
The total licence requirement is the maximum number of cores per processor. All physical cores on a server require their own core licence. The minimum number of licences per server is eight, so Microsoft has set the following conditions:

• At least 8 core licences are required for each processor.
• At least 16 kernel licences are required for each server.

That's it, that's all the news we have for you!

If you want to buy a SQL Server 2019 Enterprise, click here to find it at the best price in the market. If you still don't know which product you need, click here to find the full range.
If you are interested in finding the best price for SQL Server 2019, you can find all the offers by clicking here. And if you choose Licendi, you will buy SQL Server 2019 full, which means a full licence!

If you already have a licence to activate your server, you can download it via the following link SQL Server Download.

Were we able to answer your questions?

If you have any questions, please write us a comment here or give us a call.

Greetings,

Your Licendi Team