Microsoft SQL Server 2019 Standard offers a whole host of powerful new features. Probably the most important and anticipated innovation is the integration of Big Data Clusters into the SQL Server environment. With Hadoop Distributed File System (HDFS) support and built-in analytics capabilities, analyzing big data is made even easier. With the Microsoft SQL Server 2019 standard, Spark queries can be used as both data sources and data sinks. Compared to other data entry options, performance can be increased by a factor of ten.

Extremely flexible in use

Since version 2016, Microsoft SQL Server supports the execution of T-SQL queries to retrieve data from Hadoop sources and process them in structured form. With Microsoft SQL Server 2019 Standard as a full version you now have the option of addressing other data sources such as MongoDB, other SQL servers or Oracle databases in this way. This greatly simplifies the integration of the standard Microsoft SQL Server 2019 into different database ecosystems. The interfaces to specialized programming and scripting languages have also been further expanded and modernized. For example, it is now possible to access the records of an MS-SQL database directly in R. This makes the very high-performance server increasingly attractive to data analysts and scientists

.

Support for Linux as a host operating system for the Microsoft SQL Server 2019 standard has been significantly improved. On the one hand this means easier administration, but above all higher performance and lower resource consumption. It can also be used inside port containers. Big Data Cluster images for the cubernet are also available. You can also deploy SQL Server instances on Azure, Microsoft’s cloud infrastructure. This means additional flexibility and even easier scalability. The parallel use of local databases and databases connected via Azure is also possible.

Who should buy Microsoft SQL Server 2019 Standard?

Microsoft’s SQL server is primarily aimed at medium to large companies and organizations that need a reliable solution for managing large data sets. The full version of Microsoft SQL Server 2019 Standard is also of interest to data scientists and analysts. With interfaces to R and Python, the Microsoft SQL Server Standard 2019 also represents a highly stable and reliable database solution for such users.