Microsoft SQL Server 2019 Standard

Microsoft SQL Server 2019 Standard

SQL Server 2019 offers industry-leading performance and analytics for all your data, structured or unstructured. Microsoft SQL Server 2019 can now serve as a hub for all your data. You can securely and efficiently query databases like Oracle, MongoDB, Cassandra, and Hadoop without moving or copying data. SQL Server has evolved from a classic database into an industry-leading data platform on which all data projects from OLTP, data warehouse and BI to AI, advanced analysis and big data can be implemented.

SQL Server 2019 is well prepared for big data

In order to prepare companies that buy SQL Server 2019 Standard for a wide variety of big data workloads, Microsoft has integrated two of the most important frameworks when it comes to big data frameworks, "Apache Spark" and Hadoop Distributed File System (HDFS). Data. The interoperability is made possible by the container orchestration software Kubernetes, which ensures that workloads can be executed both locally and across different 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., thereby removing previous analysis barriers.
As a highly scaled service, Azure SQL DB Hyper Scale enables automatic adaptation even to large workloads of up to 100 terabytes per database.
Extensive expansion of the diagram processing functions already known from the predecessor.
Direct execution of Java code and use of Python and R code for the Machine Learning Services.
Revision of the PolyBase technology and the memory engine.
Integration of the two powerful big data frameworks Apache Spark and Hadoop Distribute File System (HDFS).
Run workloads both on-premises and across multiple public clouds.

Security and Data Encryption

Microsoft SQL Server 2019 has transparent data encryption (TDE). This also offers you suspend and resume functions. Simply put, ongoing transactions can be paused when the server is overloaded with encryption, and then resumed afterwards.