SQL Server

Chart lists Microsoft's data integration and transformation offerings and Directions on Microsoft's forecast of future Microsoft investment in each offering.

Microsoft provides a collection of on-premises and hosted ETL offerings that vary by functionality and maturity; not all are for general use or interchangeable.

SQL Server 2019 Big Data Clusters is a new deployment option that stores and analyzes unstructured data on its own, but it has limits and requires Kubernetes on Linux.

SQL Server 2019 continues support for SQL Server 2008 and 2008 R2 databases, which could ease migration to SQL Server 2019 and help customers extend the life of older applications.

SQL Server 2019 Standard edition receives Enterprise security, deployment, and performance features that could help reduce cost for small applications with high-security needs.

Illustration shows the lifecycle for SQL Server versions.

SQL Server 2019 focuses on being a one-stop data management solution for working with multiple data types, platforms, and languages, helping developers consolidate on a single product.

SQL Server 2019 Big Data Clusters uses a distributed deployment model with multiple instances that are licensed based on the size of a master instance.

Azure SQL Managed Instance previews a small instance deployment option to mimic on-premises environments.

Azure SQL Database is improving service level agreements for Business Critical databases with some limitations.