SQL Server 2019 Standard

SQL Server 2019 Standard Edition
• Industry leading performance and intelligence over all your data, structured and unstructured
• Most secure database over the last 9 years per NIST*
• Query any database like Oracle, MongoDB, Cassandra, and Hadoop in a highly secure and highly performant way—all without moving or copying the data
• Built to take on any data project, from OLTP, Data Warehousing and BI, to AI and advanced analytics over Big Data
• Built-in AI with R, Python and SQL Server Machine learning services
• Includes Azure Data Studio
• Features like Transparent Data Encryption (TDE), Accelerated database recovery, and Big Data Clusters are now part of Standard edition

New for SQL Server 2019
• This latest version continues to redefine SQL Server from a traditional relational database system to a data platform for every data scenario.

• Analyze structured and unstructured data

• Use the language and platform of your choice

• Breakthrough performance and scalability of your database

• Access to rich, interactive Power BI reports on any device

View the new capabilities of SQL Server 2019
• Azure Data Studio notebooks
Did you know Azure Data Studio has a rich notebook experience? Whether you need a Python, Pyspark, or a fully integrated SQL kernel, you can start creating and editing your notebooks from anywhere in one tool.

• Intelligence across all your data
Whether your data is structured or unstructured, query and analyze it using the data platform with industry-leading performance and security.

• Query all data types
Manage your big data environment more easily with Big Data Clusters. They provide key elements of a data lake—Hadoop Distributed File System (HDFS), Apache Spark, and analytics tools—deeply integrated with SQL Server and fully supported by Microsoft.

• SQL Server is best on Azure
Migrate your existing apps or build new ones on Azure and get the best price-performance for your mission-critical SQL Server workloads.

• SQL Server 2019 in containers
SQL Server 2019 in containers are a fast way to get started with SQL Server 2019, and can be used throughout your data estate from development to production.

SQL 2019 Standard additional features

• Break down data silos
Gain insights from all your data by querying across your entire data estate without moving or replicating the data.

• 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.

• 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.

• Encrypt all of your data
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. New Software Assurance benefit! Get a free SQL Server license for Disaster Recovery (DR) in Azure.

• 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.

• Highly scalable cloud services
Build highly intelligent, scalable cloud database services on Azure with the broadest SQL Server engine compatibility. Migrate existing apps or build new apps on Azure-the best cloud destination for your mission-critical SQL Server workloads