Microsoft SQL Server 2017 Enterprise 2-Core

The SQL Server 2017 Enterprise edition provides larger enterprises with a powerful newer version of the proven relational data platform from Microsoft that combines all the critical database, reporting and analytics capabilities and delivers them with maximum performance. The SQL Server Enterprise edition also offers new comprehensive features, plus virtually unlimited virtualization and comprehensive Business intelligence - at a high level of service - for mission-critical workloads and critical data analytics.

This SQL Server edition Enterprise is excellently suited to meet all the requirements of a modern high-performance relational database Management system - as is typical for the provision of enterprise resource planning systems, ERP software and CRM systems. It provides all the important functions to make Microsoft SQL Server a comprehensive, secure data platform in many enterprise environments, with various options for use: Choose between different development languages and data types as well as operating systems to provide SQL Server not only for Windows but also for Linux and Linux-based Docker containers - as well as between the options of local execution or in the Cloud. In addition, benefit from new insights through In-Database Advanced Analytics with Python or R as well as interactive visualizations including many performance improvements in the Master Data Services and the Reporting Services.

At Softwarehandel24 you can find the SQL Server 2017 Enterprise 2-Core Edition as legally usable used software at a much lower price compared to new software - with all the advantages of this edition in terms of performance and security. The licensing of the SQL Server 2017 Enterprise Edition is also exclusively Core-based for used software. Detailed information about the functional areas of SQL Server 2017 Enterprise 2-Core as well as the related Microsoft licensing terms can be found below.

What's new in SQL Server 2017 Enterprise 2-Core? The most important features of SQL Server 2017 Enterprise 2-Core at a glance

The Enterprise edition of SQL Server 2017 offers the maximum features and scalability available for this version. In addition to unlimited virtualization, it also provides advanced high availability with Always On availability groups, failover on multiple databases and readable secondary replicas, as well as Transparent Data Encryption and compatibility reporting via SQL Server Audit and Advanced Data Integration with fuzzy grouping including lookups, further also the creation of mobile reports and KPIs.

The additional Business Intelligence features include enhancements to multi-dimensional models, tabular models and data mining, as well as DirectQuery storage mode and access to the Power BI reporting server. With extensive integration of machine learning features, SQL Server 2017 Enterprise 2-Core offers full parallelism for R and Python analytics, including the ability to run both on GPUs as well.

In the areas described close below, the respective specifications apply to the SQL Server 2017 Enterprise 2-Core edition in terms of functionalities as well as their scalability, performance and high availability, among others:

New database engine features

SQL Server 2017 Enterprise includes three new enhancements in adaptive query processing: Adaptive Joints, batch mode memory allocation feedback, and overlapping execution of table value functions with multiple statements. New dynamic management lists, as well as automatic database optimization - which provides insight into query performance issues, suggests solutions, and automatically fixes identified problems - improve performance.

CLR assemblies can now be added to a list of trusted assemblies; further, new availability group functionality includes support for read scaling without clusters, setting minimum replicas for commit availability groups, and the ability to migrate across operating systems from Windows to Linux.

SQL Server Analysis Services

Among the important new features of SQL Server Analysis Services (SSAS) are the DAX editor for SSDT and optimizations to the tabular models, with improved object-level security when saving metadata; in addition, a tabular mode is proposed as the default installation option for Analysis Services. With Get Data, new data sources are available in Power Query; existing data sources are supported in M queries. Using Date Relationships, relationships based on date fields can be easily created.

SQL Server Integration Services

In SSIS the Scale Out function offers changed as well as new features, among others the execution of SSIS on multiple PCs has been simplified. Scale Out-Master now supports high availability, and the failover handling of the execution logs of Scale Out workers has also been improved. The feature also includes the Use32BitRuntime parameter to trigger execution, making it DABEI much easier to run SSIS on multiple computers. Furthermore, SSIS Catalog has another global property to specify the Standard mode when deploying SSIS packages and also supports SQL Server on Linux: SSIS packages can be executed on Linux via the command line.

SQL Server Reporting Services

Comments for reports are available in SSRS to add collaboration with other users, and attachments with user comments can be integrated.

In the Report Generator and SQL Server Data Tools, native DAX queries can be created for table data models supported by SQL Server Analysis Services.

SQL Server Master Data Services

In the MDS, a sorted list to entities, collections and hierarchies can be viewed via the explorer page, and performance has also been improved for deploying millions of rows.

SQL Server Machine Learning Services

In SQL Server 2017 release, the previous SQL Server R Services has been renamed to SQL Server Machine Learning Services as Python is now supported in addition to R programming language. The Machine Learning services can therefore be used to run Python or R scripts, to deploy R and Python models that do not require SQL Server, doing so can install the Microsoft Machine Learning-Server. Developers also have access to the ML and AI libraries for Python in the open source environment.

Using Linux

Users can now also use Linux to access the SQL Server, thereby, as with C++ applications, connecting to the SQL Server 2017 via the Open Database Connectivity Interface. Likewise, Java applications can also be used through the Java Database Connectivity driver.

Technical specifications on performance and functionalities of the SQL Server 2017 Enterprise Edition

Below is a brief overview of the performance and included features of SQL Server 2017 Enterprise for the key areas mentioned:

Computing capacity and performance respectively

The areas of SQL Server 2017 Enterprise listed below each provide the maximum of the operating system or RAM:

Pro Instance of SQL Server-Database Engine
Pro Instance of SQL Server Analysis Services or Reporting Services
Pro Instance of the SQL Server working memory for the buffer pool
Pro Instance for the columnstore segment cache
Pro Instance of Analysis Services
Pro Instance of Reporting Services
Relational database size: 524 PB

High availability specifications

Among others, the following functionalities of SQL Server 2017 Enterprise provide high availability:

Server Core-Support
Log shipping
Database mirroring and database snapshot
Backup compression as well as encrypted backup
Always On failover cluster instances and availability groups
Online page and file recovery as well as online index creation and rebuild or resumable rebuild
Adding storage while the system and CPU are running
Availability groups with read scaling

Scalability and performance specifications

For the following features in SQL Server 2017 Enterprise:

Columnstore
Large object binaries in grouped columnstore indexes as well as online rebuild for ungrouped columnstore indexes
In-memory OLTP
Stretch Database
Persistent main memory
Multiple instance support
Multiple filestream container support
Buffer pool extension
Table and index partitioning and parallel processing of partitioned tables
Nested execution of table value functions
Adaptive joins and memory allocation feedback in batch mode

Replication

Publications with Oracle
Peer-to-peer transaction as well as snapshot replication including updatable subscription for transaction replication
SQL Server change tracking

Development tools

MDX editing, debugging and design tools
IntelliSense with Transact-SQL and MDX
SQL Server Data Tools
Integration with Microsoft Visual Studio

Data warehousing

Creation of cubes without using the database
Read-only, scalable analysis configuration Services
Automatic generation of staging and data warehouse schemas
Parallel query processing for partitioned tables and indexes
Global batch aggregation

Security details

Row-level security
Always Encrypted
Dynamic data masking
Server- and database monitoring
Transparent database encryption, backup encryption, and extensible key management
User-defined roles

Administration tools

SQL configurationManager
SQL Management Objects
SQL CMD
Distributed Replay: administrator tool, Client and controller (up to 16 clients)
SQL Profiler and Server-Agent

Core-Licensing of SQL Server 2017 Enterprise

For the SQL Server 2017 Enterprise edition, only the Core licensing introduced by Microsoft with the 2016 Server version applies. The Server/CAL licensing available for other editions is therefore not available here. With Core-based licensing, a different licensing metric applies compared to older versions of SQL Server, where it was irrelevant how many cores a processor contained: Now their number is the basis for determining the license requirement. This licensing model based on cores also applies to hybrid use and to Cloud deployments.

In the case of Cloud-compliant licensing, one Core license is required for each of two cores. The total license requirement thus results from the maximum number of cores Pro processor. Each physical core of a server requires its own Core license. As minimum Pro Server always eight licenses are set, for this Microsoft defined the following conditions:

For each processor at least 8Core licenses are required
For each Server at least 16-Core-licenses are necessary

Core-Licenses for SQL Server 2017 Enterprise Edition are available as packages of 2.

Hardware and software requirements for installing SQL 2017 Enterprise 2-Core

Please note the following information when installing the Enterprise 2-Core edition of MS SQL Server 2017 to ensure optimal operation.

Hardware:

Hard disk: 6 GB of available disk space, depending on the SQL Server components installed
Memory Minimum: 4 GB, with memory increasing as database size increases to ensure optimal performance of SQL Server
Processor type: x64 processor, e.g. AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support - please note:
Processor speed: at least 1.4 GHz; recommended is 2.0 GHz or faster
Installation: it is recommended to install on a computer with NTFS or ReFS file format - installation of SQL Server is further supported only on x64 processors, x86 processors are no longer supported

H3: Software

SQL Server 2017 version requires .NET Framework 4.6 (SQL Server setup installs .NET Framework automatically), Master Data Services or Replication
Supported operating systems: Windows Server 2016 Datacenter, Standard, Essentials; Windows Server 2012 R2 Datacenter; Standard, Essentials, R2 Foundation; Windows Server 2012 Datacenter, Standard, Essentials, Foundation
SQL Server 2017 installation in Server Core mode is supported by the following Windows Server editions: Windows Server 2019 Standard, Datacenter; Windows Server 2016 Standard, Datacenter; Windows Server 2012 R2 Standard, Datacenter; Windows Server 2012 Standard, Datacenter

Other:

On 64-bit client operating systems, all SQL Server features are supported.
On 32-bit client operating systems, SQL Server 2017 2-Core these features are supported: SQL Client Connectivity SDK, Integration Services, Data Quality Client, Connectivity as well as backward compatibility of Clienttools and Clienttools SDK, furthermore Distributed Replay components, -controller and -Client as well as documentation components

Important info about used software for Microsoft SQL Server 2017 Enterprise 2-Core from Softwarehandel24

The offered used software for SQL Server 2017 Enterprise does not differ from a new SQL server license in terms of its usability - also because software does not wear out. This is further characterized by the following features:

Origin of used SQL Server 2017 Enterprise 2-Core licenses

The used SQL Server 2017 Enterprise 2-Core license software offered at Softwarehandel24 originates from a company located in Europe, which purchased it and later sold it to Softwarehandel24. When reselling, the SQL Server license is marked as used software, but it can be used again like a new license.

Buyer security also for used SQL Server 2017 Enterprise 2-Core licenses

Softwarehandel24 Used software at SQL Server 2017 Enterprise 2-Core offers you as a customer the same advantages as the purchase of a new Server software: the buyer security through the immediate download after completed purchase and the immediate license activation with the supplied valid license Key.

The purchase and use of used software to SQL Server 2017 Enterprise 2-Core is done legally

As a Softwarehandel24 customer you can be sure that both your purchase and your actual use of SQL Server 2017 Enterprise 2-Core as used software does not violate any valid laws. This is because the SQL Server software offered in the Softwarehandel24 store comes from a company's licensed inventory. The valid jurisdiction permits not only the trade with Microsoft used software, but also their actual use; these facts were already confirmed by several court decisions.

Your other advantages with a used SQL Server 2017 Enterprise 2-Core software from Softwarehandel24

Used software from Softwarehandel24 offers you on the one hand the great advantage of being able to update your older software stocks at a favorable price, but also to be always up-to-date with the latest versions, in addition more favorably than by the purchase of new hardware. Used software from Softwarehandel24 is also characterized by the complete proof of all buyers and thus also offers you audit security!

At Softwarehandel24 you will find not only the edition SQL Server 2017 Enterprise 2-Core inexpensive as used software, but also other editions to SQL Server 2017 as well as for licensing based on server/CAL licenses, as well as newer versions of Microsoft SQL Server; in addition, the used software portfolio of Softwarehandel24 also contains many other Microsoft programs - with all the advantages mentioned. If you have any questions regarding your Core-licensing of SQL Server 2017 Enterprise 2-Core please feel free to contact us via chat, e-mail or phone.

MICROSOFT SQL SERVER 2017 ENTERPRISE 2-CORE