SQL Server 2017 Standard at a glance
This edition is the mid-range production tier of Microsoft's 2017 database release, placed between the free Express edition and Enterprise. Alongside the relational engine it includes Integration Services, Reporting Services and Analysis Services, so one installation can store transactional data, move it between systems and present it as reports. The 2017 release was the first in which Microsoft built the engine for Linux as well as Windows, and it can also be deployed in Docker containers.
Standard is aimed at small and mid-sized companies and at departments that run an ERP or accounting system, a line-of-business application or a dedicated reporting database. Since Service Pack 1 of the 2016 release, Microsoft has moved many development features that were once Enterprise-only into Standard, and the 2017 version keeps that broader set. The remaining distance to Enterprise lies mainly in scale and high-availability depth, not in the T-SQL language or programmability.
How it is used in everyday work
End users rarely see the server directly, because it works behind their accounting package, warehouse system or in-house application. Administrators manage it through SQL Server Management Studio or Azure Data Studio, and a typical morning means checking overnight SQL Server Agent jobs, reviewing backup history, adding an index that a slow report exposed and granting a new colleague access to one schema. Developers write stored procedures in T-SQL and test queries against a restored copy of production data.
Teams that build their own reporting benefit from having the data tools in the same product. An SSIS package can load flat files, other databases or Excel workbooks on a schedule, clean the data and pass it on to Reporting Services, where department heads open paginated reports in a browser. Companies that already host their web applications on Linux can place the database on the same platform, while Windows-based teams keep working with the tools they know.
The functions that make a practical difference
Basic Availability Groups replicate a single database to a second server and fail over automatically, which gives smaller setups a standby system without Enterprise costs. The secondary copy cannot be queried, but it takes over when the primary fails. Columnstore indexes and In-Memory OLTP are included, so analytical queries over large tables and high-frequency insert workloads can be accelerated within the edition's memory quotas. Adaptive query processing, new in 2017, lets the optimizer correct certain row-count misestimates during execution, which helps reports whose runtime used to vary without clear reason.
Always Encrypted keeps sensitive columns encrypted on the client side, so even administrators with database access see only ciphertext, while row-level security and dynamic data masking limit what individual users can view. Graph tables, also introduced with this release, model relationships such as hierarchies or product dependencies through node and edge tables queried with MATCH. Machine Learning Services run R and, for the first time, Python scripts inside the database, although Standard offers this in a reduced form compared with Enterprise.
Choosing the right edition
Express costs nothing but caps each database at 10 GB, which suits small applications and test systems. Developer contains every Enterprise feature but may only be used for development and testing, and Web is reserved for hosting providers. Standard handles most company production workloads, using up to 24 cores or four sockets, whichever is lower, and up to 128 GB of buffer pool memory per instance. Enterprise lifts these ceilings and adds online index rebuilds, readable secondary replicas, Resource Governor and Transparent Data Encryption, which makes it the choice for large systems that must stay available around the clock.
Practical limits worth knowing before you buy
Columnstore and In-Memory OLTP data are each limited to 32 GB per database, so large analytical workloads may reach these quotas before the hardware does. Basic Availability Groups protect one database per group without a readable secondary, and because online index operations are missing, maintenance on large tables belongs in quiet hours. Transparent Data Encryption only arrived in Standard with the 2019 release. Mainstream support for the 2017 version ended in October 2022, with security updates scheduled until October 2027.
Common questions before ordering
Can this edition be installed on Linux?
Yes, the database engine and Integration Services run on supported Linux distributions as well as in Docker containers. Reporting Services and Analysis Services remain Windows-only components, so a reporting setup still needs a Windows server.
Can databases from older SQL Server versions be moved over?
Databases from SQL Server 2008 onward can be restored or attached directly, and the compatibility level can stay at its old value until applications have been tested. A database upgraded this way cannot be restored on the older version afterwards.
Is Reporting Services part of the Standard edition?
Yes, paginated reporting is included, although from 2017 onward Microsoft distributes Reporting Services as a separate download rather than on the main setup media. Power BI Report Server is not part of this edition.
Ordering SQL Server 2017 Standard at Keys.discount
Every order is processed automatically, so you normally have everything you need within a few minutes of paying.
Delivery: Your product key and the official download link arrive by email.
Activation guarantee: If activation fails, we replace the key.
Sourcing: Licences come from audited distribution channels and are documented.
Setup help: Written step-by-step instructions accompany every delivery.
Support: Our team answers by chat, email and phone in several languages.
