MS SQL Server 2019 Standard

Apply intelligence across all your data with MS SQL Server 2019 Standard – 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.

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

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.

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.

Features

• 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