By: MSSQL Tips | Updated: 2019-11-07 | Comments | Related: > SQL Server 2019
Problem
Is SQL Server 2019 here yet? Is it? Is it?
Solution
Why yes, it is. On November 6, 2019 at the PASS Summit, Microsoft announced the general availability of SQL Server 2019 and more:
- Beyond the SQL Server 2019 release, Microsoft is excited about the Big Data, device data and analytics
- Azure SQL Edge is now in Preview
- Database engine plus analytics for disconnected or partially connected devices
- Ability to run on ARM64 or x64 devices running on Linux
- Time series streaming and analysis is built-in
- AI is built-in with R, Python, JAVA or Spark SQL
- Machine Learning
- Easy deployment
- Azure Data Studio incorporates new development opportunities
- Machine Learning and ONNX Spark will have new capabilities in Azure
- SQL Server 2019 set the TPC-H world record - Congrats!
Check out the SQL Server 2019 tips on MSSQLTips.com:
- Overview of SQL Server 2019 Features
- What's New in the First Public CTP of SQL Server 2019
- Memory-Optimized TempDB Metadata in SQL Server 2019
- Impact of UTF-8 support in SQL Server 2019
- New Command in SQL Server 2019 ADD SENSITIVITY CLASSIFICATION
- New Function in SQL Server 2019 - sys.dm_db_page_info
- Discovering New System Objects and Functions in SQL Server 2019
- SQL Server 2019 APPROX_COUNT_DISTINCT Function
- Improve SQL Server Scalar UDF Performance in SQL Server 2019 with Scalar UDF Inlining
- Resumable Online Index Create in SQL Server 2019
- Accelerated Database Recovery in SQL Server 2019
- SQL Server 2019 Execution Plan Enhancements
- SQL Server 2019 Memory Grant Feedback Example and Data Collection
Next Steps
- Stay tuned for more tips on SQL Server 2019 from the MSSQLTips.com team!
About the author
This author pledges the content of this article is based on professional experience and not AI generated.
View all my tips
Article Last Updated: 2019-11-07