Microsoft
Microsoft SQL Server 2019 Enterprise - 2 Core
Microsoft SQL Server 2019 Enterprise - 2 Core
Couldn't load pickup availability
*Microsoft Software Licensing terms require a minimum of 4 cores to be licensed with the core model*
Secure Your Data With SQL Server 2019
Query and analyze your data using industry-leading performance and security for your enterprise needs.
How to License SQL Server Enterprise
It provides a more precise and consistent measurement of computing power, regardless of whether solutions are deployed on physical servers on-premises or in virtual/cloud environments, such as Azure.
- Core-based licensing is appropriate when customers are unable to count users/devices, have Internet/Extranet workloads, or have systems that integrate with external-facing workloads.
- To license a physical server—when running SQL Server in a physical operating system environment (OSE)—all physical cores on the server must be licensed.
- Each instance of SQL requires a minimum of four cores licensed when licensing on a per-core basis.
Download the full Microsoft SQL Server 2019 Licensing guide
SQL Server Features: Standard vs. Enterprise
| SQL Server 2019 New Features | Standard | Enterprise | ||
|---|---|---|---|---|
| Compute and storage | Maximum number of cores | 24 | OS Max | |
| Maximum memory utilized per instance | 128 GB | OS Max | ||
| Maximum size | 524 PB | 524 PB | ||
| Intelligence over all your data | SQL Server 2019 Big Data Clusters with Apache Spark and HDFS built into SQL Server engine | |||
| Data virtualization using PolyBase (including additional data sources like Oracle, Teradata, MongoDB, and other SQL Server databases) | ||||
| Unified AI platform to train and operationalize models with SQL Server ML Services | ||||
| Azure Machine Learning and Spark ML | ||||
| Choice of language and platform | Compatibility certfication | |||
| UTF-8 Support | ||||
| Support for SQL Server Java extension | ||||
| Industry-leading performance and availability | Free DR replicas in Azure and on-premises | |||
| Intelligent Query processing: Scalar UDF inlining, table variable deferred compilation, approximate count distinct | ||||
| Intelligent Query processing features: row mode memory grant feedback, batch mode for row store and automatic tuning | ||||
| Automatic read-write connection re-routing | ||||
| In-Memory Database: memory-optimized tempdb | ||||
| In-Memory Database: Persistent Memory support | ||||
| Accelerated Database recovery | ||||
| Support for Kubernetes deployment | ||||
| Secure and reliable | Always Encrypted with secure enclaves | |||
| Transparent database encryption | ||||
| Data classification and auditing | ||||
| Vulnerability assessment | ||||
| Quick business insights | Azure Data Studio to manage SQL Server including support for T-SQL using Notebooks | |||
| SQL Server Analysis Services Direct Query | ||||
Microsoft SQL Server has been a leader in database management technology for years. The 2019 edition picks up right where its predecessor left off.
For enterprises that want to get the most out of their data, Microsoft SQL Server 2019 Enterprise Edition is an excellent choice. As a step up from the SQL Server Standard Edition, SQL Server 2019 Enterprise features end-to-end business intelligence, unlimited virtualization, blazing-fast performance, and a host of high-end data center capabilities.
Download the fully-featured Microsoft SQL Server Enterprise Edition and receive installation support from Trusted Tech Team’s internal support team. As a Microsoft Cloud Solutions Partner (CSP), we’re here to help you get started. (Note that Microsoft software licensing terms require a minimum of four cores to be licensed with the core model)
New to SQL Server Licensing? Check out our SQL Server licensing guide to find out the features that would benefit you and how to license. Take a deeper dive into SQL licensing with a licensing expert from our team in our Video Meetup below.
Compatibility and Platforms
Microsoft SQL Server 2019 Enterprise edition supports Windows and Linux operating systems and is compatible with on-premises, cloud, or hybrid solutions utilizing Azure. It also offers high availability, high visibility, and multiple disaster recovery options to ensure your data stays secure.
Key Features
- Advanced data warehouse capabilities
- Robust security and auditing functionalities
- Supports big data clusters, advanced machine learning (ML), and artificial intelligence (AI)
- Enhanced T-SQL for complex queries
- Always On availability for improved uptime
Licensing Options
- Core-based licensing
