• Adam Makovský

Gain intelligence over data with SQL Server 2019

In November 2019 was released SQL Server 2019. It’s been an amazing journey with a tremendous response from customers. Ever since we announced preview of SQL Server 2019 at Ignite 2018, it has seen 50 percent more adoption than SQL Server 2017, our highest performing SQL Server release to date.

SQL Server 2019 delivers performance, security, and intelligence over all your data

SQL Server 2019 enables enterprises to gain intelligence over all data types, both structured and unstructured, by combining the power of new big data clusters with enhanced data virtualization. These powerful additions to SQL Server enable enterprises to not only store and query big data at scale but also combine it with structured data in whatever database it may reside such as SQL Server, Oracle, MongoDB, PostgreSQL, and others. SQL Server also includes built-in AI capabilities to enable comprehensive analytics and AI solutions for all your data needs.

SQL Server 2019

Customers like Dr Foster, are delighted to have this capability built into SQL Server 2019.

“Dr Foster required a solution that would help limit the amount of data movement, reduce duplication of data sets across the estate, and surface all of our business-critical relational data via a single access point – a unified data platform. With SQL Server 2019 Big Data Clusters, we are able to analyze our relational data in the unified data platform, leveraging Apache Spark™, HDFS, and enhanced machine learning capabilities, all while remaining compliant.” ​- George Bayliffe, Head of Data, Dr. Foster​

SQL Server is an industry leader when it comes to performance. SQL Server 2019 builds on the mission of providing one of the most performant databases in the market by investing in key capabilities like intelligent query processing, which greatly improves query performance with no application changes, as well as accelerated database recovery which enables faster recovery times irrespective of the number or size of active transactions in the system.

Customers like Itaú-Unibanco, one of Latin America’s leading banks, have seen tremendous performance improvements by upgrading to SQL Server 2019:

“We are really pleased with the performance and results we achieved from using the new SQL Server 2019 features. The intelligent query processing feature has increased the speed and processing power of our business applications. With accelerated database recovery, long-running application transactions can roll back and be recovered in a matter of seconds which is a huge relief for our database administrators, saving us significant time and resources.”​- Edilson Andrade de Albuquerque, Manager of the Database Team, Itaú-Unibanco​

When it comes to security, SQL Server 2019 continues to be one of the most secure databases in the world according to the National Institute of Standards and Technology vulnerability assessment report. But today, SQL Server 2019 takes security to a new level through Always Encrypted with secure enclaves, which provides the ability to protect your most sensitive data while still allowing robust operations to be executed without losing encryption.

The Most Secure Databases

Hiscox, a business insurance provider, trusts SQL Server 2019 to protect their sensitive customer data:

“With secure enclaves in SQL Server 2019, we can now enforce highly restricted client application-based access to our customers’ most sensitive data without inhibiting our real-world data handling and analysis requirements.” – Victoria Silversmith, Technical Design Authority – Data, Hiscox Silversmith, úřad pro technický design - Data, Hiscox

Get started with SQL Server 2019 on AppOnFly

AppOnFly company provides cost-effective dedicated Microsoft SQL virtual private server customized to your workload requirements. With the simple configurator on their website you can simply choose whatever plan is best for your needs.

AppOnFly - Budget Plan

  • Grey YouTube Icon
  • LInkedIn MS SQL
  • Facebook
  • Twitter

+420 222 745 000 | info@apponfly.com | mssql.apponfly.com