- Data Virtualization: Query across data stored in Oracle, Teradata, other SQL Servers, Azure SQL Database, Azure SQL Data Warehouse, Azure Cosmos DB, Cloudera, Azure Data Lake, or the Hadoop Distributed File System (HDFS) without moving or replicating the data.
- Intelligent Database: Family of intelligent database features such as intelligent query processing improve query performance with no application change. Customers will see performance benefits without any application change just by upgrading to SQL Server 2019.
- In-Memory Database: Improve performance for mission-critical workloads with in-memory database capabilities like persistent memory support and memory optimized TempDB metadata.
- Secure Enclaves: Always Encrypted with secure enclaves protects sensitive customer data while allowing richer operations on secured database columns. A secure enclave extends client applications’ trust boundary to the server side. While it is contained by the SQL Server environment, the secure enclave is not accessible to SQL Server, the operating system, or to the database or system administrators. These properties allow the secure enclave to safely perform operations on sensitive data in plain text.
- Extensibility: We now offer free Java language integration with SQL Server. Customers can now leverage Java for free with SQL Server 2019.
- Accelerated database recovery enables fast and consistent database recovery irrespective of the number of active transactions in the system or their sizes.
This version of SQL Server requires CAL’s.
There are no reviews yet.