On Nov 4, 2019, Microsoft announced the availability of SQL Server 2019.
SQL Server 2019 is designed to:
- Reduce the risk of upgrades while using new SQL capabilities when you are ready though inbuilt database compatibility levels.
- Reduce the need for application and query changes to gain a boost in performance.
- Reduce the need for Extract, Transform, and Load (ETL) applications by eliminating data movement.
- Integrate and secure machine learning applications with scalable performance.
- Increase confidential computing of data through hardware enclaves.
- Increase application and database uptime and availability through features like ADR (Advanced Database Recovery).
- Extend the power of the T-SQL language in a secure and robust fashion.
- Run applications and deploy databases across multiple operating systems and platforms with compatibility
- Store enterprise data in a data lake and offer SQL and Spark query capability overall data.
You may be also interested to follow and watch Microsoft Ignite 2019 Live stream.
SQL Server 2019 New Features
AI
- 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.
- SQL Server 2019 enables 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 2019 also includes built-in AI capabilities to enable comprehensive analytics and AI solutions for all your data needs.
Performance
- SQL Server 2019 provides intelligent query processing, which greatly improves query performance with no application changes.
- SQL Server 2019 provides accelerated database recovery which enables faster recovery times irrespective of the number or size of active transactions in the system.
Security
According to the National Institute of Standards and Technology vulnerability assessment report, the SQL Server 2019 continues to be one of the most secure databases in the world.
- 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.
Note: the customers will gain access to all of the new features with no change to the license cost for SQL Server
References
See Also