Industry-leading performance and security with SQL Server 2019

Regardless of where your data is stored, query and analyze it with the data platform known for performance, security, and availability.

View the new capabilities of SQL Server 2019

SQL Server 2019 features


|

Break down data silos

 

Gain insights from all your data by querying across your entire data estate—SQL Server, Azure SQL Database, Azure SQL Data Warehouse, Azure Cosmos DB, MySQL, PostgreSQL, MongoDB, Oracle, Teradata, and others—without moving or replicating the data.

Run SQL Server anywhere

 

Use SQL Server with Windows and Linux containers, plus deploy and manage your deployments using Kubernetes.

#1 in performance

 

Get record-breaking performance on Windows and Linux. SQL Server consistently leads across the TPC-E OLTP workload, TPC-H data warehousing workload, and real-world application performance benchmarks.[1]

 

Intelligent database capabilities

 

Upgrade and modernize your SQL Server database on-premises, in the cloud, and at the edge. Database compatibility certification eliminates the risk of application incompatibility. Use in-memory database capabilities such as persistent memory support and memory-optimized tempdb to improve performance for your mission critical workloads.

Fewest vulnerabilities for nine years

 

Protect data at rest and in motion with a database that has the fewest vulnerabilities of any major platform for nine years running in the National Institute of Standards and Technologies National Vulnerabilities Database.[2]

 

Built-in security and compliance

 

Use built-in features for data classification, data protection, and monitoring and alerts. SQL Server 2019 monitors, identifies, and provides alerts on suspicious activity—even identifying and remediating security gaps and misconfigurations.

 

Always encrypted data enclaves

 

Encrypt sensitive data and execute rich computations on encrypted data, plus enable customized data access based on role with complex row filtering.

Maximum availability

 

Gain mission-critical uptime, fast failover, and improved TCO using cloud disaster recovery replicas and always on availability groups.

 

Accelerated database recovery

 

Greatly improves database availability by enabling fast and consistent database recovery regardless of the number or size of active transactions.

Self-service BI on any device

 

Explore visual data and quickly discover patterns to make better, faster decisions with Power BI Report Server, which is included with your SQL Server Software Assurance license.

 

Connect all your data

 

Combine data from almost any source using the extensive connector library and new transformations in SSAS tabular models.

 

Visual data exploration

 

Find the answers behind the data with visual data exploration and interactive analysis of data lakes data using SQL Server BI tools.

Highly scalable cloud services

 

Build highly scalable cloud services on Azure, and get a unified SQL platform built on the industry-leading performance of SQL Server—for limitless scalability, intelligent performance, and built-in security. Migrate to Azure without redesigning your apps and improve the performance of your existing applications.

[1] All TPC claims as of October 21, 2019.

TCP-E:

http://www.tpc.org/4081

TCP-H:

http://www.tpc.org/3331

http://www.tpc.org/3336

http://www.tpc.org/3337

[2] National Institute of Standards and Technology, National Vulnerability Database, October 10, 2019.

 


Get started with SQL Server 2019