Adaptability to future technology enhancements & reduced complexity

Support for more than 128GB of RAM, up to the maximum amount of RAM and number of core processors that the host system offers.

Professional, enterprise-level database management, such as supporting triggers for Microsoft products and close integration with the .NET framework.

Dynamic Resource Allocation - disk and memory usage can scale to meet the changing demands on the infrastructure.

Unlimited virtualization

Under the Per Core licensing model, each server running SQL Server 2019 software or any of its components must be assigned an appropriate number of SQL Server 2019 core licenses. The number of core licenses needed, depends on whether customers are licensing the physical server or individual virtual operating system environments (OSEs).

Unlike the Server+CAL licensing model, the Per Core model allows access for an unlimited number of users or devices to connect from either inside or outside an organization’s firewall. With the Per Coremodel, customers do not need to purchase additional client access licenses (CALs) to access the SQL Server software.

Includes all security features from the standard edition: basic auditing, contained databases, encryption and backups, and user-defined roles

Adds additional features for maximum security: fine grained auditing, transparent database encryption, and extensible key management.

Includes all replication features from standard: change tracking, merge replication, and snapshot replication.

Outperforms the Standard edition in Oracle publishing and peer-to-peer transactional replication.

iSQL - this essential tool enables users to perform interactive queries and build stored procedures, then view them in a graphical representation to display the steps the processor will use to execute.

End-to-end business intelligence