Microsoft published SQL Server 2019 Preview
Today is the first day of Microsoft’s Ignite 2018 conference in Orlando; the company announced the new SQL Server 2019, its public preview will be online today. The promise of the new database management system (DBMS) is that companies will be able to manage their relational databases and their non-relational databases simultaneously in a single product. Microsoft said it had improved PolyBase to include connectors for more data sources, including “Azure SQL Data Warehouse, Azure Cosmos DB, Mongo DB, Oracle and Teradata.”
Users can now query all of their databases using T-SQL so that you won’t be locked into separate data silos, in other words, all your databases can communicate with each other. It also has big data that supports Spark and Hadoop.
SQL Server 2019 can run locally, in Azure Stack or the cloud. Users can access SQL Server machine learning services and Spark machine learning so that they can get a deeper understanding of all the data, regardless of the form of the data.
Microsoft today also released an Azure SQL database management instance that allows users to bring their SQL Server database to the cloud without having to change the code at all. It also has a full feature set of SQL Server. Microsoft says companies can save up to 80% in costs compared to their competitors.
At the same time, Microsoft announced the launch of the Azure SQL Database Hyperscale, a “highly scalable service tier” that allows you to scale your database to 100TB. Azure Database for MariaDB is now also previewed, providing support for open source databases for Microsoft’s cloud offerings.
There is also good news on Cosmos DB. At present, multi-host platforms around the world have been put into use, achieving “unprecedented write scalability and availability.”
Finally, Microsoft announced a preview version of Azure Data Studio, which is designed for “lightning fast IntelliSense, code snippets, source control integration, and an integrated terminal”. You can use it to find out about PB-level structured and unstructured data.
