Buying Microsoft SQL Server 2019 Standard: the most important innovations
- additional connectors to other databases
- Inclusion of two frameworks for working with Big Data
- automatic adaptation to very large workloads
- direct execution of Java code
- improved storage engine
- Workloads can run locally as well as in public clouds
- Process queries intelligently through IQP
SQL Server 2019: the new licensing model
Microsoft has introduced a new licensing model for SQL Server 2019. The software will be offered as "Open-NL." The abbreviation stands for "No Level". This means that there is no longer any compulsion to purchase a certain minimum number of licenses. For example, you can buy Microsoft SQL Server 2019 Standard only for yourself. Therefore, you only have to pay for what you actually need and not for more. Moreover, the license does not expire - once you have purchased Microsoft SQL Server 2019 Standard, you can continue using it permanentlyOptimizations and new features in just the right places
Microsoft SQL Server 2019 Standard is without question the direct successor to the 2017 version. Users who know the predecessor will immediately find their way around. Microsoft deliberately designed the program this way. It was built on its strengths - the wheel was not reinvented, but improved. The additional connectors are an excellent example of this. They allow SQL Server 2019 to be used with databases such as Teradata, MongoDB or Oracle. The Apache Spark and Hadoop frameworks have also been integrated, which allow Big Data workloads (with up to 100 terabytes per database) to be performedThe previous version had already introduced chart processing. Microsoft SQL Server 2019 Standard offers more functions for this. Queries to databases are now also processed automatically by Intelligent Query Processing (IQP). The system works faster and more efficiently than anything the previous versions had to offer in this regard. Overall, SQL Server has become smarter. This also applies to the area of business intelligence, for example. Even in archiving, artificial intelligence now works to relieve you as a user