![]() ![]() ![]() In addition, the new Microsoft SQL Server 2019 offers many performance improvements that benefit not only users but also administrators: Various performance improvements for SQL Server 2019 Even database administrators with their extended privileges cannot view this data. Since the Always Encrypted feature introduced in SQL Server 2016, SQL Server 2019 extends the ability to encrypt data from the client to the DBMS with Secure Enclaves. Secure Enclaves for encrypted data with Secure Enclaves The integration of further programming languages is also possible with the new SQL Server 2019 based on the SQL Server Language Extensions. Compiled Java code can now be executed on the SQL Server without having to migrate it for processing. Developers now benefit from the integration of the Java Runtime. The SQL Server 2019 version now offers for the first time to use Java code within the database management system. The PolyBase feature introduced in SQL Server 2016 for processing Transact-SQL queries from external data sources has now been extended to include Oracle, MongoD and Terradata for accessing certain external storage data sources. SQL Server 2019 Big Data Cluster (BDC) is a Linux-based container network of SQL Server and Apache Spark, deployed in Kubernetes or Azure Kubernetes Services (AKS). Big Data Clusters provide all the tools needed to train and use machine learning models. With the Big Data Cluster feature, a complete environment is now available in SQL Server 2019 that leverages AI technologies to provide near real-time visibility into all dataset data. More and more companies have extensive and constantly growing data collections. The speed of many database operations has also been increased and additional functions added.īelow is a detailed overview of the most important new features of Microsoft SLQ Server Edition 2019: Data virtualization withBig Data Cluster available in SQL Server 2019 various types of systematic collection (logging, measurement), as well as the processing of queries or entries during searches.Ī special feature of the new SQL Server Edition is the Intelligent Query Processing (IQP), which considerably accelerates the processing of queries and is particularly effective for large amounts of data. The intelligent software from Microsoft also offers a number of innovative features for data processing: In addition to clustering (group allocation) of data, these also concern monitoring, i.e. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |