Microsoft made several key announcements at their Ignite 2018 event, which began yesterday in Orlando, Florida. The biggest announcement of them all was the public preview availability of SQL Server 2019. With this new release of SQL Server, businesses will be able to manage their relational and non-relational data workloads in a single database management system.
What we can expect in SQL Server 2019
- Microsoft SQL Server 2019 will run either on-premise, or on the Microsoft Azure stack
- Microsoft announced the Azure SQL Database Managed Instance, which will allow businesses to port their database to the cloud without any code changes
- Microsoft announced new database connectors that will allow organizations to integrate SQL Server with other databases such as Oracle, Cosmos DB, MongoDB and Teradata
- SQL Server 2019 will get built-in support for popular Open Source Big Data processing frameworks such as Apache Spark and Apache Hadoop
- SQL Server 2019 will have smart machine learning capabilities with support for SQL Server Machine Learning services and Spark Machine Learning
- Microsoft also announced support for Big Data clusters managed through Kubernetes – the Google-incubated container orchestration system
With organizations slowly moving their operations to the cloud, Microsoft seems to have hit the jackpot with the integration of SQL Server and Azure services. Microsoft has claimed businesses can save upto 80% of their operational costs by moving their SQL database to Azure. Also, given the rising importance of handling Big Data workloads efficiently, SQL Server 2019 will now be able to ingest, process and analyze Big Data on its own with built-in capabilities of Apache Spark and Hadoop – the world’s leading Big Data processing frameworks.
Although Microsoft hasn’t hinted at the official release date yet, it is expected that SQL Server 2019 will be generally available in the next 3-5 months. Of course, the duration can be extended or accelerated depending on the feedback received from the tool’s early adopters.
You can try the public preview of SQL Server 2019 by downloading it from the official Microsoft website.
Microsoft announces the release of SSMS, SQL Server Management Studio 17.6
New updates to Microsoft Azure services for SQL Server, MySQL, and PostgreSQL