SQL Server’s History Is the Version on the Box.

SQL Server’s History Is the Version on the Box.

You opened a history URL. Keep it. This page is the lineage. It is not the 2022 metric, the 2025 metric, or the comparison.

SQL Server 2025 is what Microsoft lists as the current commercial product. The Product Terms for SQL Server (EA/EAS/SCE) show SQL Server 2025, date available 11/25. Prior version is SQL Server 2022 (11/22). Microsoft announced general availability on 18 November 2025. A lot of estates still run 2022, 2019, 2017, and 2016 that left extended support in July 2026.

The 2022 metric stays at the SQL Server 2022 licensing guide. The 2025 metric stays at the SQL Server 2025 licensing guide. The delta stays at the SQL Server 2022 versus 2025 comparison. This URL is the version file.

That’s the problem.

A feature tour is not a license position. Calling the product “Windows SQL Server” is not the product name. Calling 2022 current is stale. Mixing every version’s highlights into one page does not tell you which binaries are in production, which ones still have security updates, or whether Software Assurance still grants a step to 2025.

Do not invent a list price. Your number is the quote, the MLS, or the CSP subscription in front of you.

From Sybase on OS/2 to Microsoft’s engine

A Microsoft SQL Server engineering history (Euan Garden, 2006) is the primary source for the Sybase years. Microsoft and Sybase started a partnership in 1987. Ashton-Tate/Microsoft SQL Server 1.0 shipped in 1989 for OS/2. SQL Server 1.1 added Windows support in 1990. Version 4.2 for OS/2 shipped in 1992 and was the first release with significant Microsoft code in the product.

Do not date SQL Server 4.2 as the first Windows release in 1992. That is the OS/2 synch, not the NT port. Microsoft’s SQL Server versions wiki lists SQL Server 4.21 (SQLNT) in 1993 as the Windows NT line. Microsoft and Sybase dissolved the partnership in 1994. Microsoft then shipped SQL Server 6.0 (1995) and 6.5 (1996) from the NT code base.

SQL Server 7.0 was the rewrite. Engine, query processor, storage engine, and data access APIs were new. OLAP Services and Data Transformation Services landed in that release. It RTM’d in November 1998 and was generally available in January 1999. It was not “the first version to use the Windows NT kernel.” SQLNT already ran on Windows NT.

SQL Server 2000 followed in August 2000: multi-instance, a new clustering implementation, data mining, and SQLXML. It was not “the first version to support the Windows Server operating system.” The NT server line was already the platform.

2005 through 2016: CLR, columnstore, in-memory

SQL Server 2005 brought SQLCLR (CLR integration), XML in the engine, Service Broker, Integration Services as ground-up code, and Report Builder. It is not accurate to say 2005 was “the first version to use the .NET Framework” as if the engine ran on .NET. CLR integration is the Microsoft claim.

SQL Server 2008 (August 2008 on Microsoft’s versions wiki) and SQL Server 2008 R2 (May 2010) are still in a lot of CMDB dumps. Do not skip them because a timeline jumped from 2005 to 2012.

Columnstore indexes: SQL Server 2012 introduced the read-only nonclustered columnstore index. SQL Server 2014 introduced the updateable clustered columnstore index as primary storage. Microsoft’s versions wiki codes that release Hekaton, the In-Memory OLTP project. SQL Server 2016 made operational analytics on columnstore a mainstream path, including an updateable nonclustered columnstore on a rowstore table.

SQL Server 2012 lifecycle: started 20 May 2012. Extended support ended 13 July 2022. SQL Server 2014: started 5 June 2014. Extended support ended 10 July 2024. SQL Server 2016: started 1 June 2016. Extended support ended 15 July 2026.

If 2012, 2014, or 2016 is still in production without an Extended Security Updates subscription, you are past Microsoft’s fixed lifecycle, not “legacy but fine.” ESU is a time-boxed option Microsoft documents on the end of support overview. Do not invent an ESU price. Read the paper and the Lifecycle page in front of you.

Linux, containers, Azure-connected, then 2025

SQL Server 2017 (29 September 2017) brought the same Database Engine to Linux, Linux-based containers, and Windows. Python joined R in Machine Learning Services. See SQL Server on Linux and what’s new in SQL Server 2017. Lifecycle: mainstream ended 12 October 2022. Extended support ends 13 October 2027.

SQL Server 2019 (4 November 2019): Big Data Clusters, Always Encrypted with secure enclaves, data virtualization with PolyBase. Microsoft retired Big Data Clusters on 28 February 2025. Lifecycle: mainstream ended 1 March 2025. Extended support ends 9 January 2030.

SQL Server 2022 became generally available on 16 November 2022. Headline capabilities on Microsoft’s own pages: Azure Synapse Link for SQL, Microsoft Purview integration, Ledger, contained availability groups, Parameter Sensitive Plan optimization. Security branding on that release is Microsoft Defender for Cloud / Defender for SQL, not “Azure Defender.” See what’s new in SQL Server 2022. Lifecycle: mainstream ends 12 January 2028. Extended support ends 12 January 2033.

SQL Server 2025 is current. Native vector type and vector functions, Fabric mirroring, optimized locking. Product changes that belong on the 2025 pages, not as 2022 rules: Web edition is not available for 2025 (Microsoft states 2022 Web remains supported until January 2033); Data Quality Services and Master Data Services are discontinued; Synapse Link is discontinued in favor of Fabric mirroring; Developer splits into Enterprise Developer and Standard Developer; Standard compute is the lesser of 4 sockets or 32 cores. Keep those on the 2025 licensing guide and the 2022 versus 2025 comparison. Lifecycle: started 18 November 2025. Mainstream ends 7 January 2031. Extended support ends 7 January 2036.

Version timeline that matches Microsoft

Ship dates below come from Microsoft Lifecycle pages where they exist, from the 2022 and 2025 GA announcements, and from the Microsoft engineering history / versions wiki for the pre-lifecycle years. Do not treat a wiki year as a support-end date.

Version Ship (Microsoft source) What changed Extended support end
1.0 1989, OS/2 Ashton-Tate/Microsoft SQL Server Not on Lifecycle
1.1 1990 Windows support Not on Lifecycle
4.2 1992, OS/2 First release with significant Microsoft code Not on Lifecycle
4.21 / SQLNT 1993 Windows NT port Not on Lifecycle
6.0 / 6.5 1995 / 1996 Post-Sybase Microsoft line Not on Lifecycle
7.0 RTM Nov 1998, GA Jan 1999 Engine rewrite, OLAP Services, DTS Not on Lifecycle
2000 August 2000 Multi-instance, SQLXML, data mining Not on Lifecycle
2005 2005 SQLCLR, XML in the engine Not on Lifecycle
2008 / 2008 R2 Aug 2008 / May 2010 Still in CMDB dumps. Do not skip. Not fetched here
2012 20 May 2012 Read-only nonclustered columnstore 13 July 2022
2014 5 June 2014 Clustered columnstore; Hekaton / In-Memory OLTP 10 July 2024
2016 1 June 2016 Operational analytics on columnstore 15 July 2026
2017 29 September 2017 Linux, containers, Python in ML Services 13 October 2027
2019 4 November 2019 Big Data Clusters (retired 28 Feb 2025), enclaves 9 January 2030
2022 16 November 2022 Azure-connected, Ledger, Defender for SQL 12 January 2033
2025 18 November 2025 Current commercial product 7 January 2036

Why version still belongs in the license position

New version rights sit on Software Assurance or a subscription. Product Terms and Microsoft’s SQL Server 2025 licensing guidance both say it. A 2019 box with lapsed SA does not become 2025 because you opened a 2025 URL.

Failover replica rights, licensing a VM from 2022 onward, and unlimited virtualization are metric questions. They live on the 2022 and 2025 licensing URLs. The history question is: which version is actually installed, and is that version still in support.

SQL Per Core is still four core licenses per physical processor, not sixteen per server. That floor did not wait for 2025. Do not import the Windows Server 16-core rule. Worked examples stay on the 2022 guide and the 2025 guide.

What this URL must not steal

Keep these on their own slugs:

This URL: lineage, ship dates, support dates, mixed-version estate. Do not paste a 2-core list price. Microsoft’s public licensing pages fetched for this pack do not give you one to copy.

What to have this week

Do this before the next true-up, EA amendment, or CSP quote. Produce a SQL pack, not a pasted Microsoft wiki.

  1. Every instance: version, edition, OSE type. Physical, VM, or container. Developer and Express called out, not mixed into production.
  2. Support status against Microsoft Lifecycle, not a CMDB “in production” flag. 2016 left extended support on 15 July 2026. 2017 extended ends 13 October 2027.
  3. Whether SA or a subscription sits on that paper. That bit decides new version rights, and whether a 2022-to-2025 step is even available.
  4. What you own versus what you deployed. Microsoft Entitlements Manager is the MLS / entitlement side. Microsoft Deployment Manager is the SQL, Windows Server, and M365 requirement. Infrastructure Mapper is the topology file.

Can a non-specialist brief the CIO in fifteen minutes from the pack you have today? If the answer is “we run SQL Server” or “2022 is still current,” you do not have a SQL position.

Picture your procurement director, sixty days out. Finance has this history URL bookmarked. The quote walking in may already say 2025. Neither document is the estate. The number is version actually installed, support status, and whether SA is on the paper.

The decision layer, not another SQL wiki

You already have MAP, SCCM, or a CMDB full of SQL services. The gap is not another version chart. The gap is turning that estate into a file: version, edition, OSE, cores Microsoft will count, SA yes or no. LICENSEWARE sits on the inventory and ITSM tools you already run. It is not a rip-and-replace SAM suite. It is a decision layer: what matters, why it matters now, what should happen next. MDM is the deployment file. MEM is the entitlement file. LCM is the renewal file.

If you are heading into a SQL true-up or a 2016/2017 exit and your current tools still need three weeks to separate boxes past extended support from 2022 VMs that need SA, book an Audit Readiness Review. You can also start on the free plan and run the analysis on your own data.

Do not let the vendor frame this as “just buy 2025 cores, history is interesting.” Do not let your own side frame it as 2022 still being current, or as a 16-core-per-server Windows rule. The right question is: which version is installed, is it still in support, does the paper grant a step to 2025, and what do the 2022 and 2025 licensing URLs say about the metric. That is a data question, not a sales question.

The vendor will walk in with a number. The only question is whether you have yours first: current, defensible, and tied to the contract in front of you.

Sources

Alex Cojocaru

Alex has been active in the software world since he started his career as an Analyst in 2011. He had various roles in software asset management, data analytics, and software development. He walked in the shoes of an analyst, auditor, advisor, and software engineer, being involved in building SAM tools, amongst other data-focused projects. In 2020, Alex co-founded LICENSEWARE and is currently leading the company as CEO.