SQL server 2017 standard 10 core

SQL Server 2017 Standard 10 Core is a professional per-core relational database server licence providing the SQL Server 2017 Standard database engine, reporting services, high availability and business intelligence tools for servers with up to 10 licensed cores on Windows and Linux.

SQL Server 2017 Standard 10 Core – UK Digital Database Server Licence

SQL Server 2017 Standard 10 Core is a comprehensive per-core database server licence designed for organisations that need to licence SQL Server 2017 Standard on a server with up to 10 physical processor cores under the per-core licensing model. It is ideal for small to medium-sized businesses, IT departments, database administrators and application developers who need a reliable and scalable relational database platform for line-of-business applications, web applications, data warehousing and business intelligence workloads where per-core licensing is more appropriate than Server and Client Access Licence based licensing.

Per-core licensing is particularly well suited to environments where the number of users or devices accessing the SQL Server instance is large, variable or difficult to count, or where internet-facing applications serve an unrestricted or anonymous user base. A 10 core licence covers a server with up to 10 physical processor cores, with all physical cores on the server required to be licensed and a minimum of four core licences applying per physical processor. SQL Server 2017 Standard 10 Core provides the same feature set as the standard Server plus CAL edition, including the database engine, reporting services, basic high availability and business intelligence tools within the Standard edition limits.

For a complete data management setup, you can also explore our Microsoft software range, or consider Microsoft Office Access for desktop database front-end solutions alongside SQL Server for enterprise data management.

Important Notice About SQL Server 2017 Standard 10 Core

SQL Server 2017 Standard 10 Core is a per-core server licence covering up to 10 physical processor cores. All physical cores on the licensed server must be covered, with a minimum of four core licences required per physical processor. No Client Access Licences are required for users or devices accessing a per-core licensed SQL Server instance. SQL Server 2017 Standard is subject to feature limitations compared to SQL Server 2017 Enterprise, including a maximum of 128 GB of buffer pool memory and basic Always On Availability Groups limited to two nodes. Please review the SQL Server 2017 edition comparison to confirm Standard edition meets your requirements before purchasing.

Internet connectivity may be required during the initial activation process. SQL Server 2017 runs on Windows Server 2012 R2 and later as well as supported Linux distributions.

Why Choose SQL Server 2017 Standard 10 Core?

• Per-core licensing covering up to 10 physical processor cores on a single server
• No Client Access Licences required for users or devices accessing the server
• Ideal for internet-facing applications and environments with large or variable user numbers
• Native Linux and Docker container support for flexible deployment options
• Graph database support for modelling and querying complex entity relationships
• Adaptive query processing for improved query performance without manual tuning
• Python and R integration for in-database machine learning and advanced analytics
• SQL Server Reporting Services for professional report creation and delivery
• Perpetual licence with lifetime access to SQL Server 2017 Standard
• Digital delivery by email after order confirmation

Key Features of SQL Server 2017 Standard 10 Core

• Per-Core Licensing: This 10 core licence covers all physical processor cores on the target server under the per-core licensing model, eliminating the need for Client Access Licences for users and devices and providing an appropriate licensing model for environments with large, variable or anonymous user bases.
• Relational Database Engine: Store, manage and query structured data using the SQL Server relational database engine with full T-SQL language support, stored procedures, triggers, views, functions and comprehensive transaction management for enterprise data workloads.
• Linux and Docker Support: Deploy SQL Server 2017 on Linux distributions including Red Hat Enterprise Linux, SUSE Linux Enterprise Server and Ubuntu, or in Docker containers for flexible and modern infrastructure deployment options alongside traditional Windows Server deployments.
• Graph Database: Model and query complex many-to-many relationships and network data using the graph database extensions introduced in SQL Server 2017, with node and edge tables and graph-specific query syntax for social networks, recommendation engines and fraud detection scenarios.
• Adaptive Query Processing: Benefit from automatic query performance improvements through adaptive query processing features including batch mode memory grant feedback, batch mode adaptive joins and interleaved execution that adjust query execution plans based on actual runtime statistics.
• Python and R Integration: Run Python and R scripts directly within the SQL Server engine using Machine Learning Services for in-database machine learning, predictive analytics and advanced data processing without moving data outside the database.
• High Availability: Implement high availability and disaster recovery solutions using Always On Failover Cluster Instances and basic Always On Availability Groups limited to two nodes within the Standard edition feature set.
• SQL Server Reporting Services: Create, manage and deliver professional paginated reports, interactive reports and dashboards using SQL Server Reporting Services with a web-based report portal for self-service and enterprise reporting.
• SQL Server Agent: Automate database maintenance tasks, scheduled jobs, alerts and notifications using SQL Server Agent for reliable and consistent database administration automation.
• Replication: Distribute and synchronise database objects and data between servers using transactional, snapshot and merge replication for data distribution, reporting offloading and data consolidation scenarios.
• Security: Protect sensitive data using row-level security, dynamic data masking, transparent data encryption, Always Encrypted and comprehensive auditing capabilities for regulatory compliance and data protection.
• Backup and Recovery: Protect database data with comprehensive backup and recovery capabilities including full, differential and transaction log backups, point-in-time recovery and backup to Microsoft Azure Blob Storage for off-site data protection.

SQL Server 2017 Standard 10 Core vs Standard Server+CAL, Enterprise 10 Core, SQL Server 2019 and Azure SQL

SQL Server 2017 Standard 10 Core is a per-core licence for servers with up to 10 cores and no CAL requirement. Standard Server+CAL is an alternative licensing model requiring user or device CALs, Enterprise 10 Core removes Standard edition feature limits, SQL Server 2019 Standard is a newer release, while Azure SQL is a fully managed cloud database service.

Which Licence Should You Choose?

• Choose SQL Server 2017 Standard 10 Core if you need to licence SQL Server 2017 Standard on a server with up to 10 physical processor cores under the per-core model, particularly for internet-facing applications or environments with large or variable numbers of users and devices.
• Choose SQL Server 2017 Standard Server + CAL if you have a small and fixed number of known internal users or devices accessing the server and prefer the Server plus CAL licensing model.
• Choose SQL Server 2017 Enterprise 10 Core if you need the full SQL Server Enterprise feature set without Standard edition memory limits, compression restrictions or availability group limitations.
• Choose SQL Server 2019 Standard 10 Core if you need a more recent SQL Server release with updated features including accelerated database recovery and improved performance.
• Choose Azure SQL if you need a fully managed cloud-based database service with automatic patching, scaling and built-in high availability without managing server infrastructure.

Recommended Products

• Microsoft Software – explore the full range of Microsoft software products.
• SQL Server 2017 Standard Server + CAL – suitable if the Server plus CAL licensing model is more appropriate for your environment.
• Microsoft Office Access 2024 – suitable for desktop database front-end applications connecting to SQL Server.
• Windows Server Licences – suitable if you need a compatible Windows Server operating system for SQL Server deployment.
• Microsoft Project – suitable for planning and managing database implementation projects.
• Microsoft Office – explore all available Microsoft software versions and licence options.

System Requirements for SQL Server 2017 Standard 10 Core

Delivery and Activation

• Product: SQL Server 2017 Standard 10 Core
• Platform: Windows Server or Linux
• Licence Type: Perpetual per-core server licence (10 cores)
• Licence Duration: Lifetime access to SQL Server 2017 Standard
• Delivery Method: Digital delivery by email
• Activation: Activation instructions provided after purchase
• Support: Installation and activation assistance available

How to Get Started

1. Complete your order for SQL Server 2017 Standard 10 Core.
2. Receive your product key and activation instructions by email after order confirmation.
3. Check that your server meets the SQL Server 2017 Standard system requirements.
4. Confirm that the total number of physical processor cores on your server does not exceed 10.
5. Download the SQL Server 2017 Standard installer from the Microsoft website.
6. Run the SQL Server installation wizard and select the features and components you require.
7. Enter your product key when prompted to activate your perpetual per-core licence.
8. Contact our support team if you need help with installation or activation.

Who Is SQL Server 2017 Standard 10 Core For?

• Organisations running internet-facing applications with large or anonymous user bases
• Businesses with a large or variable number of users accessing SQL Server databases
• IT departments where counting and managing individual user or device CALs is impractical
• Database administrators managing SQL Server instances on servers with up to 10 physical cores
• Application developers building database-driven web applications on servers with up to 10 cores
• Organisations deploying SQL Server 2017 on Linux or in Docker containers
• Users upgrading from SQL Server 2014 Standard or earlier to the 2017 Standard 10 Core release

Important Licence Information

SQL Server 2017 Standard 10 Core is a perpetual per-core server licence covering up to 10 physical processor cores. All physical cores on the licensed server must be covered, with a minimum of four core licences required per physical processor. No Client Access Licences are required for users or devices accessing a per-core licensed SQL Server instance. This licence covers a single server installation only.

SQL Server 2017 Standard has Standard edition feature limits including a maximum of 128 GB of buffer pool memory and basic Always On Availability Groups limited to two nodes. If your server has more than 10 physical processor cores, additional core licences will be required to cover all cores. Before purchasing, please count the total number of physical processor cores on your server and confirm that the Standard edition feature set meets your database workload requirements.