Microsoft SQL Server 2019 Standard

Microsoft SQL Server 2019 Standard

SQL Server 2019 provides industry-leading performance and analytics for all your data - whether structured or unstructured. Microsoft SQL Server 2019 can now be used as a hub for all your data. You can safely and efficiently query databases such as Oracle, MongoDB, Cassandra, and Hadoop without having to move or copy the data. SQL Server has evolved from a classic database into an industry-leading data platform capable of handling all data projects from OLTP, data warehousing and BI to AI, advanced analytics and big data.

Ideally equipped for big data with SQL Server 2019

To make sure that companies that buy SQL Server 2019 Standard are also prepared for large data workloads, Microsoft is integrating the two most important frameworks, the Big Data Framework "Apache Spark" and the Hadoop Distribute File System (HDFS) Topic big data goes. With interoperability, Kubernetes' container orchestration software makes it possible for workloads to run both locally and across multiple public clouds.

What's New in SQL Server 2019 Standard

New connectors connect the Microsoft SQL Server 2019 Standard Edition with databases such as MongoDB, Teradata, Oracle and Co., eliminating previous analysis barriers.
Azure SQL DB Hyper Scale, as a scaled-up service, automatically adjusts to large workloads of up to 100 terabytes per database.
Comprehensive extension of the functions already known from the predecessor for the diagram processing.
Direct execution of Java code and use of Python and R code for machine learning services.
Revision of the PolyBase technology and the storage engine.
Integration of the two powerful big data frameworks Apache Spark and Hadoop Distribute File System (HDFS).
Perform workloads in both local and multiple public clouds.

Data encryption and security

SQL Server 2019 has transparent data encryption (TDE). This offers additional suspend and resume functions. Simply put, running transactions can be halted if the server is overburdened by encryption, and then resume.