gourmethoogl.blogg.se - Sql versions

This helps handle heavy workload with ease. Compact (SQL CE) The compact edition is an embedded database engine. This restriction is there because an older version cannot know about file format changes that were introduced in the newer release. Azure SQL Data Warehouse is the cloud-based version of Microsoft SQL Server in a MPP (massively parallel processing) architecture for analytics workloads, presented as a platform as a service offering on Microsoft Azure.

You can store big data in HDFS supported by the SQL server. But the most striking feature of this version is Big Data Clusters, which lets you analyze your data on-fly using T-SQL and spark.

Optimization in tempDB - the tempdb’s system tables can be moved into memory-optimized tables taking the pressure off the disks. Microsoft SQL Server Internal Database Versions and Compatibility Levels A database created by a more recent version of Microsoft SQL Server cannot be attached or restored to an earlier version. SQL Server 2019 is an improved and enhanced version of the previous versions.

Support for replication - SQL Server on Linux supports replication from 2019 version and this is a major addition!.

Performance improvement changes - There’s a new index optimization for indexes that have a sequential key, temp table recompilation improvements, improved indirect checkpoint scalability and more.

AlwaysEncrypted - SQL Server can now securely encrypt a portion of memory to perform computations on these encrypted columns without ever exposing the unencrypted values to the rest of the processes (or administrators).

Accelerated Database Recovery (ADR) - the SQL team has redeveloped how recovery works and has dramatically decreased how long this process takes.

Like all the previous versions, the Microsoft SQL Server 2019 latest version is also jam-packed with new features and capabilities.

What are the latest/key features in SQL Server 2019 ?