Microsoft SQL Server 2017 Enterprise, 2 Core

Works On:
* The installation requires a minimum installation configuration. See System Requirements
£13,349.99

Product information "Microsoft SQL Server 2017 Enterprise, 2 Core"

Microsoft SQL Server 2017 Enterprise 2 Core Edition continues the success story of Microsoft's proprietary SQL Server software. The premium offering, SQL Server 2017 Enterprise Edition, delivers comprehensive, high-quality data center functionality with lightning-fast performance, unlimited virtualization, and end-to-end business intelligence - delivering high levels of service for mission-critical workloads and end-user access to data insight. This variant of SQL Server is aimed at customers who want to license their SQL Server by processor cores. All cores of the server's processors must be licensed, with a minimum of four cores per physical processor. In this case no further access licenses (CAL's) are required. Licensing by CPU cores: 2 CPU cores = 1 license, 4 CPU cores = 2 licenses Per Core Licensing (Physical Instance )All cores of the server's processors must be licensed, with a minimum of four (4) cores per physical processor . Per core licensing (virtual instance) Under the core licensing model, all virtual cores in each virtual machine (VM) must be licensed, and in any case, at least four core licenses per virtual machine (VM).   If you are interested, we will be happy to advise you on this or to prepare an individual offer, please contact us!
Species Full version
Licensing by processors/core
Language German, English/ all languages available
Field of application Microsoft SQL Server
 

What new features does Microsoft SQL Server 2017 bring with it?

The 2017 edition comes with many new enhancements, optimized performance, Linux compatibility and other database module features. In the Standard Edition, the software is particularly suitable for use in medium-sized scenarios. Decisive functions are, for example, the free choice of platform and programming language, both of which can also be managed via the cloud. Scalability, performance and availability have also been improved, and Microsoft itself states that SQL Server studies show that SQL Server is the least vulnerable database. The mobile interfaces have of course also been optimized. In just a few steps, raw data can now be graphically and structurally enhanced so that it can be displayed in a suitable form both on the tablet and on a smartphone. Other special new features include automatic tuning, Resumable Online Index Rebuilds and a dedicated graph database for better visualization.

SQL Server technologies:

database module:

The database module is the core service for storing, processing and backing up data. The database module provides controlled access and fast transaction processing. So you can also meet high requirements of data processing applications in your company. The database module also provides a wide range of support for maintaining high availability.

R-Services:

Microsoft R Services offers several ways to integrate the popular R language into enterprise workflows. R Services (In-Database) integrates the R language with SQL Server, so you can easily create, retrain and evaluate models by calling stored Transact-SQL procedures. Microsoft R Server provides scalable support for R in the enterprise on multiple platforms and supports data sources such as Hadoop and Teradata.

Data Quality Services:

SQL Server Data Quality Services (DQS) provides a knowledge-driven data cleansing solution. DQS allows you to create a knowledge base and then use that knowledge base to perform data correction and deduplication for your data using computer-aided and interactive means. You can use cloud-based reference data services and create a data management solution that integrates DQS with SQL Server Integration Services and Master Data Services.

Integration Services:

Integration Services is a design platform for high-performance data integration solutions, including data warehouse packages for extracting, transforming and loading (ETL) data.

Master Data Services:

Master Data Services is the SQL Server solution for master data management. A solution built on Master Data Services ensures that reporting and analysis are based on the right information. With Master Data Services, you create a central repository for master data and manage a monitorable and secure record of that data as it changes over time.

Analysis Services:

Analysis Services is a platform for analytical data and a business intelligence toolset for individuals, teams and companies. Server and client designers support traditional OLAP solutions, new table modeling solutions, and self-service capabilities for analysis and collaboration with Power Pivot, Excel, and a SharePoint Server environment. Analysis Services also includes data mining to help you identify the patterns and relationships hidden in large volumes of data.

Replication:

Replication is a set of technologies for copying and distributing data and database objects from one database to another and then synchronizing the databases to ensure data consistency. With replication, you can distribute data to multiple locations, remote or mobile users over local and wide area networks (WANs), dial-up connections, wireless connections, or the Internet.

Reporting Services:

Reporting Services provides Web-based reporting functionality for enterprises, so you can create reports that draw content from a variety of data sources, publish reports in a variety of formats, and centrally manage subscriptions and security.

Hardware requirements

The following memory and processor requirements apply to all editions of SQL Server:
HARDWARE REQUIREMENTS
Component Requirement
Hard Disk SQL Server requires a minimum of 6 GB of available hard-disk space. Disk space requirements will vary with the SQL Server components you install. For more information, see Hard Disk Space Requirements later in this article. For information on supported storage types for data files, see Storage Types for Data Files.
Monitor SQL Server requires Super-VGA (800x600) or higher resolution monitor.
Internet Internet functionality requires Internet access (fees may apply).
Memory * Minimum: Express Editions: 512 MB All other editions: 1 GB Recommended: Express Editions: 1 GB All other editions: At least 4 GB and should be increased as database size increases to ensure optimal performance.
Processor Speed Minimum: x64 Processor: 1.4 GHz Recommended: 2.0 GHz or faster
Processor Type x64 Processor: AMD Opteron, AMD Athlon 64, Intel Xeon with Intel EM64T support, Intel Pentium IV with EM64T support

 Note :  Installation of SQL Server is supported on x64 processors only. It is no longer supported on x86 processors.

* The minimum memory required for installing the Data Quality Server component in Data Quality Services (DQS) is 2 GB of RAM, which is different from the SQL Server minimum memory requirement. For information about installing DQS, see Install Data Quality Services.

Software requirements

The following requirements apply to all installations:
SOFTWARE REQUIREMENTS
Component Requirement
Operating system Windows 10 TH1 1507 or greater Windows Server 2016 or greater
.NET Framework Minimum operating systems includes minimum .NET framework.
Network Software Supported operating systems for SQL Server have built-in network software. Named and default instances of a stand-alone installation support the following network protocols: Shared memory, Named Pipes, and TCP/IP.
SQL Server Setup installs the following software components required by the product:
  • SQL Server Native Client
  • SQL Server Setup support files

Over 10K+ customers rated our service 5 stars