SQL Server 2019: New features!
The latest SQL Server 2019 version is SQL Server 2019 (CTP) 2.2 which Microsoft announced at 10.12.2018. What is actually new in SQL Server 2019? What can we look forward to? There are a couple of interesting new features, new tool and new version of Management Studio. The most interesting described below.
SQL Server 2019 on Linux supports Replication, SQL Agent support these publications:
Next news on Linux:
Always On Availability Group on Docker containers with Kubernetes
OpenLDAP support for third-party AD providers
New container registry
2) New Tools:
Azure Data Studio
SQL Server Management Studio (SSMS) 18.0
3) Database Engine
Scalar UDF Inlining
Static Data Masking
Database Compatibility Level - COMPATIBILITY_LEVEL 150
UTF-8 character encoding
Resumable online index create
Intelligent Query Processing
Always On Availability Groups - more synchronous replicas - Up to 5 replicas
Hybrid Buffer Pool
And next a few things like:
Master data Services will be depend on HTML instead of Silverlight
Certificates will be manageable in QL Server Configuration Manager
For detail information please visit official documentation on MSDN.
See you nex time!