SQL Server 2016 Standard
Instant activation
The release that introduced Query Store, temporal tables and native JSON support, in extended support until July 2026.
$4.70one-time
Microsoft · SQL Server
The In-Memory OLTP release, out of support since July 2024 and sold for applications certified against it.
$4.70one-time
Covers 1 device.
Prices exclude any applicable tax. Licenses are issued to the account used at checkout.
SQL Server 2014 Standard introduced In-Memory OLTP — memory-optimised tables and natively compiled stored procedures for high-contention transactional workloads — along with buffer pool extension to SSD, backup encryption and delayed durability. Its support lifecycle has ended: no security updates have been published since July 2024 without an Extended Security Update agreement. It remains a legitimate purchase where an application is certified against this version specifically, and the version constraint should be the reason for choosing it.
Memory-optimised tables and natively compiled stored procedures for high-contention workloads.
Extends the buffer pool onto SSD storage to enlarge the effective read cache.
Backups encrypted at creation time with AES or Triple DES, in the Standard edition.
Transaction commits acknowledged before the log flush completes, trading a durability window for throughput.
The installation media is downloaded from the Microsoft Evaluation Center or Volume Licensing Service Center, and the supplied key is entered during setup to install the Standard edition rather than the evaluation build.
No. Extended support ended on 9 July 2024. It receives no further security updates unless covered by an Extended Security Update agreement, so it should only be deployed where an application requires this specific version.
Because certification is version-specific: an application vendor may only support its product on SQL Server 2014, and running it elsewhere voids that support. Where no such constraint exists, 2019 is the better purchase.
Standard covers the database engine, Integration Services, Reporting Services and basic high availability. Enterprise removes the compute and memory ceilings and adds online index operations, table partitioning at scale, and advanced availability groups. Standard is capped at 128 GB of buffer pool memory per instance.
Under the Server + CAL model every user or device connecting to the server needs a CAL. CALs are not included with this key and are purchased separately.
No. One key activates one server. Additional servers need additional licenses.
Instant activation
The release that introduced Query Store, temporal tables and native JSON support, in extended support until July 2026.
$4.70one-time
Instant activation
The current supported SQL Server release for on-premise deployment, adding UTF-8 collations, Accelerated Database Recovery and PolyBase data virtualisation.
$4.70one-time
Instant activation
The first SQL Server release to run on Linux and in containers, alongside the same Windows database engine.
$4.70one-time