Microsoft SQL Server 2019 Standard

SQL Server 2019 Standard: relational database server for business applications

SQL Server 2019 Standard is the Standard edition of Microsoft's SQL Server 2019 database server. Microsoft describes it as a full-featured edition for databases in mid-sized applications and for data marts. An instance uses up to 4 sockets or 24 processor cores, whichever is lower, and up to 128 GB of memory for the buffer pool. This makes the edition suitable for inventory management, accounting, CRM and other line-of-business applications that use SQL Server as their database, as well as for your own database projects and reports.

Availability and security

For resilience, the Standard edition provides basic availability groups with two replicas and one database each, as well as failover cluster instances with two nodes and log shipping to a second server. Backups can be compressed and encrypted. Accelerated Database Recovery is also included in the Standard edition.

To protect confidential data, SQL Server 2019 Standard includes Transparent Data Encryption (TDE), which encrypts database files at rest, and Always Encrypted, with which individual columns remain encrypted and are only decrypted by authorised client applications. With row-level security, a user only sees the records they are authorised to access, and dynamic data masking partially hides sensitive values such as account numbers in query results. Server and database auditing log access and changes, for example for internal audits.

Reporting, integration and analysis

The edition includes Reporting Services for reports and Analysis Services for analytical models. Reporting Services uses up to 64 GB of memory per instance, and Analysis Services in the Standard edition uses up to 16 GB of memory for tabular models and 64 GB for multidimensional models per instance. PolyBase can be used to query external data sources, and the basic integration of R and Python enables analyses directly in the database, limited to two cores and data volumes held in memory. Improvements to intelligent query processing such as scalar UDF inlining and table variable deferred compilation are also active in the Standard edition.

Licensing models

Microsoft offers SQL Server Standard in two licensing models. In the Server + CAL model, the server is licensed, and every user or device that accesses the server requires a SQL Server CAL. In the per core model, the processor cores are licensed, with a minimum of four core licences per physical processor; additional CALs are then not required, and the number of users and devices accessing the server is unlimited.

Buy SQL Server 2019 Standard: licence and scope of delivery

You receive a product key for Microsoft SQL Server 2019 Standard. You select the licensing model and licence scope when ordering in the product variant. SQL Server 2019 is installed exclusively on 64-bit systems. The scope of delivery includes:

• the product key for SQL Server 2019 Standard
• the download link for the installation file (all downloads are also available under Software Download)
• instructions for installation and activation (see also Guides and FAQ)
• the invoice with VAT shown separately

Once your payment has been received, your product key is displayed directly on the order confirmation page and also sent to you by email. After that, you can retrieve it again at any time: with a customer account under My Product Codes, without a customer account via the Guest Portal.

If you have any questions about installation or activation, our Support team is available around the clock by email. For several servers and larger environments, offers for businesses, schools and public authorities are available in the B2B Area. You will find further server products in the category Windows Server and under Operating Systems.

System requirements

Minimum requirements according to Microsoft. You should increase the recommended memory as the database grows. Installation fails on a Windows system with case sensitivity enabled in the file system.