SQL Server 2017 for Linux (optional)

SQL Server 2017 for Linux

NexusCore bundles a SQL Server 2017 for Linux installation with NexusCore. This was done because most .NET Core solutions are built with SQL Server as a backing data store, this is historical but no longer neccesary.

.NET Core offers means to connect to MySQL / MariaDB, PostgreSQL, and even SQLite, so SQL Server is not neccesary for your clients to utilize .NET Core, but it is a neat extra.

SQL Server 2017 for Linux express edition is a free variant of SQL Server aimed at development environments and/or small business applications. If you and your clients are planning on running large scale applications that heavily utilize SQL Server, you may need to upgrade SQL Server to an edition that fits your needs (license costs apply).

NexusCore comes with an extensive plugin for cPanel that offers SQL Server configuration for your end-users. This plugin has been built to mimic the way users manage their MySQL/MariaDB database, and the screens look mostly the same with some minor changes. See the screenshots below for more information.

cPanel Plugin for SQL Server 2017

Express Edition - Limitations

SQL Server 2017 Express edition comes with a set of limitations for use. You’ll find the limits below:

Feature

Maximum compute capacity

1 CPU or 4 cores

Maximum memory for SQL Server Database Engine

1410 MB

Maximum memory for Columnstore

352 MB

Maximum memory-optimized data size

352 MB

Maximum relational database size

10 GB

If you want to upgrade these limits you’ll need to purchase a license for a different edition of SQL Server 2017. For more information on the different commercial licenses and their limits, please visit the Microsoft SQL Server Edition Comparison page.

Important reading material

Microsoft SQL Server is not a small application and requires resources to run (minimum of 4GB RAM on your server is required, or the installation will fail). For more information on Microsoft SQL Server please follow the links below: