MICROSOFT SQL SERVER 2017 STANDARD

The SQL Server 2017 Standard edition from Microsoft provides all the powerful database, reporting and analysis features that small and medium-sized businesses expect from a relational database management system.

For further questions about the product, please contact our customer service.

Microsoft SQL Server 2017 Standard

The SQL Server 2017 Standard edition from Microsoft provides all the powerful database, reporting and analysis functions that small and medium-sized companies expect from a relational database management system.

In addition to many enhancements and improvements to existing functions - for example, in Master Data Services and Reporting Services - this version also offers many new features. These include Business Intelligence and Always Encrypted technology - combined with high scalability to run typical mission-critical workloads securely and reliably.

With SQL Server 2017 Standard, you get new insights for your data: with In-Database Advanced Analytics for R and - new: also Python, complemented by meaningful interactive visualizations. The extended choice between different development languages and operating systems allows SQL Server applications to be deployed not only for Windows, but also for Linux, including Linux-based Docker containers - in addition to their local execution, those in the cloud are also available.

The SQL Server Standard edition thus meets all the requirements of a modern, powerful relational database management system, such as those typically found in ERP software, CRM and enterprise resource planning systems - Microsoft SQL Server 2017 Standard offers all the necessary prerequisites for a reliable and secure data warehousing platform.

The SQL Server 2017 Standard edition is offered by Wiresoft as used software at a significantly lower price than comparable new software - as far as it is still regularly available. This used server license can be used to its full extent and offers the maximum performance and security typical of the edition, which makes it particularly attractive for companies or organizations that use such servers, for which the combination of server license and CALs is ideal. The licensing of the used Microsoft SQL Server 2017 Standard Edition is also carried out according to the Microsoft license management conditions. Detailed information on this, as well as all the new features and important optimizations included in SQL Server 2017 Standard, can be found in the following sections.

What's new in SQL Server 2017 Standard?

In particular, smaller or medium-sized companies will benefit from the features of the Standard Edition of SQL Server 2017, which are required for the development and use of applications at data marts of appropriate size, and which, in addition to high scalability, also expect reliable disruption-free performance. Here, the Standard Edition already offers high virtualization as well as high availability for failover, advanced OLTP and in-memory columnstore - including real-time operational analytics and PolyBase technology, which can combine relational data and Big Data for their diverse use.

The updated Business Intelligence features provide multi-dimensional as well as basic tabular models for analyzing large data sets, including with in-memory storage mode and Basic Reporting and Analytics features. Advanced Analytics supports machine learning integration with SQL Server Machine Learning Services, as well as connectivity with - new: open source Python - and R; these also provide a consistent environment not only on Windows, but also for Linux and Docker, as well as real-time hybrid transaction and analytics processing.

SQL Server 2017 Standard also supports many development tools both on-premises and in the cloud, including T-SQL and SQL CLR. And in terms of security, Always Encrypted offers advanced protection, including Always On high availability and disaster recovery for Windows as well as now Linux.

Below is some more info from what's new for SQL Server 2017 Standard in key functional areas:

SQL Database Engine

The database engine in SQL Server 2017 offers new features for complex analytics - including adaptive query processing with improvements for Adaptive Joints and feedback on memory allocation in batch mode - in addition to higher performance, streamlining workflows. CLR assemblies can now be added to a positive list. Overlapping execution of table value functions with multiple statements is also possible. Furthermore, new dynamic management lists, including auto-optimization, also improve performance; query performance problems are immediately indicated and appropriate solution suggestions are created, which are also automatically implemented.

SQL Server Analysis Services

For SQL Server Analysis Services (SSAS), SQL Server 2017 includes some updates to existing key features as well as improvements to tabular models: For example, tabular mode is now available as a default installation option. The modern Get Data user interface (Function: Get Data) supports a wide range of data sources and offers a variety of data transformation features in the query builder for retrieving data and M-expressions - among other things, Get Data in Power BI uses existing data sources in queries in the Power Query M formula language.

SQL Server Integration Services

Connectivity enhancements enable connectivity between Microsoft Dynamics AX Online and Microsoft Dynamics CRM Online OData feeds using updated OData components.

The Scale Out feature simplifies the execution of SSIS packages across multiple computers, executions as well as workers can be managed from a single master computer. The Scale Out master supports high availability and optimized failover handling of execution logs.

Use of Linux

Users can now use  the Linux operating system in SQL Server 2017 Standard Edition to access SQL Server through it. The connection is made via the Open Database Connectivity interface - for Linux as well as C++ applications. Integration Services is also available on Linux, so SSIS packages can run on Linux computers. In addition, the Java Database Connectivity driver has been optimized for corresponding Java applications.

When using Linux, please note that the following services and features are not available: SQL Server Reporting Services, SQL Server Analysis Services, Machine Learning Services, PolyBase, and Stretch Database.

New: SQL Server Machine Learning Services

Referred to as SQL Server R Services in previous versions of SQL Server 2017, this area has now been renamed SQL Server Machine Learning Services - the main reason for this is the addition of Python support alongside the previous R programming language, so either R or Python scripts can be used for execution. The prerequisite for the deployment of R and Python models is the installation of Microsoft Machine Learning servers. Developers can further access ML and AI libraries for Python, these are available via open source environment.

Information on maximum available performance and the individual components of SQL Server 2017 Standard Edition

The following overview contains information on performance and the respective included features.

Supported memory sizes per instance

• SQL Server 2017 Standard Edition supports the maximum number of 24 cores and the maximum database size of
• maximum database size of 524 PB
• For memory-optimized data, the maximum size is 32 GB
• The maximum buffer pool size is 128 GB
• The maximum columnstore segment cache is 32 GB

OLTP (Online Transaction Processing) performance

For the Standard Edition of SQL Server 2017, the following features are available or the following caps apply:

• Advanced OLTP with in-memory OLTP as well as Operative Analytics
• Basic High Availability supports failover in a single database with two nodes as well as a non-readable secondary replica.
• Management Studio and policy-based management are also supported.

Data Warehousing Features

• Partitioning, data compression, and change capture, including database snapshot, are available for data marts and data warehousing.
• In-memory OLTP and in-memory columnstore are each limited to the scaling limits of the available memory size.
• Columnstore and operational real-time analytics are limited to a maximum of two degrees of parallelism (two cores per query).
• Further, it should be noted that horizontal scaling of queries is not possible in SQL Server Standard Edition for PolyBase, however.

Business Intelligence Features

• For Analysis Services, the maximum memory usage per instance is 16 GB for tabular and 64 GB for MOLAP (Multidimensional OLAP).
• For Reporting Services, the maximum memory usage per instance is 64 GB.
• SQL Server 2017 Standard Edition of provides business intelligence capabilities for basic multidimensional models, plus a basic tabular model, as well as in-memory storage mode, basic reporting and analytics.
• SQL Server Integration Services and built-in connectors are available for data integration.

Other specifications and notes

Further applies to SQL Server 2017 Standard Edition or is available:

• Basic Machine Learning integration for Advanced Analytics
• Connectivity with open source Python and -R and limited parallelism
• For programmability and development tools: T-SQL, SQL CLR, Service Broker, JSON, XML, as well as graph data
• Advanced security Always Encrypted, row-level security, data masking, and compatibility reporting with SQL Server Audit

Hardware and Software Requirements for SQL 2017 Standard

The following specifications apply when installing the Standard edition of MS SQL Server 2017, these are required as a minimum to ensure optimal operation. Basically:

• On a 64 bit client operating system, all SQL Server 2017 Standard features are supported.
• On a 32-bit client operating system, on the other hand, only the following features of SQL Server 2017 Standard are supported: the SQL Client Connectivity Software Development Kit, Integration Services, Data Quality Client, the connectivity or backward compatibility of client tools or the client tools Software Development Kit, the Distributed Replay components, controller and client, and the documentation components.

Hardware requirements:

• Hard disk: at least 6 GB of available space - depending on the SQL Server components installed in each case
• Memory: min. 4 GB, the memory should be increased as the database size increases to ensure the optimal performance of SQL Server
• Processor type: x64 processors - AMD Opteron or AMD Athlon 64, Intel Xeon or Intel Pentium IV with EM64T support
• Processor speed: 1.4 GHz minimum; 2.0 GHz or faster recommended
• Please note: SQL Server installation is only supported on x64 processors (x86 processors are no longer supported): Additionally, it is recommended to install SQL Server on a computer with NTFS or ReFS file format

Software requirements:

• .NET Framework 4.6, the SQL Server setup .NET Framework is automatically installed, Master Data Services and Replication
• Supported operating systems: Windows Server 2016 Datacenter, Standard and Essentials; Windows Server 2012 R2 Datacenter; Standard, Essentials and R2 Foundation; Windows Server 2012 Datacenter, Standard, Essentials and Foundation 
• Installation of SQL Server 2017 in Server Core mode is supported on the following Windows Server editions: Windows Server 2017 Standard and Datacenter; Windows Server 2016 Standard and Datacenter; Windows Server 2012 R2 Standard and Datacenter; and Windows Server 2012 Standard and Datacenter

Licensing SQL Server 2017 Standard on the Server/CALs model

This SQL Server 2019 Standard edition offers licensing of the server in a combination of the server license described here and additional client access licenses (CALs) - the latter are not included here and must therefore be purchased separately for each user or end device. Here is an overview of the Microsoft licensing terms:

• One server license is required per server (physical or virtual) on which SQL Server 2017 Standard is to run.
• SQL Server instances that are operated in containers must also be licensed, as these virtual machines are equated.
• In addition, a separate client access license (CAL) of at least the identical version, or possibly a higher version, is required for each user or end device that accesses a licensed SQL Server; CALs must be purchased separately and are available as a separate product here.

This licensing model is therefore suitable for companies that license a manageable number of users or end devices, and where the overall licensing costs are lower than for core-based licensing.         

If you have any questions about your individual SQL Server 2017 Standard licensing with CALs, please feel free to contact us.

FAQs about SQL Server 2017 Standard Edition as used software

A license to SQL Server 2017 Standard offered by Wiresoft as used software does not differ from a corresponding new server license - apart from the fact that a software generally does not wear out, but especially not in terms of its usability and functionality. Below you will find all the answers to typical questions about used SQL Server licenses:

Where does the software offered by Wiresoft as used SQL Server 2017 Standard come from?

Used SQL Server 2017 Standard software offered by Wiresoft or from another version or edition comes from companies that previously purchased it themselves as new and later resold it to Wiresoft - for various reasons, for example, because it is surplus or has been replaced by another software. Such licenses are marked as used software in the Wiresoft Shop, but in principle they can be used like a new license.

Does the used SQL Server 2017 Standard license offer buyer protection?

Yes: With Wiresoft used software such as the SQL Server 2017 Standard license, you as a customer have the same advantages when purchasing as with a corresponding new server software: with buyer security through immediate download after successfully completed purchase and immediate license activation with the supplied valid license key.

Are the purchase and also the use of SQL Server 2017 Standard as used software legal?

Yes: With used software from Wiresoft, you can be confident that you as a customer will not violate any laws either by purchasing such SQL Server 2017 Standard license or by actually using it - and this also applies to Wiresoft - because this used software comes from a company's license inventory. This is important, because the valid jurisdiction does not only allow trading with Microsoft Used Software, but also its actual use; these facts have already been confirmed several times by various court rulings.

Does used software from Wiresoft, such as the SQL Server 2017 Standard license, have any other advantages?

Wiresoft used software from offers our customers in particular an economical solution if they want to supplement or update their software inventories as cheaply as possible, because the price is lower than that of comparable new software. This is especially true for older versions of server licenses, which are no longer regularly offered. Used software from Wiresoft is also characterized by the complete proof of all buyers through audit security!

In the Wiresoft store for used software, you will not only find the SQL Server 2017 Standard Edition at an advantageous price, but also the Standard Edition with core licensing as well as other editions of SQL Server 2017; in addition, newer versions of Microsoft SQL Server. Wiresoft's used software portfolio also includes many offers from other Microsoft programs - with all the benefits mentioned above. If you have any questions regarding your licensing of SQL Server 2017 Standard incl. CALs or any other edition, please feel free to use our expert advice via chat or by e-mail or phone.