What’s on the core of all the most fascinating updates is an acknowledgement that there are only a few firms that solely use a single database product. So what Microsoft is doing with SQL Server is including new connectors that enable enterprise to make use of SQL Server to question different databases, together with these of Oracle, Teradata and MongoDB. This turns SQL Server into one thing of a digital integration layer — but the information by no means must be replicated or moved to SQL Server.
However there’s extra! SQL Server 2019 will include built-in help for Spark and the Hadoop File System. That’s an acknowledgement of the recognition of those open-source instruments, in addition to the significance of huge knowledge workloads that SQL Server, if it needs to say related, has to have the ability to help, too, and it has to take action in a means that many firms are already aware of.
There’s one other open supply facet right here, too: SQL Server will help these large knowledge clusters with the assistance of the Google-incubated Kubernetes container orchestration system. Each cluster will embody SQL Server, the Hadoop file system and Spark.
As for the title, it’s price noting that many pundits anticipated a “SQL Server 2018,” however Microsoft opted to skip a yr after SQL Server 2016 and 2017. So SQL Server 2019 it’s.