Welcome to deBUG.to Community where you can ask questions and receive answers from Microsoft MVPs and other experts in our community.
2 like 0 dislike
in Announcements by 155 174 350
reopened by

SQL Server 2019

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


  • 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.

SQL Server PerformancePerformance

  • 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.

SQL Server SecuritySecurity

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


See Also

If you don’t ask, the answer is always NO!