{"title":"SQL Server","description":null,"products":[{"product_id":"microsoft-sql-server-2014-standard-retail-1-pc","title":"Microsoft SQL Server 2014 Standard Retail [1 PC]","description":"\u003ch2\u003eMicrosoft SQL Server 2014 Standard for Departmental Workloads\u003c\/h2\u003e\n\u003cp\u003e\u003ca href=\"\/products\/microsoft-sql-server-2014-standard-retail-1-pc\"\u003eMicrosoft SQL Server 2014 Standard\u003c\/a\u003e is the mid-tier relational database management system for line-of-business applications, departmental reporting, and small-to-mid-size database servers. The 2014 release introduced the in-memory OLTP engine (Hekaton) for high-throughput transactional workloads, enhanced AlwaysOn availability groups, ColumnStore indexes for fast analytical queries, and tighter integration with SharePoint 2013 for self-service reporting. SQL Server 2014 Standard is delivered as a one-time, perpetual license for one Windows Server instance. Activation is a clean one-time step on the target Windows Server — paste the 25-character product key into the SQL Server setup wizard, choose the Standard edition features you need, and the instance is online with the in-memory OLTP, AlwaysOn, and ColumnStore features ready for production line-of-business workloads. Every SQL Server key is sourced directly from Microsoft authorized channels and delivered to your account dashboard the moment your payment clears, so activation goes through cleanly without invalid-key errors and the same key reactivates on the same server after a rebuild or hardware swap. SQL Server Standard follows Microsoft's per-core plus CAL model: the 1PC license covers the database engine on one server (up to 24 cores per instance), with separate CALs required for each user or device that connects. 🗄️ ⚡\u003c\/p\u003e\n\n\u003ch2\u003eWhat Is Included and How Activation Works\u003c\/h2\u003e\n\u003cp\u003eYour 1PC Retail Online license includes one Microsoft SQL Server 2014 Standard product key that activates the database engine and the core management tools on one Windows Server instance. The license is perpetual, so there are no subscription fees to manage. The same key can be used to reactivate SQL Server 2014 Standard on the same server after a clean reinstall of the operating system or after a hardware refresh.\u003c\/p\u003e\n\u003cp\u003eTo activate, run the SQL Server 2014 Standard installer on the target Windows Server, enter the 25-character product key when prompted, and complete the online activation against the Microsoft activation service. An internet connection is required only for activation and for downloading updates; the database engine runs entirely offline once activated.\u003c\/p\u003e\n\n\u003ch2\u003eKey Features and Capabilities\u003c\/h2\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRelational database engine\u003c\/strong\u003e — full T-SQL support, stored procedures, triggers, views, and user-defined functions; the engine handles small departmental databases up to 524 PB of storage per database with 32 GB buffer pool memory in the Standard edition.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIn-memory OLTP (Hekaton)\u003c\/strong\u003e — memory-optimised tables and natively compiled stored procedures that deliver up to a 30x throughput improvement for high-concurrency transactional workloads without rewriting the application.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAlwaysOn availability groups\u003c\/strong\u003e — high availability and disaster recovery with up to two secondary replicas, automatic failover, and readable secondaries for offloading reporting workloads.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eColumnStore indexes\u003c\/strong\u003e — clustered and non-clustered columnstore indexes for fast analytical queries on large fact tables, suitable for data warehouse and reporting scenarios.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntegration Services\u003c\/strong\u003e — extract-transform-load workflows, data movement, and package execution for ETL scenarios that consolidate data from multiple sources.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSQL Server Management Studio\u003c\/strong\u003e — administration, query authoring, execution plans, performance tuning, and security management from a single integrated IDE.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSecurity baseline\u003c\/strong\u003e — native backup encryption, SQL Server Audit, transparent data encryption, and row-level security for regulated workloads.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eResource governor\u003c\/strong\u003e — predictable performance on shared servers by capping CPU, memory, and I\/O for specific workloads or applications.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003ePower View and PowerPivot\u003c\/strong\u003e — self-service reporting and interactive data exploration when paired with SharePoint 2013.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMigration compatibility\u003c\/strong\u003e — database compatibility level support for SQL Server 2012, with a clear migration path to \u003ca href=\"\/products\/microsoft-sql-server-2016-standard-retail-1-pc\"\u003eSQL Server 2016\u003c\/a\u003e and \u003ca href=\"\/products\/microsoft-sql-server-2017-standard-retail-1-pc\"\u003eSQL Server 2017\u003c\/a\u003e for staged upgrades.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch2\u003eWho This Edition Is For\u003c\/h2\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLine-of-business application owners\u003c\/strong\u003e running departmental databases on a single Windows Server instance with mid-size transactional and reporting workloads.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eInternal IT and database administrators\u003c\/strong\u003e managing small-to-mid-size SQL Server instances for application development, reporting, and analytics.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRegulated industries\u003c\/strong\u003e that need transparent data encryption, SQL Server Audit, and row-level security as part of the standard feature set.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOrganisations standardising on Windows Server 2012 or Windows Server 2012 R2\u003c\/strong\u003e and looking for a perpetual relational database engine with the in-memory OLTP and AlwaysOn enhancements introduced in SQL Server 2014.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch2\u003eStandard vs Enterprise: What SQL Server Adds\u003c\/h2\u003e\n\u003cp\u003eSQL Server Standard includes the core relational database engine, in-memory OLTP with limited memory, AlwaysOn availability groups with two replicas, ColumnStore indexes, and the security baseline. SQL Server Enterprise adds the features that an organisation needs when the database is large, mission-critical, or both: unlimited in-memory OLTP, advanced AlwaysOn with up to eight readable replicas, partitioning, data compression, advanced security features, and the full Machine Learning Services runtime. Big Data Clusters, which combine SQL Server, Spark, and HDFS into a single Kubernetes-based cluster, are an Enterprise-only feature.\u003c\/p\u003e\n\u003cp\u003eFor departmental applications, line-of-business workloads, and small-to-mid-size database servers, Standard is the right fit. For very large databases, mission-critical transactional systems, and analytics at petabyte scale, Enterprise is the typical choice. The perpetual license model means the chosen edition stays available on the licensed Windows Server instance for the lifetime of the installation, with no monthly fees to manage.\u003c\/p\u003e\n\n\u003ch2\u003eCommon Workflows and Use Cases\u003c\/h2\u003e\n\u003cp\u003e\u003cstrong\u003eLine-of-business application hosting.\u003c\/strong\u003e SQL Server Standard hosts the database backend for the line-of-business applications that the organisation depends on: ERP, CRM, HR, finance, and the custom in-house tools. Always Encrypted, row-level security, and dynamic data masking (in the 2016 generation and later) protect sensitive data, while AlwaysOn availability groups keep the application online through planned and unplanned outages. SSMS and Azure Data Studio provide the administration, query authoring, and performance tuning tools that the database team needs.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eDepartmental reporting and analytics.\u003c\/strong\u003e The combination of SQL Server Standard, SQL Server Reporting Services, SQL Server Integration Services, and SQL Server Analysis Services provides a complete BI platform for departmental reporting. Power View and PowerPivot (in the 2014 and 2016 generations) and the modern Power BI integration (in the 2017 and 2019 generations) make the analytical output available to business users in self-service mode.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eApplication development and testing.\u003c\/strong\u003e The Standard edition is a common fit for development, test, and staging environments, where the database team needs a faithful reproduction of the production schema and feature set without the Enterprise licensing cost. The Intelligent Query Processing and Accelerated Database Recovery features (in the 2019 generation) reduce the time spent on query tuning and crash recovery, which is valuable in fast-moving development environments.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eMid-size transactional database.\u003c\/strong\u003e For a mid-size transactional database (up to 4 sockets or 16 cores, which is the Standard edition limit), the in-memory OLTP and ColumnStore indexes provide high-throughput transactional and analytical performance. The compatibility levels across SQL Server 2014, 2016, 2017, and 2019 provide a clear migration path to a newer generation when the workload outgrows the current version.\u003c\/p\u003e\n\n\u003ch2\u003eSystem Requirements\u003c\/h2\u003e\n\u003ctable\u003e\n  \u003cthead\u003e\n    \u003ctr\u003e\n\u003cth\u003eComponent\u003c\/th\u003e\n\u003cth\u003eMinimum\u003c\/th\u003e\n\u003cth\u003eRecommended\u003c\/th\u003e\n\u003c\/tr\u003e\n  \u003c\/thead\u003e\n  \u003ctbody\u003e\n    \u003ctr\u003e\n\u003ctd\u003eOperating system\u003c\/td\u003e\n\u003ctd\u003eWindows Server 2012, Windows Server 2012 R2, Windows Server 2008 R2 SP1, Windows 8.1, Windows 8, Windows 7 SP1 (64-bit editions only)\u003c\/td\u003e\n\u003ctd\u003eWindows Server 2012 R2 (64-bit)\u003c\/td\u003e\n\u003c\/tr\u003e\n    \u003ctr\u003e\n\u003ctd\u003eProcessor\u003c\/td\u003e\n\u003ctd\u003ex64 processor at 1.4 GHz or faster\u003c\/td\u003e\n\u003ctd\u003e2.0 GHz or faster, multi-core\u003c\/td\u003e\n\u003c\/tr\u003e\n    \u003ctr\u003e\n\u003ctd\u003eMemory (RAM)\u003c\/td\u003e\n\u003ctd\u003e1 GB (Express: 512 MB)\u003c\/td\u003e\n\u003ctd\u003e4 GB or more, scaling with database size and workload\u003c\/td\u003e\n\u003c\/tr\u003e\n    \u003ctr\u003e\n\u003ctd\u003eHard disk space\u003c\/td\u003e\n\u003ctd\u003e6 GB available\u003c\/td\u003e\n\u003ctd\u003eSSD with 20 GB or more for system databases, tempdb, and user data\u003c\/td\u003e\n\u003c\/tr\u003e\n    \u003ctr\u003e\n\u003ctd\u003eDisplay\u003c\/td\u003e\n\u003ctd\u003eSuper-VGA (800 × 600) or higher\u003c\/td\u003e\n\u003ctd\u003e1280 × 1024 or higher for Management Studio\u003c\/td\u003e\n\u003c\/tr\u003e\n    \u003ctr\u003e\n\u003ctd\u003e.NET Framework\u003c\/td\u003e\n\u003ctd\u003e.NET 3.5 SP1 and .NET 4.0 or later\u003c\/td\u003e\n\u003ctd\u003e.NET 4.5 or later\u003c\/td\u003e\n\u003c\/tr\u003e\n  \u003c\/tbody\u003e\n\u003c\/table\u003e\n\n\u003ch2\u003eActivation and Licensing Notes\u003c\/h2\u003e\n\u003cp\u003eThe 1PC Retail Online key is a perpetual license for Microsoft SQL Server 2014 Standard on one Windows Server instance. The license covers one physical or one virtual instance of the database engine on the server. To run a second named instance on the same server hardware, a second SQL Server 2014 Standard license is required.\u003c\/p\u003e\n\u003cp\u003eSQL Server 2014 Standard supports only 64-bit editions of Windows. 32-bit operating systems are not supported. AlwaysOn availability groups in the Standard edition are limited to two replicas (one primary and one secondary); the Enterprise edition is required for additional replicas and advanced availability features.\u003c\/p\u003e\n\n\u003ch2\u003eIntegration with the Microsoft Ecosystem\u003c\/h2\u003e\n\u003cp\u003eSQL Server 2014 Standard integrates with the rest of the Microsoft data platform in well-established ways. SQL Server Management Studio is the administration IDE, and it connects to Analysis Services, Integration Services, and Reporting Services in addition to the relational engine. Power BI can connect to SQL Server 2014 as a data source, which is the recommended path for self-service dashboards built on top of a SQL Server 2014 database. SharePoint 2013 integrates with SQL Server 2014 Reporting Services for SharePoint mode, which lets users view reports inside SharePoint. The .NET Framework and Visual Studio provide the application development path, with the .NET Framework Data Provider for SQL Server and the Entity Framework as the standard data access layer.\u003c\/p\u003e\n\u003cp\u003eThe migration path from SQL Server 2014 to a newer generation is well supported. The database compatibility level 120 is the default for SQL Server 2014, and the engine can be upgraded in place to SQL Server 2016, 2017, or 2019. The Database Migration Assistant and the SQL Server Upgrade Advisor help identify breaking changes and deprecated features before the upgrade begins. For a staged migration, the existing 2014 instance can run side by side with the newer instance, and the data can be moved through transactional replication, log shipping, or AlwaysOn availability groups.\u003c\/p\u003e\n\n\u003ch2\u003eGet Started With Microsoft SQL Server 2014 Standard\u003c\/h2\u003e\n\u003cp\u003eDownload the SQL Server 2014 Standard installer from the Microsoft volume licensing center or a trusted source, run it on the target Windows Server instance, enter your 1PC product key, and follow the installation wizard to select the database engine, management tools, and the optional integration services, reporting services, and analysis services. The SQL Server 2014 Quick Start guide and the Books Online documentation cover the most common administration and performance tuning scenarios. With a perpetual license, your organisation has a stable, professionally supported relational database engine on one Windows Server for as long as the installation remains in service.\u003c\/p\u003e\u003ch2\u003eMicrosoft SQL Server 2014 Standard Alternatives\u003c\/h2\u003e\n\u003cp\u003eThree credible alternatives cover most relational database workloads.\u003c\/p\u003e\n\u003ch3\u003ePostgreSQL\u003c\/h3\u003e\u003cp\u003eFree and open-source relational database with strong JSON support, advanced indexing, and an active community. Best fit for new application development and analytics workloads.\u003c\/p\u003e\u003ch3\u003eMySQL or MariaDB\u003c\/h3\u003e\u003cp\u003eFree and widely supported. Best fit for LAMP-stack web applications and read-heavy workloads.\u003c\/p\u003e\u003ch3\u003eAzure SQL or Amazon RDS for SQL Server\u003c\/h3\u003e\u003cp\u003eManaged cloud versions of SQL Server with automatic patching, backups, and high availability. Best fit when you want to remove operational overhead.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eHow to choose:\u003c\/strong\u003e Stay on SQL Server for deep Microsoft stack integration, mature tooling, and enterprise features like Always Encrypted, Service Broker, and SQL Server Agent. Choose PostgreSQL for new open-source or analytics workloads. Choose MySQL for simple LAMP web applications. Choose Azure SQL or RDS for managed cloud operation.\u003c\/p\u003e\n\n\u003ch2\u003eFrequently Asked Questions\u003c\/h2\u003e\n\u003cdetails\u003e\n  \u003csummary\u003eWhat is the difference between SQL Server 2014 Standard and Enterprise?\u003c\/summary\u003e\n  \u003cp\u003eSQL Server 2014 Standard includes the core relational engine, in-memory OLTP with limited memory, AlwaysOn with two replicas, ColumnStore indexes, and the security baseline. SQL Server 2014 Enterprise adds unlimited in-memory OLTP, advanced AlwaysOn with up to eight readable replicas, advanced security features such as Always Encrypted, partitioning, data compression, and the full set of management tools.\u003c\/p\u003e\n\u003c\/details\u003e\n\u003cdetails\u003e\n  \u003csummary\u003eCan SQL Server 2014 Standard run on Windows Server 2016 or 2019?\u003c\/summary\u003e\n  \u003cp\u003eSQL Server 2014 is supported on Windows Server 2012 and 2012 R2 as a primary target, with Windows Server 2016 listed as a supported operating system in certain configurations. For new deployments on Windows Server 2019 or 2022, a newer SQL Server version such as 2017 or 2019 is recommended.\u003c\/p\u003e\n\u003c\/details\u003e\n\u003cdetails\u003e\n  \u003csummary\u003eHow many cores does the Standard edition support?\u003c\/summary\u003e\n  \u003cp\u003eSQL Server 2014 Standard supports up to the lesser of 4 sockets or 16 physical cores. SQL Server 2014 Enterprise does not have a socket or core limit within the supported operating system.\u003c\/p\u003e\n\u003c\/details\u003e\n\u003cdetails\u003e\n  \u003csummary\u003eDoes the Standard edition include SQL Server Reporting Services?\u003c\/summary\u003e\n  \u003cp\u003eSQL Server 2014 Standard includes SQL Server Reporting Services (SSRS) in a built-in mode, which is suitable for departmental reporting and embedded reports. The SharePoint-integrated mode of SSRS requires SharePoint 2013 to be deployed and is the recommended pattern for self-service Power View and PowerPivot reports.\u003c\/p\u003e\n\u003c\/details\u003e\n\u003cdetails\u003e\n  \u003csummary\u003eIs internet access required to use the database engine?\u003c\/summary\u003e\n  \u003cp\u003eNo. Once SQL Server 2014 Standard is activated, the database engine runs entirely offline. An internet connection is only required for activation, updates, and the optional Azure hybrid features that SQL Server 2014 introduces.\u003c\/p\u003e\n\u003c\/details\u003e\n\n","brand":"Microsoft","offers":[{"title":"Default Title","offer_id":59850909483089,"sku":"MS-054-MICROSOFT-SQL-SERVER-2014-STANDARD-RETAI","price":19.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1059\/0191\/6241\/files\/microsoft-sql-server-2014-standard-retail-1-pc.webp?v=1784725531"},{"product_id":"microsoft-sql-server-2016-standard-retail-1-pc","title":"Microsoft SQL Server 2016 Standard Retail [1 PC]","description":"\u003ch2\u003eMicrosoft SQL Server 2016 Standard for Mid-Size Database Servers\u003c\/h2\u003e\n\u003cp\u003e\u003ca href=\"\/products\/microsoft-sql-server-2016-standard-retail-1-pc\"\u003eMicrosoft SQL Server 2016 Standard\u003c\/a\u003e is the mid-tier relational database management system for line-of-business applications, departmental reporting, and mid-size database servers. The 2016 release introduces Always Encrypted, row-level security, Temporal Tables, and native JSON support, which together deliver a meaningful security and developer-experience improvement over SQL Server 2014. The release also adds basic R integration for in-database analytics and Stretch Database for transparently moving cold data to Azure SQL Database. SQL Server 2016 Standard is delivered as a one-time, perpetual license for one Windows Server instance. Activation is a clean one-time step on the target Windows Server — paste the 25-character product key into the SQL Server setup wizard, and the instance is online with Always Encrypted, row-level security, Temporal Tables, and native JSON support ready for production workloads from the first connection. Every SQL Server key is sourced directly from Microsoft authorized channels and delivered to your account dashboard the moment your payment clears, so activation goes through cleanly without invalid-key errors and the same key reactivates on the same server after a rebuild or hardware swap. SQL Server Standard follows Microsoft's per-core plus CAL model: the 1PC license covers the database engine on one server (up to 24 cores per instance), with separate CALs required for each user or device that connects. 🗄️ ⚡\u003c\/p\u003e\n\n\u003ch2\u003eWhat Is Included and How Activation Works\u003c\/h2\u003e\n\u003cp\u003eYour 1PC Retail Online license includes one Microsoft SQL Server 2016 Standard product key that activates the database engine and the core management tools on one Windows Server instance. The license is perpetual, so there are no subscription fees to manage. The same key can be used to reactivate SQL Server 2016 Standard on the same server after a clean reinstall of the operating system or after a hardware refresh.\u003c\/p\u003e\n\u003cp\u003eTo activate, run the SQL Server 2016 Standard installer on the target Windows Server, enter the 25-character product key when prompted, and complete the online activation against the Microsoft activation service. An internet connection is required only for activation and for downloading updates; the database engine runs entirely offline once activated.\u003c\/p\u003e\n\n\u003ch2\u003eKey Features and Capabilities\u003c\/h2\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRelational database engine\u003c\/strong\u003e — full T-SQL support, stored procedures, triggers, views, and user-defined functions; the engine handles mid-size transactional and analytical workloads on a single Windows Server instance.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAlways Encrypted\u003c\/strong\u003e — protect sensitive columns such as credit card numbers, social security numbers, and personal identifiers at rest and in motion, without requiring changes to the application code.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRow-level security\u003c\/strong\u003e — enforce access policies at the database layer so that users see only the rows they are authorised to view, regardless of the application that queries the data.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eTemporal Tables\u003c\/strong\u003e — automatically track historical changes to data with system-versioned tables; query the data as it existed at any point in time for audit, debugging, and trend analysis.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eNative JSON support\u003c\/strong\u003e — store, index, and query JSON documents directly in SQL Server 2016 using the JSON data type, JSON functions, and the FOR JSON clause.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAlwaysOn availability groups\u003c\/strong\u003e — high availability and disaster recovery with up to two secondary replicas, automatic failover, and readable secondaries for offloading reporting workloads.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIn-memory OLTP and ColumnStore indexes\u003c\/strong\u003e — high-throughput transactional and analytical performance with memory-optimised tables, natively compiled stored procedures, and columnstore indexes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eR Services\u003c\/strong\u003e — run R scripts inside the database engine for in-database analytics; the standard edition includes basic R integration with a sandboxed runtime.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eStretch Database\u003c\/strong\u003e — transparently move cold historical data from SQL Server 2016 to Azure SQL Database, keeping hot data on premises and cold data in the cloud.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSQL Server Management Studio and Tools\u003c\/strong\u003e — administration, query authoring, execution plans, performance tuning, and security management from a single integrated IDE.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch2\u003eWho This Edition Is For\u003c\/h2\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLine-of-business application owners\u003c\/strong\u003e running mid-size departmental databases on a single Windows Server instance with the new security and developer features that SQL Server 2016 introduces.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eInternal IT and database administrators\u003c\/strong\u003e managing SQL Server instances for application development, reporting, and analytics with row-level security and Always Encrypted as part of the standard feature set.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRegulated industries\u003c\/strong\u003e that need Always Encrypted, row-level security, and Temporal Tables for compliance with data protection requirements.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eDevelopers building modern applications\u003c\/strong\u003e that need native JSON support, Temporal Tables, and the basic R integration that SQL Server 2016 Standard provides.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch2\u003eStandard vs Enterprise: What SQL Server Adds\u003c\/h2\u003e\n\u003cp\u003eSQL Server Standard includes the core relational database engine, in-memory OLTP with limited memory, AlwaysOn availability groups with two replicas, ColumnStore indexes, and the security baseline. SQL Server Enterprise adds the features that an organisation needs when the database is large, mission-critical, or both: unlimited in-memory OLTP, advanced AlwaysOn with up to eight readable replicas, partitioning, data compression, advanced security features, and the full Machine Learning Services runtime. Big Data Clusters, which combine SQL Server, Spark, and HDFS into a single Kubernetes-based cluster, are an Enterprise-only feature.\u003c\/p\u003e\n\u003cp\u003eFor departmental applications, line-of-business workloads, and small-to-mid-size database servers, Standard is the right fit. For very large databases, mission-critical transactional systems, and analytics at petabyte scale, Enterprise is the typical choice. The perpetual license model means the chosen edition stays available on the licensed Windows Server instance for the lifetime of the installation, with no monthly fees to manage.\u003c\/p\u003e\n\n\u003ch2\u003eCommon Workflows and Use Cases\u003c\/h2\u003e\n\u003cp\u003e\u003cstrong\u003eLine-of-business application hosting.\u003c\/strong\u003e SQL Server Standard hosts the database backend for the line-of-business applications that the organisation depends on: ERP, CRM, HR, finance, and the custom in-house tools. Always Encrypted, row-level security, and dynamic data masking (in the 2016 generation and later) protect sensitive data, while AlwaysOn availability groups keep the application online through planned and unplanned outages. SSMS and Azure Data Studio provide the administration, query authoring, and performance tuning tools that the database team needs.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eDepartmental reporting and analytics.\u003c\/strong\u003e The combination of SQL Server Standard, SQL Server Reporting Services, SQL Server Integration Services, and SQL Server Analysis Services provides a complete BI platform for departmental reporting. Power View and PowerPivot (in the 2014 and 2016 generations) and the modern Power BI integration (in the 2017 and 2019 generations) make the analytical output available to business users in self-service mode.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eApplication development and testing.\u003c\/strong\u003e The Standard edition is a common fit for development, test, and staging environments, where the database team needs a faithful reproduction of the production schema and feature set without the Enterprise licensing cost. The Intelligent Query Processing and Accelerated Database Recovery features (in the 2019 generation) reduce the time spent on query tuning and crash recovery, which is valuable in fast-moving development environments.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eMid-size transactional database.\u003c\/strong\u003e For a mid-size transactional database (up to 4 sockets or 16 cores, which is the Standard edition limit), the in-memory OLTP and ColumnStore indexes provide high-throughput transactional and analytical performance. The compatibility levels across SQL Server 2014, 2016, 2017, and 2019 provide a clear migration path to a newer generation when the workload outgrows the current version.\u003c\/p\u003e\n\n\u003ch2\u003eSystem Requirements\u003c\/h2\u003e\n\u003ctable\u003e\n  \u003cthead\u003e\n    \u003ctr\u003e\n\u003cth\u003eComponent\u003c\/th\u003e\n\u003cth\u003eMinimum\u003c\/th\u003e\n\u003cth\u003eRecommended\u003c\/th\u003e\n\u003c\/tr\u003e\n  \u003c\/thead\u003e\n  \u003ctbody\u003e\n    \u003ctr\u003e\n\u003ctd\u003eOperating system\u003c\/td\u003e\n\u003ctd\u003eWindows 10, Windows 8.1, Windows 8, Windows 7 SP1, Windows Server 2016, Windows Server 2012 R2, Windows Server 2012, Windows Server 2008 R2 SP1 (64-bit editions only)\u003c\/td\u003e\n\u003ctd\u003eWindows Server 2016 (64-bit)\u003c\/td\u003e\n\u003c\/tr\u003e\n    \u003ctr\u003e\n\u003ctd\u003eProcessor\u003c\/td\u003e\n\u003ctd\u003ex64 processor at 1.4 GHz or faster\u003c\/td\u003e\n\u003ctd\u003e2.0 GHz or faster, multi-core\u003c\/td\u003e\n\u003c\/tr\u003e\n    \u003ctr\u003e\n\u003ctd\u003eMemory (RAM)\u003c\/td\u003e\n\u003ctd\u003e1 GB (Express: 512 MB)\u003c\/td\u003e\n\u003ctd\u003e4 GB or more, scaling with database size and workload\u003c\/td\u003e\n\u003c\/tr\u003e\n    \u003ctr\u003e\n\u003ctd\u003eHard disk space\u003c\/td\u003e\n\u003ctd\u003e6 GB available\u003c\/td\u003e\n\u003ctd\u003eSSD with 20 GB or more for system databases, tempdb, and user data\u003c\/td\u003e\n\u003c\/tr\u003e\n    \u003ctr\u003e\n\u003ctd\u003eDisplay\u003c\/td\u003e\n\u003ctd\u003eSuper-VGA (800 × 600) or higher\u003c\/td\u003e\n\u003ctd\u003e1280 × 1024 or higher for Management Studio\u003c\/td\u003e\n\u003c\/tr\u003e\n    \u003ctr\u003e\n\u003ctd\u003e.NET Framework\u003c\/td\u003e\n\u003ctd\u003e.NET 4.6 or later\u003c\/td\u003e\n\u003ctd\u003e.NET 4.6.2 or later\u003c\/td\u003e\n\u003c\/tr\u003e\n  \u003c\/tbody\u003e\n\u003c\/table\u003e\n\n\u003ch2\u003eActivation and Licensing Notes\u003c\/h2\u003e\n\u003cp\u003eThe 1PC Retail Online key is a perpetual license for Microsoft SQL Server 2016 Standard on one Windows Server instance. The license covers one physical or one virtual instance of the database engine on the server. To run a second named instance on the same server hardware, a second SQL Server 2016 Standard license is required.\u003c\/p\u003e\n\u003cp\u003eSQL Server 2016 Standard supports only 64-bit editions of Windows. 32-bit operating systems are not supported. AlwaysOn availability groups in the Standard edition are limited to two replicas (one primary and one secondary); the Enterprise edition is required for additional replicas and advanced availability features. R Services in the Standard edition is restricted to a sandboxed runtime that limits the libraries available.\u003c\/p\u003e\n\n\u003ch2\u003eIntegration with the Microsoft Ecosystem\u003c\/h2\u003e\n\u003cp\u003e\u003ca href=\"\/products\/microsoft-sql-server-2014-standard-retail-1-pc\"\u003eSQL Server 2014 Standard\u003c\/a\u003e integrates with the rest of the Microsoft data platform in well-established ways. SQL Server Management Studio is the administration IDE, and it connects to Analysis Services, Integration Services, and Reporting Services in addition to the relational engine. Power BI can connect to SQL Server 2014 as a data source, which is the recommended path for self-service dashboards built on top of a SQL Server 2014 database. SharePoint 2013 integrates with SQL Server 2014 Reporting Services for SharePoint mode, which lets users view reports inside SharePoint. The .NET Framework and Visual Studio provide the application development path, with the .NET Framework Data Provider for SQL Server and the Entity Framework as the standard data access layer.\u003c\/p\u003e\n\u003cp\u003eThe migration path from SQL Server 2014 to a newer generation is well supported. The database compatibility level 120 is the default for SQL Server 2014, and the engine can be upgraded in place to SQL Server 2016, 2017, or 2019. The Database Migration Assistant and the SQL Server Upgrade Advisor help identify breaking changes and deprecated features before the upgrade begins. For a staged migration, the existing 2014 instance can run side by side with the newer instance, and the data can be moved through transactional replication, log shipping, or AlwaysOn availability groups.\u003c\/p\u003e\n\n\u003ch2\u003eGet Started With Microsoft SQL Server 2016 Standard\u003c\/h2\u003e\n\u003cp\u003eDownload the SQL Server 2016 Standard installer from the Microsoft volume licensing center or a trusted source, run it on the target Windows Server instance, enter your 1PC product key, and follow the installation wizard to select the database engine, management tools, and the optional integration services, reporting services, and analysis services. The SQL Server 2016 Quick Start guide and the Books Online documentation cover the most common administration and performance tuning scenarios. With a perpetual license, your organisation has a stable, professionally supported relational database engine on one Windows Server for as long as the installation remains in service.\u003c\/p\u003e\u003ch2\u003eMicrosoft SQL Server 2016 Standard Alternatives\u003c\/h2\u003e\n\u003cp\u003eThree credible alternatives cover most relational database workloads.\u003c\/p\u003e\n\u003ch3\u003ePostgreSQL\u003c\/h3\u003e\u003cp\u003eFree and open-source relational database with strong JSON support, advanced indexing, and an active community. Best fit for new application development and analytics workloads.\u003c\/p\u003e\u003ch3\u003eMySQL or MariaDB\u003c\/h3\u003e\u003cp\u003eFree and widely supported. Best fit for LAMP-stack web applications and read-heavy workloads.\u003c\/p\u003e\u003ch3\u003eAzure SQL or Amazon RDS for SQL Server\u003c\/h3\u003e\u003cp\u003eManaged cloud versions of SQL Server with automatic patching, backups, and high availability. Best fit when you want to remove operational overhead.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eHow to choose:\u003c\/strong\u003e Stay on SQL Server for deep Microsoft stack integration, mature tooling, and enterprise features like Always Encrypted, Service Broker, and SQL Server Agent. Choose PostgreSQL for new open-source or analytics workloads. Choose MySQL for simple LAMP web applications. Choose Azure SQL or RDS for managed cloud operation.\u003c\/p\u003e\n\n\u003ch2\u003eFrequently Asked Questions\u003c\/h2\u003e\n\u003cdetails\u003e\n  \u003csummary\u003eWhat is the difference between SQL Server 2016 Standard and Enterprise?\u003c\/summary\u003e\n  \u003cp\u003eSQL Server 2016 Standard includes the core relational engine, Always Encrypted, row-level security, Temporal Tables, native JSON, in-memory OLTP with limited memory, AlwaysOn with two replicas, and basic R integration. SQL Server 2016 Enterprise adds unlimited in-memory OLTP, advanced AlwaysOn with up to eight readable replicas, advanced security features such as Always Encrypted with secure enclaves, partitioning, data compression, and the full set of management tools.\u003c\/p\u003e\n\u003c\/details\u003e\n\u003cdetails\u003e\n  \u003csummary\u003eCan SQL Server 2016 Standard run on Windows Server 2019?\u003c\/summary\u003e\n  \u003cp\u003eSQL Server 2016 is supported on Windows Server 2012 R2 and Windows Server 2016 as primary targets. Running SQL Server 2016 on Windows Server 2019 is technically possible but is not listed as a supported configuration by Microsoft. For new deployments on Windows Server 2019 or 2022, \u003ca href=\"\/products\/microsoft-sql-server-2017-standard-retail-1-pc\"\u003eSQL Server 2017\u003c\/a\u003e or 2019 is recommended.\u003c\/p\u003e\n\u003c\/details\u003e\n\u003cdetails\u003e\n  \u003csummary\u003eHow many cores does the Standard edition support?\u003c\/summary\u003e\n  \u003cp\u003eSQL Server 2016 Standard supports up to the lesser of 4 sockets or 16 physical cores. SQL Server 2016 Enterprise does not have a socket or core limit within the supported operating system.\u003c\/p\u003e\n\u003c\/details\u003e\n\u003cdetails\u003e\n  \u003csummary\u003eDoes the Standard edition include SQL Server Reporting Services?\u003c\/summary\u003e\n  \u003cp\u003eSQL Server 2016 Standard includes SQL Server Reporting Services (SSRS) in a built-in mode, which is suitable for departmental reporting and embedded reports. The new SQL Server 2016 Mobile Reports and KPI features are available in the standard edition with the latest SSRS update.\u003c\/p\u003e\n\u003c\/details\u003e\n\u003cdetails\u003e\n  \u003csummary\u003eIs internet access required to use the database engine?\u003c\/summary\u003e\n  \u003cp\u003eNo. Once SQL Server 2016 Standard is activated, the database engine runs entirely offline. An internet connection is only required for activation, updates, and the optional Stretch Database feature that SQL Server 2016 introduces.\u003c\/p\u003e\n\u003c\/details\u003e\n\n","brand":"Microsoft","offers":[{"title":"Default Title","offer_id":59850909548625,"sku":"MS-055-MICROSOFT-SQL-SERVER-2016-STANDARD-RETAI","price":19.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1059\/0191\/6241\/files\/microsoft-sql-server-2016-standard-retail-1-pc.webp?v=1784725533"},{"product_id":"microsoft-sql-server-2017-standard-retail-1-pc","title":"Microsoft SQL Server 2017 Standard Retail [1 PC]","description":"\u003ch2\u003eMicrosoft SQL Server 2017 Standard for Cross-Platform Database Servers\u003c\/h2\u003e\n\u003cp\u003e\u003ca href=\"\/products\/microsoft-sql-server-2017-standard-retail-1-pc\"\u003eMicrosoft SQL Server 2017 Standard\u003c\/a\u003e is the mid-tier relational database management system for line-of-business applications, departmental reporting, and mid-size database servers. The 2017 release is the first SQL Server version to support Linux distributions (Red Hat Enterprise Linux, SUSE Linux Enterprise Server, and Ubuntu) and container deployments alongside the Windows Server edition, broadening deployment options for heterogeneous environments. The release also introduces graph database capabilities, Adaptive Query Processing, and Python integration alongside R. SQL Server 2017 Standard is delivered as a one-time, perpetual license for one Windows Server instance. Activation is a clean one-time step on the target host — the same perpetual product key redeploys the SQL Server 2017 instance on Windows Server, on supported Linux distributions, or in a container without changing the licensing model, so development and operations teams can pick the right platform for each workload. Every SQL Server key is sourced directly from Microsoft authorized channels and delivered to your account dashboard the moment your payment clears, so activation goes through cleanly without invalid-key errors and the same key reactivates on the same server after a rebuild or hardware swap. SQL Server Standard follows Microsoft's per-core plus CAL model: the 1PC license covers the database engine on one server (up to 24 cores per instance), with separate CALs required for each user or device that connects. 🗄️ ⚡\u003c\/p\u003e\n\n\u003ch2\u003eWhat Is Included and How Activation Works\u003c\/h2\u003e\n\u003cp\u003eYour 1PC Retail Online license includes one Microsoft SQL Server 2017 Standard product key that activates the database engine and the core management tools on one Windows Server instance. The license is perpetual, so there are no subscription fees to manage. The same key can be used to reactivate SQL Server 2017 Standard on the same server after a clean reinstall of the operating system or after a hardware refresh.\u003c\/p\u003e\n\u003cp\u003eTo activate, run the SQL Server 2017 Standard installer on the target Windows Server, enter the 25-character product key when prompted, and complete the online activation against the Microsoft activation service. An internet connection is required only for activation and for downloading updates; the database engine runs entirely offline once activated.\u003c\/p\u003e\n\n\u003ch2\u003eKey Features and Capabilities\u003c\/h2\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRelational database engine\u003c\/strong\u003e — full T-SQL support, stored procedures, triggers, views, and user-defined functions; the engine handles mid-size transactional and analytical workloads on a single Windows Server instance.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCross-platform support\u003c\/strong\u003e — run SQL Server 2017 on Windows Server, Red Hat Enterprise Linux, SUSE Linux Enterprise Server, or Ubuntu; the same T-SQL surface and tools work across all supported operating systems.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eContainer support\u003c\/strong\u003e — deploy SQL Server 2017 in Docker containers on Windows or Linux, orchestrated by Kubernetes for elastic scale and DevOps workflows.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eGraph database capabilities\u003c\/strong\u003e — model and query many-to-many relationships with Node and Edge tables alongside relational tables; use the MATCH clause to traverse the graph inside T-SQL.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAdaptive Query Processing\u003c\/strong\u003e — automatic plan correction, batch mode memory grant feedback, and interleaved execution that improve query performance without manual tuning.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSecurity baseline\u003c\/strong\u003e — Always Encrypted, row-level security, Temporal Tables, native JSON, and dynamic data masking carry forward from the 2016 generation.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAlwaysOn availability groups\u003c\/strong\u003e — high availability and disaster recovery with up to two secondary replicas, automatic failover, and readable secondaries for offloading reporting workloads.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIn-memory OLTP and ColumnStore indexes\u003c\/strong\u003e — high-throughput transactional and analytical performance with memory-optimised tables, natively compiled stored procedures, and columnstore indexes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMachine Learning Services\u003c\/strong\u003e — run R and Python scripts inside the database engine for in-database analytics; the standard edition provides a sandboxed runtime for both languages.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eManagement tools\u003c\/strong\u003e — SQL Server Management Studio (SSMS) on Windows, plus Azure Data Studio as a cross-platform query and notebook editor that works on Windows, macOS, and Linux.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch2\u003eWho This Edition Is For\u003c\/h2\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLine-of-business application owners\u003c\/strong\u003e running mid-size departmental databases on a single Windows Server instance with the cross-platform and graph enhancements that SQL Server 2017 introduces.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eHeterogeneous IT environments\u003c\/strong\u003e that need a single relational database engine that can run on Windows Server, on Linux, or in containers, managed by the same tools and T-SQL code base.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eInternal IT and database administrators\u003c\/strong\u003e managing SQL Server instances for application development, reporting, and analytics with graph, Adaptive Query Processing, and Python integration as part of the standard feature set.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOrganisations modernising their data platform\u003c\/strong\u003e for DevOps workflows with container-based deployments, CI\/CD pipelines, and infrastructure-as-code patterns.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch2\u003eStandard vs Enterprise: What SQL Server Adds\u003c\/h2\u003e\n\u003cp\u003eSQL Server Standard includes the core relational database engine, in-memory OLTP with limited memory, AlwaysOn availability groups with two replicas, ColumnStore indexes, and the security baseline. SQL Server Enterprise adds the features that an organisation needs when the database is large, mission-critical, or both: unlimited in-memory OLTP, advanced AlwaysOn with up to eight readable replicas, partitioning, data compression, advanced security features, and the full Machine Learning Services runtime. Big Data Clusters, which combine SQL Server, Spark, and HDFS into a single Kubernetes-based cluster, are an Enterprise-only feature.\u003c\/p\u003e\n\u003cp\u003eFor departmental applications, line-of-business workloads, and small-to-mid-size database servers, Standard is the right fit. For very large databases, mission-critical transactional systems, and analytics at petabyte scale, Enterprise is the typical choice. The perpetual license model means the chosen edition stays available on the licensed Windows Server instance for the lifetime of the installation, with no monthly fees to manage.\u003c\/p\u003e\n\n\u003ch2\u003eCommon Workflows and Use Cases\u003c\/h2\u003e\n\u003cp\u003e\u003cstrong\u003eLine-of-business application hosting.\u003c\/strong\u003e SQL Server Standard hosts the database backend for the line-of-business applications that the organisation depends on: ERP, CRM, HR, finance, and the custom in-house tools. Always Encrypted, row-level security, and dynamic data masking (in the 2016 generation and later) protect sensitive data, while AlwaysOn availability groups keep the application online through planned and unplanned outages. SSMS and Azure Data Studio provide the administration, query authoring, and performance tuning tools that the database team needs.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eDepartmental reporting and analytics.\u003c\/strong\u003e The combination of SQL Server Standard, SQL Server Reporting Services, SQL Server Integration Services, and SQL Server Analysis Services provides a complete BI platform for departmental reporting. Power View and PowerPivot (in the 2014 and 2016 generations) and the modern Power BI integration (in the 2017 and 2019 generations) make the analytical output available to business users in self-service mode.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eApplication development and testing.\u003c\/strong\u003e The Standard edition is a common fit for development, test, and staging environments, where the database team needs a faithful reproduction of the production schema and feature set without the Enterprise licensing cost. The Intelligent Query Processing and Accelerated Database Recovery features (in the 2019 generation) reduce the time spent on query tuning and crash recovery, which is valuable in fast-moving development environments.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eMid-size transactional database.\u003c\/strong\u003e For a mid-size transactional database (up to 4 sockets or 16 cores, which is the Standard edition limit), the in-memory OLTP and ColumnStore indexes provide high-throughput transactional and analytical performance. The compatibility levels across SQL Server 2014, 2016, 2017, and 2019 provide a clear migration path to a newer generation when the workload outgrows the current version.\u003c\/p\u003e\n\n\u003ch2\u003eSystem Requirements\u003c\/h2\u003e\n\u003ctable\u003e\n  \u003cthead\u003e\n    \u003ctr\u003e\n\u003cth\u003eComponent\u003c\/th\u003e\n\u003cth\u003eMinimum\u003c\/th\u003e\n\u003cth\u003eRecommended\u003c\/th\u003e\n\u003c\/tr\u003e\n  \u003c\/thead\u003e\n  \u003ctbody\u003e\n    \u003ctr\u003e\n\u003ctd\u003eOperating system\u003c\/td\u003e\n\u003ctd\u003eWindows 10, Windows 8.1, Windows Server 2016, Windows Server 2012 R2, Windows Server 2012 (64-bit editions only)\u003c\/td\u003e\n\u003ctd\u003eWindows Server 2016 or Windows Server 2019 (64-bit)\u003c\/td\u003e\n\u003c\/tr\u003e\n    \u003ctr\u003e\n\u003ctd\u003eProcessor\u003c\/td\u003e\n\u003ctd\u003ex64 processor at 1.4 GHz or faster\u003c\/td\u003e\n\u003ctd\u003e2.0 GHz or faster, multi-core\u003c\/td\u003e\n\u003c\/tr\u003e\n    \u003ctr\u003e\n\u003ctd\u003eMemory (RAM)\u003c\/td\u003e\n\u003ctd\u003e1 GB (Express: 512 MB)\u003c\/td\u003e\n\u003ctd\u003e4 GB or more, scaling with database size and workload\u003c\/td\u003e\n\u003c\/tr\u003e\n    \u003ctr\u003e\n\u003ctd\u003eHard disk space\u003c\/td\u003e\n\u003ctd\u003e6 GB available\u003c\/td\u003e\n\u003ctd\u003eSSD with 20 GB or more for system databases, tempdb, and user data\u003c\/td\u003e\n\u003c\/tr\u003e\n    \u003ctr\u003e\n\u003ctd\u003eDisplay\u003c\/td\u003e\n\u003ctd\u003eSuper-VGA (800 × 600) or higher\u003c\/td\u003e\n\u003ctd\u003e1280 × 1024 or higher for Management Studio\u003c\/td\u003e\n\u003c\/tr\u003e\n    \u003ctr\u003e\n\u003ctd\u003e.NET Framework\u003c\/td\u003e\n\u003ctd\u003e.NET 4.6 or later\u003c\/td\u003e\n\u003ctd\u003e.NET 4.7.2 or later\u003c\/td\u003e\n\u003c\/tr\u003e\n  \u003c\/tbody\u003e\n\u003c\/table\u003e\n\n\u003ch2\u003eActivation and Licensing Notes\u003c\/h2\u003e\n\u003cp\u003eThe 1PC Retail Online key is a perpetual license for Microsoft SQL Server 2017 Standard on one Windows Server instance. The license covers one physical or one virtual instance of the database engine on the server. To run a second named instance on the same server hardware, a second SQL Server 2017 Standard license is required.\u003c\/p\u003e\n\u003cp\u003eSQL Server 2017 Standard supports only 64-bit editions of Windows. 32-bit operating systems are not supported. The cross-platform support in SQL Server 2017 covers Linux distributions and Docker containers, but the Retail Online key activates the Windows Server edition. A separate SQL Server 2017 Standard license for Linux is required for non-Windows deployments.\u003c\/p\u003e\n\n\u003ch2\u003eIntegration with the Microsoft Ecosystem\u003c\/h2\u003e\n\u003cp\u003e\u003ca href=\"\/products\/microsoft-sql-server-2014-standard-retail-1-pc\"\u003eSQL Server 2014 Standard\u003c\/a\u003e integrates with the rest of the Microsoft data platform in well-established ways. SQL Server Management Studio is the administration IDE, and it connects to Analysis Services, Integration Services, and Reporting Services in addition to the relational engine. Power BI can connect to SQL Server 2014 as a data source, which is the recommended path for self-service dashboards built on top of a SQL Server 2014 database. SharePoint 2013 integrates with SQL Server 2014 Reporting Services for SharePoint mode, which lets users view reports inside SharePoint. The .NET Framework and Visual Studio provide the application development path, with the .NET Framework Data Provider for SQL Server and the Entity Framework as the standard data access layer.\u003c\/p\u003e\n\u003cp\u003eThe migration path from SQL Server 2014 to a newer generation is well supported. The database compatibility level 120 is the default for SQL Server 2014, and the engine can be upgraded in place to \u003ca href=\"\/products\/microsoft-sql-server-2016-standard-retail-1-pc\"\u003eSQL Server 2016,\u003c\/a\u003e 2017, or 2019. The Database Migration Assistant and the SQL Server Upgrade Advisor help identify breaking changes and deprecated features before the upgrade begins. For a staged migration, the existing 2014 instance can run side by side with the newer instance, and the data can be moved through transactional replication, log shipping, or AlwaysOn availability groups.\u003c\/p\u003e\n\n\u003ch2\u003eGet Started With Microsoft SQL Server 2017 Standard\u003c\/h2\u003e\n\u003cp\u003eDownload the SQL Server 2017 Standard installer from the Microsoft volume licensing center or a trusted source, run it on the target Windows Server instance, enter your 1PC product key, and follow the installation wizard to select the database engine, management tools, and the optional integration services, reporting services, and analysis services. The SQL Server 2017 Quick Start guide and the Books Online documentation cover the most common administration and performance tuning scenarios. With a perpetual license, your organisation has a stable, professionally supported relational database engine on one Windows Server for as long as the installation remains in service.\u003c\/p\u003e\u003ch2\u003eMicrosoft SQL Server 2017 Standard Alternatives\u003c\/h2\u003e\n\u003cp\u003eThree credible alternatives cover most relational database workloads.\u003c\/p\u003e\n\u003ch3\u003ePostgreSQL\u003c\/h3\u003e\u003cp\u003eFree and open-source relational database with strong JSON support, advanced indexing, and an active community. Best fit for new application development and analytics workloads.\u003c\/p\u003e\u003ch3\u003eMySQL or MariaDB\u003c\/h3\u003e\u003cp\u003eFree and widely supported. Best fit for LAMP-stack web applications and read-heavy workloads.\u003c\/p\u003e\u003ch3\u003eAzure SQL or Amazon RDS for SQL Server\u003c\/h3\u003e\u003cp\u003eManaged cloud versions of SQL Server with automatic patching, backups, and high availability. Best fit when you want to remove operational overhead.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eHow to choose:\u003c\/strong\u003e Stay on SQL Server for deep Microsoft stack integration, mature tooling, and enterprise features like Always Encrypted, Service Broker, and SQL Server Agent. Choose PostgreSQL for new open-source or analytics workloads. Choose MySQL for simple LAMP web applications. Choose Azure SQL or RDS for managed cloud operation.\u003c\/p\u003e\n\n\u003ch2\u003eFrequently Asked Questions\u003c\/h2\u003e\n\u003cdetails\u003e\n  \u003csummary\u003eWhat is the difference between SQL Server 2017 Standard and Enterprise?\u003c\/summary\u003e\n  \u003cp\u003eSQL Server 2017 Standard includes the core relational engine, cross-platform support, graph database, Adaptive Query Processing, in-memory OLTP with limited memory, AlwaysOn with two replicas, and basic R and Python integration. SQL Server 2017 Enterprise adds unlimited in-memory OLTP, advanced AlwaysOn with up to eight readable replicas, advanced security features, partitioning, data compression, and the full Machine Learning Services runtime.\u003c\/p\u003e\n\u003c\/details\u003e\n\u003cdetails\u003e\n  \u003csummary\u003eCan SQL Server 2017 Standard run on Windows Server 2019?\u003c\/summary\u003e\n  \u003cp\u003eYes. SQL Server 2017 is supported on Windows Server 2019. For new deployments on Windows Server 2022, a newer SQL Server version such as 2019 is recommended.\u003c\/p\u003e\n\u003c\/details\u003e\n\u003cdetails\u003e\n  \u003csummary\u003eHow many cores does the Standard edition support?\u003c\/summary\u003e\n  \u003cp\u003eSQL Server 2017 Standard supports up to the lesser of 4 sockets or 16 physical cores. SQL Server 2017 Enterprise does not have a socket or core limit within the supported operating system.\u003c\/p\u003e\n\u003c\/details\u003e\n\u003cdetails\u003e\n  \u003csummary\u003eDoes the Standard edition include the graph database features?\u003c\/summary\u003e\n  \u003cp\u003eYes. SQL Server 2017 Standard includes the graph database capabilities (Node and Edge tables, MATCH clause) for modelling and querying many-to-many relationships. The same T-SQL surface and management tools work for graph and relational tables.\u003c\/p\u003e\n\u003c\/details\u003e\n\u003cdetails\u003e\n  \u003csummary\u003eIs internet access required to use the database engine?\u003c\/summary\u003e\n  \u003cp\u003eNo. Once SQL Server 2017 Standard is activated, the database engine runs entirely offline. An internet connection is only required for activation, updates, and the optional Azure hybrid features that SQL Server 2017 introduces.\u003c\/p\u003e\n\u003c\/details\u003e\n\n","brand":"Microsoft","offers":[{"title":"Default Title","offer_id":59850909712465,"sku":"MS-056-MICROSOFT-SQL-SERVER-2017-STANDARD-RETAI","price":19.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1059\/0191\/6241\/files\/microsoft-sql-server-2017-standard-retail-1-pc.webp?v=1784725534"},{"product_id":"microsoft-sql-server-2019-standard-retail-1-pc","title":"Microsoft SQL Server 2019 Standard Retail [1 PC]","description":"\u003ch2\u003eMicrosoft SQL Server 2019 Standard for Modern Database Workloads\u003c\/h2\u003e\n\u003cp\u003e\u003ca href=\"\/products\/microsoft-sql-server-2019-standard-retail-1-pc\"\u003eMicrosoft SQL Server 2019 Standard\u003c\/a\u003e is the mid-tier relational database management system for line-of-business applications, departmental reporting, and mid-size database servers. The 2019 release builds on the cross-platform foundation introduced in 2017 and adds Intelligent Query Processing, Accelerated Database Recovery, UTF-8 support, and Always Encrypted with secure enclaves as standard features for transactional and analytical workloads. SQL Server 2019 Standard is delivered as a one-time, perpetual license for one Windows Server instance. Activation is a clean one-time step on the target Windows Server — paste the 25-character product key into the SQL Server setup wizard, and the instance is online with Intelligent Query Processing, Accelerated Database Recovery, and UTF-8 support ready for production workloads from the first connection. Every SQL Server key is sourced directly from Microsoft authorized channels and delivered to your account dashboard the moment your payment clears, so activation goes through cleanly without invalid-key errors and the same key reactivates on the same server after a rebuild or hardware swap. SQL Server Standard follows Microsoft's per-core plus CAL model: the 1PC license covers the database engine on one server (up to 24 cores per instance), with separate CALs required for each user or device that connects. 🗄️ ⚡\u003c\/p\u003e\n\n\u003ch2\u003eWhat Is Included and How Activation Works\u003c\/h2\u003e\n\u003cp\u003eYour 1PC Retail Online license includes one Microsoft SQL Server 2019 Standard product key that activates the database engine and the core management tools on one Windows Server instance. The license is perpetual, so there are no subscription fees to manage. The same key can be used to reactivate SQL Server 2019 Standard on the same server after a clean reinstall of the operating system or after a hardware refresh.\u003c\/p\u003e\n\u003cp\u003eTo activate, run the SQL Server 2019 Standard installer on the target Windows Server, enter the 25-character product key when prompted, and complete the online activation against the Microsoft activation service. An internet connection is required only for activation and for downloading updates; the database engine runs entirely offline once activated.\u003c\/p\u003e\n\n\u003ch2\u003eKey Features and Capabilities\u003c\/h2\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRelational database engine\u003c\/strong\u003e — full T-SQL support, stored procedures, triggers, views, and user-defined functions; the engine handles mid-size transactional and analytical workloads on a single Windows Server instance.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntelligent Query Processing\u003c\/strong\u003e — automatic plan corrections, batch mode on row store, scalar UDF inlining, and table variable deferred compilation that improve query performance without manual tuning.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAccelerated Database Recovery\u003c\/strong\u003e — re-engineered recovery process that dramatically reduces the time to bring a database online after a crash, rollback, or long-running transaction.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eUTF-8 support\u003c\/strong\u003e — efficient storage and retrieval of Unicode character data using the UTF-8 collation, reducing storage footprint for multi-language databases.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAlways Encrypted with secure enclaves\u003c\/strong\u003e — protect sensitive data during computation, not just at rest and in motion, by performing operations inside a hardware-based secure enclave.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSecurity baseline\u003c\/strong\u003e — row-level security, dynamic data masking, Temporal Tables, native JSON, and the Always Encrypted technology introduced in earlier generations.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eAlwaysOn availability groups\u003c\/strong\u003e — high availability and disaster recovery with up to two secondary replicas, automatic failover, and readable secondaries for offloading reporting workloads.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIn-memory OLTP and ColumnStore indexes\u003c\/strong\u003e — high-throughput transactional and analytical performance with memory-optimised tables, natively compiled stored procedures, and columnstore indexes.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eMachine Learning Services\u003c\/strong\u003e — run R, Python, and Java scripts inside the database engine for in-database analytics; the standard edition provides a sandboxed runtime for all three languages.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eManagement tools\u003c\/strong\u003e — SQL Server Management Studio (SSMS) on Windows, plus Azure Data Studio as a cross-platform query and notebook editor that works on Windows, macOS, and Linux.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch2\u003eWho This Edition Is For\u003c\/h2\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLine-of-business application owners\u003c\/strong\u003e running mid-size departmental databases on a single Windows Server instance with the Intelligent Query Processing, Accelerated Database Recovery, and UTF-8 enhancements that SQL Server 2019 introduces.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eInternal IT and database administrators\u003c\/strong\u003e managing SQL Server instances for application development, reporting, and analytics with Always Encrypted with secure enclaves as part of the standard feature set.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRegulated industries\u003c\/strong\u003e that need Always Encrypted with secure enclaves, row-level security, and dynamic data masking for compliance with data protection requirements.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOrganisations modernising their data platform\u003c\/strong\u003e for mixed transactional and analytical workloads with UTF-8 collation and the Java language extension in Machine Learning Services.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch2\u003eStandard vs Enterprise: What SQL Server Adds\u003c\/h2\u003e\n\u003cp\u003eSQL Server Standard includes the core relational database engine, in-memory OLTP with limited memory, AlwaysOn availability groups with two replicas, ColumnStore indexes, and the security baseline. SQL Server Enterprise adds the features that an organisation needs when the database is large, mission-critical, or both: unlimited in-memory OLTP, advanced AlwaysOn with up to eight readable replicas, partitioning, data compression, advanced security features, and the full Machine Learning Services runtime. Big Data Clusters, which combine SQL Server, Spark, and HDFS into a single Kubernetes-based cluster, are an Enterprise-only feature.\u003c\/p\u003e\n\u003cp\u003eFor departmental applications, line-of-business workloads, and small-to-mid-size database servers, Standard is the right fit. For very large databases, mission-critical transactional systems, and analytics at petabyte scale, Enterprise is the typical choice. The perpetual license model means the chosen edition stays available on the licensed Windows Server instance for the lifetime of the installation, with no monthly fees to manage.\u003c\/p\u003e\n\n\u003ch2\u003eCommon Workflows and Use Cases\u003c\/h2\u003e\n\u003cp\u003e\u003cstrong\u003eLine-of-business application hosting.\u003c\/strong\u003e SQL Server Standard hosts the database backend for the line-of-business applications that the organisation depends on: ERP, CRM, HR, finance, and the custom in-house tools. Always Encrypted, row-level security, and dynamic data masking (in the 2016 generation and later) protect sensitive data, while AlwaysOn availability groups keep the application online through planned and unplanned outages. SSMS and Azure Data Studio provide the administration, query authoring, and performance tuning tools that the database team needs.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eDepartmental reporting and analytics.\u003c\/strong\u003e The combination of SQL Server Standard, SQL Server Reporting Services, SQL Server Integration Services, and SQL Server Analysis Services provides a complete BI platform for departmental reporting. Power View and PowerPivot (in the 2014 and 2016 generations) and the modern Power BI integration (in the 2017 and 2019 generations) make the analytical output available to business users in self-service mode.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eApplication development and testing.\u003c\/strong\u003e The Standard edition is a common fit for development, test, and staging environments, where the database team needs a faithful reproduction of the production schema and feature set without the Enterprise licensing cost. The Intelligent Query Processing and Accelerated Database Recovery features (in the 2019 generation) reduce the time spent on query tuning and crash recovery, which is valuable in fast-moving development environments.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eMid-size transactional database.\u003c\/strong\u003e For a mid-size transactional database (up to 4 sockets or 16 cores, which is the Standard edition limit), the in-memory OLTP and ColumnStore indexes provide high-throughput transactional and analytical performance. The compatibility levels across SQL Server 2014, 2016, 2017, and 2019 provide a clear migration path to a newer generation when the workload outgrows the current version.\u003c\/p\u003e\n\n\u003ch2\u003eSystem Requirements\u003c\/h2\u003e\n\u003ctable\u003e\n  \u003cthead\u003e\n    \u003ctr\u003e\n\u003cth\u003eComponent\u003c\/th\u003e\n\u003cth\u003eMinimum\u003c\/th\u003e\n\u003cth\u003eRecommended\u003c\/th\u003e\n\u003c\/tr\u003e\n  \u003c\/thead\u003e\n  \u003ctbody\u003e\n    \u003ctr\u003e\n\u003ctd\u003eOperating system\u003c\/td\u003e\n\u003ctd\u003eWindows 10 TH1 1507 or greater, Windows Server 2016 or greater (64-bit editions only)\u003c\/td\u003e\n\u003ctd\u003eWindows Server 2019 or Windows Server 2022 (64-bit)\u003c\/td\u003e\n\u003c\/tr\u003e\n    \u003ctr\u003e\n\u003ctd\u003eProcessor\u003c\/td\u003e\n\u003ctd\u003ex64 processor at 1.4 GHz or faster\u003c\/td\u003e\n\u003ctd\u003e2.0 GHz or faster, multi-core\u003c\/td\u003e\n\u003c\/tr\u003e\n    \u003ctr\u003e\n\u003ctd\u003eMemory (RAM)\u003c\/td\u003e\n\u003ctd\u003e1 GB (Express: 512 MB)\u003c\/td\u003e\n\u003ctd\u003e4 GB or more, scaling with database size and workload\u003c\/td\u003e\n\u003c\/tr\u003e\n    \u003ctr\u003e\n\u003ctd\u003eHard disk space\u003c\/td\u003e\n\u003ctd\u003e6 GB available\u003c\/td\u003e\n\u003ctd\u003eSSD with 20 GB or more for system databases, tempdb, and user data\u003c\/td\u003e\n\u003c\/tr\u003e\n    \u003ctr\u003e\n\u003ctd\u003eDisplay\u003c\/td\u003e\n\u003ctd\u003eSuper-VGA (800 × 600) or higher\u003c\/td\u003e\n\u003ctd\u003e1280 × 1024 or higher for Management Studio\u003c\/td\u003e\n\u003c\/tr\u003e\n    \u003ctr\u003e\n\u003ctd\u003e.NET Framework\u003c\/td\u003e\n\u003ctd\u003eMinimum operating system includes minimum .NET Framework\u003c\/td\u003e\n\u003ctd\u003e.NET 4.7.2 or later\u003c\/td\u003e\n\u003c\/tr\u003e\n  \u003c\/tbody\u003e\n\u003c\/table\u003e\n\n\u003ch2\u003eActivation and Licensing Notes\u003c\/h2\u003e\n\u003cp\u003eThe 1PC Retail Online key is a perpetual license for Microsoft SQL Server 2019 Standard on one Windows Server instance. The license covers one physical or one virtual instance of the database engine on the server. To run a second named instance on the same server hardware, a second SQL Server 2019 Standard license is required.\u003c\/p\u003e\n\u003cp\u003eSQL Server 2019 Standard supports only 64-bit editions of Windows. 32-bit operating systems are not supported. AlwaysOn availability groups in the Standard edition are limited to two replicas (one primary and one secondary); the Enterprise edition is required for additional replicas and advanced availability features. Big Data Clusters and the Java language extension in Machine Learning Services are limited to the Enterprise edition.\u003c\/p\u003e\n\n\u003ch2\u003eIntegration with the Microsoft Ecosystem\u003c\/h2\u003e\n\u003cp\u003e\u003ca href=\"\/products\/microsoft-sql-server-2014-standard-retail-1-pc\"\u003eSQL Server 2014 Standard\u003c\/a\u003e integrates with the rest of the Microsoft data platform in well-established ways. SQL Server Management Studio is the administration IDE, and it connects to Analysis Services, Integration Services, and Reporting Services in addition to the relational engine. Power BI can connect to SQL Server 2014 as a data source, which is the recommended path for self-service dashboards built on top of a SQL Server 2014 database. SharePoint 2013 integrates with SQL Server 2014 Reporting Services for SharePoint mode, which lets users view reports inside SharePoint. The .NET Framework and Visual Studio provide the application development path, with the .NET Framework Data Provider for SQL Server and the Entity Framework as the standard data access layer.\u003c\/p\u003e\n\u003cp\u003eThe migration path from SQL Server 2014 to a newer generation is well supported. The database compatibility level 120 is the default for SQL Server 2014, and the engine can be upgraded in place to \u003ca href=\"\/products\/microsoft-sql-server-2016-standard-retail-1-pc\"\u003eSQL Server 2016,\u003c\/a\u003e 2017, or 2019. The Database Migration Assistant and the SQL Server Upgrade Advisor help identify breaking changes and deprecated features before the upgrade begins. For a staged migration, the existing 2014 instance can run side by side with the newer instance, and the data can be moved through transactional replication, log shipping, or AlwaysOn availability groups.\u003c\/p\u003e\n\n\u003ch2\u003eGet Started With Microsoft SQL Server 2019 Standard\u003c\/h2\u003e\n\u003cp\u003eDownload the SQL Server 2019 Standard installer from the Microsoft volume licensing center or a trusted source, run it on the target Windows Server instance, enter your 1PC product key, and follow the installation wizard to select the database engine, management tools, and the optional integration services, reporting services, and analysis services. The SQL Server 2019 Quick Start guide and the Books Online documentation cover the most common administration and performance tuning scenarios. With a perpetual license, your organisation has a stable, professionally supported relational database engine on one Windows Server for as long as the installation remains in service.\u003c\/p\u003e\u003ch2\u003eMicrosoft SQL Server 2019 Standard Alternatives\u003c\/h2\u003e\n\u003cp\u003eThree credible alternatives cover most relational database workloads.\u003c\/p\u003e\n\u003ch3\u003ePostgreSQL\u003c\/h3\u003e\u003cp\u003eFree and open-source relational database with strong JSON support, advanced indexing, and an active community. Best fit for new application development and analytics workloads.\u003c\/p\u003e\u003ch3\u003eMySQL or MariaDB\u003c\/h3\u003e\u003cp\u003eFree and widely supported. Best fit for LAMP-stack web applications and read-heavy workloads.\u003c\/p\u003e\u003ch3\u003eAzure SQL or Amazon RDS for SQL Server\u003c\/h3\u003e\u003cp\u003eManaged cloud versions of SQL Server with automatic patching, backups, and high availability. Best fit when you want to remove operational overhead.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eHow to choose:\u003c\/strong\u003e Stay on SQL Server for deep Microsoft stack integration, mature tooling, and enterprise features like Always Encrypted, Service Broker, and SQL Server Agent. Choose PostgreSQL for new open-source or analytics workloads. Choose MySQL for simple LAMP web applications. Choose Azure SQL or RDS for managed cloud operation.\u003c\/p\u003e\n\n\u003ch2\u003eFrequently Asked Questions\u003c\/h2\u003e\n\u003cdetails\u003e\n  \u003csummary\u003eWhat is the difference between SQL Server 2019 Standard and Enterprise?\u003c\/summary\u003e\n  \u003cp\u003eSQL Server 2019 Standard includes the core relational engine, Intelligent Query Processing, Accelerated Database Recovery, UTF-8 support, Always Encrypted with secure enclaves, in-memory OLTP with limited memory, AlwaysOn with two replicas, and basic R, Python, and Java integration. SQL Server 2019 Enterprise adds unlimited in-memory OLTP, advanced AlwaysOn with up to eight readable replicas, Big Data Clusters, partitioning, data compression, and the full Machine Learning Services runtime.\u003c\/p\u003e\n\u003c\/details\u003e\n\u003cdetails\u003e\n  \u003csummary\u003eCan SQL Server 2019 Standard run on Windows Server 2022?\u003c\/summary\u003e\n  \u003cp\u003eYes. SQL Server 2019 is supported on Windows Server 2016, 2019, and 2022. For new deployments on Windows Server 2025, a newer SQL Server version such as 2022 is recommended.\u003c\/p\u003e\n\u003c\/details\u003e\n\u003cdetails\u003e\n  \u003csummary\u003eHow many cores does the Standard edition support?\u003c\/summary\u003e\n  \u003cp\u003eSQL Server 2019 Standard supports up to the lesser of 4 sockets or 16 physical cores. SQL Server 2019 Enterprise does not have a socket or core limit within the supported operating system.\u003c\/p\u003e\n\u003c\/details\u003e\n\u003cdetails\u003e\n  \u003csummary\u003eDoes the Standard edition include Big Data Clusters?\u003c\/summary\u003e\n  \u003cp\u003eNo. Big Data Clusters are an Enterprise edition feature that combines SQL Server, Spark, and HDFS into a single Kubernetes-based cluster. The Standard edition provides the core relational engine, Intelligent Query Processing, and the analytical enhancements that ship with SQL Server 2019, but Big Data Clusters require an Enterprise license.\u003c\/p\u003e\n\u003c\/details\u003e\n\u003cdetails\u003e\n  \u003csummary\u003eIs internet access required to use the database engine?\u003c\/summary\u003e\n  \u003cp\u003eNo. Once SQL Server 2019 Standard is activated, the database engine runs entirely offline. An internet connection is only required for activation, updates, and the optional Azure hybrid features that SQL Server 2019 introduces.\u003c\/p\u003e\n\u003c\/details\u003e\n\n","brand":"Microsoft","offers":[{"title":"Default Title","offer_id":59850909974609,"sku":"MS-057-MICROSOFT-SQL-SERVER-2019-STANDARD-RETAI","price":19.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1059\/0191\/6241\/files\/microsoft-sql-server-2019-standard-retail-1-pc.webp?v=1784725536"}],"url":"https:\/\/dotkeys.net\/collections\/sql-server.oembed","provider":"DotKeys","version":"1.0","type":"link"}