MICROSOFT SQL SERVER 2017 ENTERPRISE 2-CORE

The SQL Server 2017 Enterprise  edition provides larger companies with a powerful newer version of the proven relational data platform from Microsoft, which combines all the critical database, reporting and analysis functions and combines 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.

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

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 Wiresoft 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 Wiresoft

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 Wiresoft originates from a company located in Europe, which purchased it and later sold it to Wiresoft. 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

Wiresoft 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 Wiresoft 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 Wiresoft 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 Wiresoft

Used software from Wiresoft 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 Wiresoft is also characterized by the complete proof of all buyers and thus also offers you audit security!

At Wiresoft 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 Wiresoft 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.