SQL Server 2019 – Big Data Is (Still) Coming

As the data we see in front of us grows every day, we constantly try to find new ways to tackle it. Microsoft is bringing the latest iteration of SQL Server to the table to help us with that. The inevitable question then arises – “What can this version do that the last one didn’t, and is it worth it?”

Managing and understanding Big Data has become a primary focal point for nearly every major player in the world. Consequently, new additions to SQL Server 2019 help manage and interpret complex data sets that will help us make better critical decisions.

Features & Improvements

Virtualizing data from various sources such as Oracle, HDFS, Teradata, MangoDB, or traditional SQL relational databases in a unified view creates an even more seamless user experience. As a result, reading data and knowing what to do with it becomes easier for everyone.

SQL Server 2019 not only provides the ability to read different data sources, but to efficiently process them as well. Scalar function inlining helps improve functionality within processing queries. This feature splits step-by-step, row-by-row queries into subqueries that are used to calculate the main query. For example, a complex query can go from a 15-second traditional calculation to a 900 millisecond one - a colossal improvement!

Historically, every new version of SQL includes significant security improvements; so why would the 2019 edition be any different? Extensions to intelligent query processing, among other features, have been implemented to support GDPR compliance and keep data secure. Improvements to real-time analytics and the ability to visualize your data make SQL Server 2019 a “beast” to be reckoned with!

Our Thoughts

What does Trusted Tech Team think of the upcoming 2019 edition of Microsoft’s SQL Server?

We believe although there are a lot of perceived “marginal” upgrades to the platform, it still provides some big improvements. Take control of your data with Intelligent Query Processing and Scalar Function Inlining.

We believe that having the best toolkit at your disposal is highly important. Data will only get more complex as we move forward, so why not focus on the essentials? At the end of the day, it’s your data and you should have every option to get the most out of it. As soon as SQL Server 2019 launches, we will be here for you.