Recent from talks
Nothing was collected or created yet.
History of Microsoft SQL Server
View on WikipediaThe history of Microsoft SQL Server begins with the first Microsoft SQL Server database product – SQL Server v1.0, a 16-bit relational database for the OS/2 operating system, released in 1989.
Versions
[edit]| Version | Release Date |
Mainstream End Date |
Extended End Date |
Release name | Code name | Internal database version |
|---|---|---|---|---|---|---|
| 1.0 (OS/2) | 1989 | ? | ? | SQL Server 1.0 (16-bit) | Filipi | – |
| 1.1 (OS/2) | 1990 | ? | ? | SQL Server 1.1 (16-bit) | Pietro | – |
| 4.2A (OS/2) | 1992 | ? | ? | SQL Server 4.2A | – | – |
| 4.2B (OS/2) | 1993 | ? | ? | SQL Server 4.2B (16-bit) | – | – |
| 4.21a (WinNT) | 1993 | ? | ? | SQL Server 1a | SQLNT | – |
| 6.0 | 1995 | ? | ? | SQL Server 6.0 | SQL95 | 406 |
| 6.5 | 1996 | ? | ? | SQL Server 6.5 | Hydra | 408 |
| 7.0 | 1998 | December 31, 2005 | January 11, 2011 | SQL Server 7.0 | Sphinx | 515 |
| — | 1999 | ? | ? | SQL Server 7.0 OLAP Tools | Plato | – |
| 8.0 | 2000 | April 8, 2008 | April 9, 2013 | SQL Server 2000 | Shiloh | 539 |
| 8.0 | 2003 | ? | ? | SQL Server 2000 64-bit Edition | Liberty | 539 |
| 9.0 | January 14, 2006 | April 12, 2011 | April 12, 2016 | SQL Server 2005 | Yukon | 611/612 |
| 10.0 | November 6, 2008 | July 8, 2014 | July 9, 2019 | SQL Server 2008 | Katmai | 655 |
| 10.25 | 2010 | ? | ? | Azure SQL database (initial release) | Cloud database or CloudDB | – |
| 10.50 | July 20, 2010 | July 8, 2014 | July 9, 2019 | SQL Server 2008 R2 | Kilimanjaro (aka KJ) | 661 |
| 11.0 | May 20, 2012 | July 11, 2017 | July 12, 2022 | SQL Server 2012 | Denali | 706 |
| 12.0 | 2014 | ? | ? | Azure SQL database | – | – |
| 12.0 | June 5, 2014 | July 9, 2019 | July 9, 2024 | SQL Server 2014 | Hekaton | 782 |
| 13.0 | June 1, 2016 | July 13, 2021 | July 14, 2026 | SQL Server 2016 | SQL16 | 852 |
| 14.0 | September 29, 2017 | October 11, 2022 | October 12, 2027 | SQL Server 2017 | Helsinki | 869 |
| 15.0 | November 4, 2019 | January 14, 2025 | January 8, 2030 | SQL Server 2019 | Seattle | 895 |
| 16.0 | November 16, 2022 | January 11, 2028 | January 11, 2033 | SQL Server 2022 | Dallas | 957 |
| Legend: Old version Older version, still maintained Latest version | ||||||
Detailed history
[edit]Genesis
[edit]By the late 1980s Microsoft was interested in the low end of the database software market, while Sybase focused on the Fortune 1000. After the former discussed a partnership with Sybase rival Informix Corporation,[1] in January 1988 Microsoft joined Ashton-Tate and Sybase to create a variant of Sybase SQL Server for IBM OS/2 (then developed jointly with Microsoft) compatible with Ashton-Tate's dBASE software. Information Builders, Borland, and Symantec Corporation announced support for the product. Microsoft's Bill Gates praised Sybase as the best SQL database engine, and persuaded Ashton-Tate to use it instead of its own. Rivals such as Microrim (R:Base), Novell, Oracle Corporation, and Lotus Development said that they would use their own technology, or that they expected IBM's own SQL technology in OS/2 Extended Edition to be the standard.[2]
Scheduled for the second half of 1988,[2] it was released in 1989.[3] This was the first version of Microsoft SQL Server, and served as Microsoft's entry to the enterprise-level database market, competing against Oracle, IBM, Informix, Ingres and later, Sybase. SQL Server 4.2 was shipped in 1992, bundled with OS/2 version 1.3, followed by version 4.21 for Windows NT, released alongside Windows NT 3.1. SQL Server 6.0 was the first version designed for NT, and did not include any direction from Sybase.
Sybase revenue grew quickly during the late 1980s from the Microsoft relationship.[1] About the time Windows NT was released in July 1993, Sybase and Microsoft parted ways and each pursued its own design and marketing schemes. Microsoft negotiated exclusive rights to all versions of SQL Server written for Microsoft operating systems. (In 1996 Sybase changed the name of its product to Adaptive Server Enterprise to avoid confusion with Microsoft SQL Server.) Until 1994, Microsoft's SQL Server carried three Sybase copyright notices as an indication of its origin.
SQL Server 7.0
[edit]
After problems at its main rivals, SQL Server became Oracle's most important competitor.[4] SQL Server 7.0 was a major rewrite (using C++) of the older Sybase engine, which was coded in C. Data pages were enlarged from 2k bytes to 8k bytes. Extents thereby grew from 16k bytes to 64k bytes. User Mode Scheduling (UMS) was introduced to handle SQL Server threads better than Windows preemptive multi-threading, also adding support for fibers (lightweight threads, introduced in NT 4.0, which are used to avoid context switching[5]). SQL Server 7.0 also introduced a multi-dimensional database product called SQL OLAP Services (which became Analysis Services in SQL Server 2000). SQL Server 7.0 would be the last version to run on the DEC Alpha platform. Although there were pre-release versions of SQL 2000 (as well as Windows 2000) compiled for Alpha, these were canceled and were never commercially released. Mainstream support ended on December 31, 2005, and extended support ended on January 11, 2011.
SQL Server 2000
[edit]SQL Server 2000 included more modifications and extensions to the Sybase code base, adding support for the IA-64 architecture (now out of "mainstream" support[6]). By SQL Server 2005 the legacy Sybase code had been completely rewritten.[7]
Since the release of SQL Server 2000, advances have been made in performance, the client IDE tools, and several complementary systems that are packaged with SQL Server 2005. These include:
- an extract-transform-load (ETL) tool (initially called Data Transformation Services or DTS, and later called SQL Server Integration Services, or SSIS)
- SQL Server Reporting Services (SSRS), or "Reporting Server"
- an OLAP and data mining server (Analysis Services)
- several messaging technologies, specifically Service Broker and Notification Services
SQL Server 2000 also introduced many T-SQL language enhancements, such as table variables, user-defined functions, indexed views, INSTEAD OF triggers, cascading referential constraints and some basic XML support.[8][9]
With the release of Service Pack 3, Microsoft also released the first 64-bit version of the SQL Server for the Itanium IA-64 platform (not to be confused with the x86-64 platform). Only the SQL Server relational engine and SQL Agent were ported to Itanium at this time. Client tools, such as SQL Server Management Studio, were still 32-bit x86 programs. The first release of SQL IA-64 was version 8.00.760, with a build date of February 6, 2003.
Mainstream support ended on April 8, 2008, and extended support ended on April 9, 2013.
SQL Server 2005
[edit]SQL Server 2005 (formerly codenamed "Yukon") was released in November 2005, introducing native support for x64 systems and updates to Reporting Services, Analysis Services & Integration Services.[10] It included native support for managing XML data, in addition to relational data. For this purpose, it defined an xml data type that could be used either as a data type in database columns or as literals in queries. XML columns can be associated with XSD schemas; XML data being stored is verified against the schema. XML data is queried using XQuery; SQL Server 2005 added some extensions to the T-SQL language to allow embedding XQuery queries in T-SQL. It also defines a new extension to XQuery, called XML DML, that allows query-based modifications to XML data. SQL Server 2005 also allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP requests. When the data is accessed over web services, results are returned as XML.[11]
Common Language Runtime (CLR) integration was introduced with this version, enabling one to write SQL code as Managed Code by the CLR. For relational data, T-SQL has been augmented with error handling features (try/catch) and support for recursive queries with CTEs (Common Table Expressions). SQL Server 2005 has also been enhanced with new indexing algorithms, syntax and better error recovery systems. Data pages are checksummed for better error resiliency, and optimistic concurrency support has been added for better performance. Permissions and access control have been made more granular and the query processor handles concurrent execution of queries in a more efficient way. Partitions on tables and indexes are supported natively, so scaling out a database onto a cluster is easier. SQL CLR was introduced with SQL Server 2005 to let it integrate with the .NET Framework.[12]
SQL Server 2005 introduced:
- Multi-Version Concurrency Control (MVCC); user facing features include new transaction isolation level called SNAPSHOT and a variation of the READ COMMITTED isolation level based on statement-level data snapshots.
- Multiple Active Results Sets (MARS), a method of allowing usage of database connections for multiple purposes.[13]
- DMVs (Dynamic Management Views), specialized views and functions that return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance.[14]
Service Pack 1 (SP1) was released on April 18, 2006, adding Database Mirroring, a high availability option that provides redundancy and failover capabilities at the database level[15] (Database Mirroring was included in the RTM release of SQL Server 2005, but it was not enabled by default, being supported for evaluation purposes[citation needed]). Failover can be manual or automatic; automatic failover requires a witness partner and an operating mode of synchronous (also known as high-safety or full safety).[16] Service Pack 2 released on February 19, 2007, Service Pack 3 was released on December 15, 2008, and SQL Server 2005 Service Pack 4 released on December 13, 2010.
Mainstream support for SQL Server 2005 ended on April 12, 2011, and Extended support for SQL Server 2005 ended on April 12, 2016.
SQL Server 2008
[edit]SQL Server 2008 (formerly codenamed "Katmai")[17][18] was released on August 6, 2008, announced to the SQL Server Special Interest Group at the ESRI 2008 User's Conference on August 6, 2008, by Ed Katibah (Spatial Program Manager at Microsoft), and aims to make data management self-tuning, self organizing, and self maintaining with the development of SQL Server Always On technologies, to provide near-zero downtime. SQL Server 2008 also includes support for structured and semi-structured data, including digital media formats for pictures, audio, video and other multimedia data. In current versions, such multimedia data can be stored as BLOBs (binary large objects), but they are generic bitstreams. Intrinsic awareness of multimedia data will allow specialized functions to be performed on them. According to Paul Flessner, senior Vice President of Server Applications at Microsoft, SQL Server 2008 can be a data storage backend for different varieties of data: XML, email, time/calendar, file, document, spatial, etc. as well as perform search, query, analysis, sharing, and synchronization across all data types.[18]
Other new data types include specialized date and time types and a Spatial data type for location-dependent data.[19] Better support for unstructured and semi-structured data is provided using the new FILESTREAM[20] data type, which can be used to reference any file stored on the file system.[21] Structured data and metadata about the file is stored in SQL Server database, whereas the unstructured component is stored in the file system. Such files can be accessed both via Win32 file handling APIs as well as via SQL Server using T-SQL; doing the latter accesses the file data as a BLOB. Backing up and restoring the database backs up or restores the referenced files as well.[22] SQL Server 2008 also natively supports hierarchical data, and includes T-SQL constructs to directly deal with them, without using recursive queries.[22]
The full-text search functionality has been integrated with the database engine. According to a Microsoft technical article, this simplifies management and improves performance.[23]
Spatial data will be stored in two types. A "Flat Earth" (GEOMETRY or planar) data type represents geospatial data which has been projected from its native, spherical, coordinate system into a plane. A "Round Earth" data type (GEOGRAPHY) uses an ellipsoidal model in which the Earth is defined as a single continuous entity which does not suffer from the singularities such as the international dateline, poles, or map projection zone "edges". Approximately 70 methods are available to represent spatial operations for the Open Geospatial Consortium Simple Features for SQL, Version 1.1.[24]
SQL Server includes better compression features, which also helps in improving scalability.[25] It enhanced the indexing algorithms and introduced the notion of filtered indexes. It also includes Resource Governor that allows reserving resources for certain users or workflows. It also includes capabilities for transparent encryption of data (TDE) as well as compression of backups.[20] SQL Server 2008 supports the ADO.NET Entity Framework and the reporting tools, replication, and data definition will be built around the Entity Data Model.[26] SQL Server Reporting Services will gain charting capabilities from the integration of the data visualization products from Dundas Data Visualization, Inc., which was acquired by Microsoft.[27] On the management side, SQL Server 2008 includes the Declarative Management Framework which allows configuring policies and constraints, on the entire database or certain tables, declaratively.[19] The version of SQL Server Management Studio included with SQL Server 2008 supports IntelliSense for SQL queries against a SQL Server 2008 Database Engine.[28] SQL Server 2008 also makes the databases available via Windows PowerShell providers and management functionality available as Cmdlets, so that the server and all the running instances can be managed from Windows PowerShell.[29]
The final SQL Server 2008 service pack (10.00.6000, Service Pack 4) was released on September 30, 2014.[30]
SQL Server 2008 had mainstream support until July 8, 2014, and extended support until July 9, 2019.[31] Volume licensed Standard, Web, Enterprise, Workgroup and Datacenter editions of SQL Server 2008 are eligible for the Extended Security Updates program.[32] The first term of yearly installment ended on July 14, 2020, the second term ended on July 13, 2021, and the third term ended on July 12, 2022.[33][34] Those volume licensed editions rehosted on Microsoft Azure automatically received ESUs until July 11, 2023.[35][36][37][38]
SQL Server 2008 R2
[edit]SQL Server 2008 R2 (10.50.1600.1, formerly codenamed "Kilimanjaro") was announced at TechEd 2009, and was released to manufacturing on April 21, 2010.[39] SQL Server 2008 R2 introduced several new features and services:[40]
- a master data management system branded as Master Data Services, a central management of master data entities and hierarchies;
- a number of services and utilities, collectively known as Application and Multi-Server Management[41] (AMSM), to manage multiple SQL Server database instances; these utilities included a centralized console named Utility Control Point (UC);[42]
- PowerPivot for Excel and SharePoint;
- StreamInsight;
- Report Builder 3.0 and Reporting Services Add-in for SharePoint;
- a Data-tier function in Visual Studio that enables packaging of tiered databases as part of an application.
Service Pack 1 (10.50.2500) was released on July 11, 2011,[43] Service Pack 2 (10.50.4000) was released on July 26, 2012[44] and the final service pack, Service Pack 3 (10.50.6000), was released on September 26, 2014.[45]
SQL Server 2008 R2 is the last version of SQL Server to run on Itanium (IA-64) systems, with extended support for SQL Server on Itanium continuing until 2018.[46]
SQL Server 2008 R2 had mainstream support until July 8, 2014, and extended support until July 9, 2019.[47] Volume licensed Standard, Enterprise, Datacenter and Embedded editions of SQL Server 2008 R2 are eligible for the Extended Security Updates program.[32] The first term of yearly installment ended on July 14, 2020, the second term ended on July 13, 2021, and the third term ended on July 12, 2022.[33][34] Volume-licensed editions rehosted on Microsoft Azure automatically received ESUs until July 11, 2023.[35]
SQL Server 2012
[edit]At the 2011 Professional Association for SQL Server (PASS) summit on October 11, Microsoft announced another major version of SQL Server, SQL Server 2012 (codenamed "Denali"). The final version was released to manufacturing on March 6, 2012.[48] SQL Server 2012 Service Pack 1 was released to manufacturing on November 7, 2012, Service Pack 2 was released to manufacturing on June 10, 2014, Service Pack 3 was released to manufacturing on December 1, 2015, and Service Pack 4 was released to manufacturing on October 5, 2017.
It was announced to be the last version to natively support OLE DB and instead to prefer ODBC for native connectivity.[49]
SQL Server 2012's new features and enhancements include Always On SQL Server Failover Cluster Instances and Availability Groups which provides a set of options to improve database availability,[50] Contained Databases which simplify the moving of databases between instances, new and modified Dynamic Management Views and Functions,[51] programmability enhancements including new spatial features,[52] metadata discovery, sequence objects and the THROW statement,[53] performance enhancements such as ColumnStore Indexes as well as improvements to OnLine and partition level operations and security enhancements including provisioning during setup, new permissions, improved role management, and default schema assignment for groups.[54][55]
SQL Server 2012 had mainstream support until July 11, 2017, and extended support until July 12, 2022.[56][35] All volume licensed editions of SQL Server 2012 are eligible for the Extended Security Updates program.[32] The first term of yearly installment ended on July 11, 2023, the second term ended on, 2024, and the third and final term ended on July 8, 2025.[36][34] Those volume licensed editions rehosted on Microsoft Azure automatically received ESUs until July 8, 2025.[38][37]
SQL Server 2014
[edit]SQL Server 2014 was released to manufacturing on March 18, 2014, and released to the general public on April 1, 2014, and the build number was 12.0.2000.8 at release.[57] Until November 2013 there were two CTP revisions, CTP1 and CTP2.[58] SQL Server 2014 provides a new in-memory capability for tables that can fit entirely in memory (also known as Hekaton). Whilst small tables may be entirely resident in memory in all versions of SQL Server, they also may reside on disk, so work is involved in reserving RAM, writing evicted pages to disk, loading new pages from disk, locking the pages in RAM while they are being operated on, and many other tasks. By treating a table as guaranteed to be entirely resident in memory much of the 'plumbing' of disk-based databases can be avoided.[59]
For disk-based SQL Server applications, it also provides the SSD Buffer Pool Extension, which can improve performance by cache between RAM and spinning media.
SQL Server 2014 also enhances the Always On (HADR) solution by increasing the readable secondaries count and sustaining read operations upon secondary-primary disconnections, and it provides new hybrid disaster recovery and backup solutions with Microsoft Azure, enabling customers to use existing skills with the on-premises version of SQL Server to take advantage of Microsoft's global datacenters. In addition, it takes advantage of new Windows Server 2012 and Windows Server 2012 R2 capabilities for database application scalability in a physical or virtual environment.
Microsoft provides three versions of SQL Server 2014 for downloading: the one that runs on Microsoft Azure, the SQL Server 2014 CAB, and SQL Server 2014 ISO.[60]
SQL Server 2014 SP1, consisting primarily of bugfixes, was released on May 15, 2015.[61]
SQL Server 2014 is the last version available for x86/IA-32 systems[62] and the final version supported on Windows Server 2008 R2.[63]
SQL Server 2014 had mainstream support until July 9, 2019, and extended support until July 9, 2024.[64] All volume licensed editions of SQL Server 2014 are eligible for the Extended Security Updates program.[32][65] The first term of yearly installment ended on July 8, 2025, the second term will end on July 14, 2026, and the third and final term will end on July 12, 2027.[34] Those volume licensed editions rehosted on Microsoft Azure automatically receive ESUs until July 12, 2027.
SQL Server 2016
[edit]The official General Availability (GA) release date for SQL Server 2016 (13.0.1601.5) was June 1, 2016, with SQL Server 2016 being the first version to only support x64 processors[62] and the last to have the Service Packs updating mechanism. Service Pack 1 was released on November 16, 2016, Service Pack 2 (13.2.5026) was released on April 24, 2018 and Service Pack 3 was released on September 15, 2021.
SQL Server 2017
[edit]Microsoft launched SQL Server 2017 on October 2, 2017, along with support for Linux.[66][67] This is the final release supporting Windows Server 2012 and 2012 R2.[68][69]
SQL Server 2019
[edit]Microsoft launched SQL Server 2019 (15.x) on November 4, 2019. SQL Server 2019 introduces Big Data Clusters for SQL Server. It also provides additional capability and improvements for the SQL Server database engine, SQL Server Analysis Services, SQL Server Machine Learning Services, SQL Server on Linux, and SQL Server Master Data Services.[70]
SQL Server 2022
[edit]Microsoft launched SQL Server 2022 on November 16, 2022.[71][unreliable source?] However, customers purchasing via OEM, and Services Provider License Agreement (SPLA) had to purchase SQL Server 2022 starting January 2023.[72]
Processor support
[edit]| Version | Intel 286 | IA-32 | x64 | DEC Alpha | MIPS | PowerPC | Itanium | ARM | SH4 |
|---|---|---|---|---|---|---|---|---|---|
| SQL 1.0 | Yes | Yes | No | No | No | No | No | No | No |
| SQL 1.1 | Yes | Yes | No | No | No | No | No | No | No |
| SQL 4.2 | Yes | Yes | No | No | No | No | No | No | No |
| SQL 4.21 | No | Yes | No | Yes | Yes | No | No | No | No |
| SQL 6.0 | No | Yes | No | Yes | Yes | No | No | No | No |
| SQL 6.5 | No | Yes | No | Yes | Yes | Ends after SP2 | No | No | No |
| SQL 7.0 | No | Yes | No | Yes | No | No | No | No | No |
| SQL 2000 | No | Yes | No | Pre-release only | No | No | Starts at SP3 | No | No |
| SQL 2000 CE | No | Yes | Yes | No | Yes | No | No | Yes | Yes |
| SQL 2005 | No | Yes | Yes | No | No | No | Yes | No | No |
| SQL 2005 CE | No | Yes | Yes | No | Yes | No | No | Yes | Yes |
| SQL 2008 | No | Yes | Yes | No | No | No | Yes | No | No |
| SQL 2008 R2 | No | Yes | Yes | No | No | No | Yes | No | No |
| SQL 2012 | No | Yes | Yes | No | No | No | No | No | No |
| SQL 2014 | No | Yes | Yes | No | No | No | No | No | No |
| SQL 2016/17 | No | No | Yes | No | No | No | No | No | No |
| SQL 2019 | No | No | Yes | No | No | No | No | Yes (Edge)[73] | No |
| SQL 2022+ | No | No | Yes | No | No | No | No | No | No |
References
[edit]- ^ a b "RDBMS Workshop: Ingres and Sybase" (PDF) (Interview). Interviewed by Doug Jerger. Computer History Museum. June 13, 2007. Retrieved May 30, 2025.
- ^ a b Mace, Scott (January 18, 1988). "Ashton-Tate, Microsoft Join Forces To Introduce SQL Database Server". InfoWorld. Vol. 10, no. 3. pp. 1, 8. Retrieved May 25, 2025.
- ^ Harris, Scott; Curtis Preston (2007). Backup & Recovery: Inexpensive Backup Solutions for Open Systems. O'Reilly. p. 562. ISBN 978-0596102463.
- ^ "RDBMS Plenary Session: The Later Years" (PDF) (Interview). Interviewed by Burton Grad. Computer History Museum. June 12, 2007. Retrieved May 30, 2025.
- ^ "Developer tools, technical documentation and coding examples".
- ^ "Microsoft ending support for Itanium". April 4, 2010.
- ^ "All about the History of SQL Server". Scriptcase.net. August 14, 2013. Archived from the original on September 16, 2016. Retrieved August 15, 2016.
- ^ "What's New in SQL Server 2000 | New SQL Server 2000 Features | InformIT".
- ^ "ITPro Today: IT News, How-Tos, Trends, Case Studies, Career Tips, More".
- ^ Don Jones (2005). The Definitive Guide to Scaling Out SQL Server 2005 Edition. realtimepublishers.com. ISBN 9781931491532.
- ^ "Database Engine XML Enhancements". Retrieved December 3, 2007.
- ^ "Database Engine Enhancements". Retrieved December 3, 2007.
- ^ Multiple Active Result Sets (MARS) in SQL Server 2005. retrieved June 20, 2009
- ^ Dynamic Management Views and Functions. retrieved June 6, 2010
- ^ "Issues to consider when you use the database mirroring feature in the initial release of SQL Server 2005". Support.microsoft.com. November 20, 2007. Retrieved September 4, 2011.
- ^ "Automatic Failover". Msdn.microsoft.com. Retrieved September 4, 2011.
- ^ "Microsoft SQL Server 2008". Microsoft. Retrieved April 6, 2007.
- ^ a b "ChannelWeb: Next SQL Server stop: Katmai". Archived from the original on March 22, 2007. Retrieved November 5, 2005.
- ^ a b "Microsoft Gives Peek At Next Version Of SQL Server". Archived from the original on October 11, 2007. Retrieved May 11, 2007.
- ^ a b "One more test build to go for SQL Server 2008". Archived from the original on June 23, 2008. Retrieved November 13, 2006.
- ^ "Guest Blogger: Ted Kummert". Retrieved November 20, 2007.
- ^ a b Christian Kleinerman. "SQL Server 2008 for developers". Channel 9. Retrieved March 7, 2008.
- ^ Fernando Azpeitia Lopez (September 4, 2009). "SQL Server 2008 Full-Text Search: Internals and Enhancements".
- ^ "Microsoft Shares Details on SQL Server 2008 Spatial Support by Directions Staff". Archived from the original on August 8, 2007. Retrieved September 7, 2007.
- ^ "Features of SQL 2008". Technet.microsoft.com. February 12, 2009. Retrieved September 4, 2011.
- ^ "SQL Server "Katmai" to Deliver Entity Data Platform and Support LINQ". Retrieved May 12, 2007.
- ^ "Microsoft Details Dynamic IT Strategy at Tech-Ed 2007". Archived from the original on June 5, 2011. Retrieved June 4, 2007.
- ^ "SQL Server IntelliSense". Retrieved August 18, 2008.
- ^ "SQL Server Support for PowerShell!". Retrieved December 3, 2007.
- ^ "SQL Server 2008 Service Pack 4 has released". SQL Release Services Blog. Retrieved October 1, 2014.
- ^ "SQL Server 2008 Support Lifecycle". Microsoft Product Lifecycle.
- ^ a b c d "What are Extended Security Updates for SQL Server?". Microsoft Documentation. July 13, 2023.
- ^ a b Numoto, Takeshi (July 12, 2018). "Announcing new options for SQL Server 2008 and Windows Server 2008 End of Support". Archived from the original on October 30, 2018.
- ^ a b c d "Lifecycle FAQ - Extended Security Updates". Microsoft Documentation.
- ^ a b c "SQL Server 2012 and Windows Server 2012/2012 R2 end of support". June 29, 2022. Archived from the original on July 3, 2022.
- ^ a b Lyons, Debbi; Kumar, Vijay (July 14, 2021). "Know your options for SQL Server 2012 and Windows Server 2012 End of Support". Archived from the original on July 14, 2021.
- ^ a b Carrington, Logan (March 24, 2022). "Move end-of-support SQL Server 2012 to Azure Virtual Machines and save". Archived from the original on March 25, 2022.
- ^ a b Hawk, Jessica (July 12, 2022). "SQL Server 2012 reaches end of support and Microsoft is here to help". Archived from the original on July 12, 2022.
- ^ "SQL Server 2008 R2 Launches!". Retrieved April 21, 2010.
- ^ "Review: Microsoft SQL Server 2008 R2". Networkworld.com. May 3, 2010. Retrieved June 15, 2013.
- ^ "SQL SQL Server 2008 R2 Application and Multi-Server Management". Retrieved June 6, 2010.
- ^ SQL Server Team. "TechEd 2009 – New SQL Server Innovations". MSDN Blogs. Retrieved May 12, 2009.
- ^ "Microsoft® SQL Server® 2008 R2 SP1". Microsoft. Retrieved September 19, 2011.
- ^ "Microsoft® SQL Server® 2008 R2 SP2". Microsoft. Retrieved July 31, 2012.
- ^ "SQL Server 2008 R2 Service Pack 3 has released". SQL Release Services Blog. Retrieved October 1, 2014.
- ^ "Microsoft Dropping Itanium Support -".
- ^ "SQL Server 2008 R2 Support Lifecycle". Microsoft Product Lifecycle.
- ^ "Microsoft Releases SQL Server 2012 to Help Customers Manage "Any Data, Any Size, Anywhere"". Microsoft News Center. Microsoft. March 6, 2012. Retrieved March 7, 2012.
- ^ Lam, Rohan. "Microsoft is Aligning with ODBC for Native Relational Data Access — FAQ". SQL Server Forums. Microsoft Corporation. Retrieved March 7, 2012.
- ^ "Availability Enhancements (Database Engine)". Msdn.microsoft.com. May 24, 2013. Retrieved June 15, 2013.
- ^ "Manageability Enhancements (Database Engine)". Msdn.microsoft.com. July 13, 2011. Retrieved June 15, 2013.
- ^ Alastair Aitchison (2012). Pro Spatial with SQL Server 2012. Apress. pp. 21–23. ISBN 978-1-4302-3491-3.
- ^ "Programmability Enhancements (Database Engine)". Msdn.microsoft.com. April 2012. Retrieved June 15, 2013.
- ^ "Scalability and Performance Enhancements (Database Engine)". Msdn.microsoft.com. April 2012. Retrieved June 15, 2013.
- ^ "Security Enhancements (Database Engine)". Msdn.microsoft.com. Retrieved June 15, 2013.
- ^ "SQL Server 2012 Support Lifecycle". Microsoft Product Lifecycle.
- ^ "List of SQL Server Versions Build Numbers and Service Packs". May 9, 2016.
- ^ Anantharam, Deepthi (October 16, 2013). "SQL Server 2014 – CTP2 is now available". MSDN blogs. Retrieved August 15, 2016.
- ^ SQL Server 2012-2014-Explore. Server Cloud. Microsoft.com (2013-04-17). Retrieved on 2014-03-23
- ^ "Laden Sie die Testversion herunter: Microsoft SQL Server 2014" (in German). Microsoft. Retrieved November 5, 2014.
- ^ "SQL Server 2014 Service Pack 1 release information". Microsoft.com. Microsoft, Inc. Retrieved May 17, 2015.
- ^ a b "Requirements for Installing SQL Server 2016". msdn.microsoft.com. May 2, 2016. Retrieved July 28, 2016.
- ^ "Hardware and Software Requirements for Installing SQL Server 2014 – esiLaw 360 Knowledge Base". June 30, 2017. Retrieved November 10, 2024.
- ^ "SQL Server 2014 Support Lifecycle". Microsoft Product Lifecycle.
- ^ Lyons, Debbi (September 28, 2023). "Protect SQL Server 2014 workloads with Azure flexibility". Microsoft SQL Server Blog. Archived from the original on October 5, 2023.
- ^ Lardinois, Frederic (July 17, 2017). "How Microsoft brought SQL Server to Linux". TechCrunch. Oath Inc. Retrieved September 5, 2017.
The company today launched the first release candidate of SQL Server 2017, which will be the first version to run on Windows, Linux and in Docker containers. The Docker container alone has already seen more than 1 million pulls, so there can be no doubt that there is a lot of interest in this new version.
- ^ "SQL Server 2017 on Windows Linux and Docker is now generally available". October 2, 2017.
- ^ MikeRayMSFT (September 16, 2024). "SQL Server 2016 & 2017: Hardware & software requirements - SQL Server". learn.microsoft.com. Retrieved November 10, 2024.
- ^ MikeRayMSFT (September 17, 2024). "SQL Server 2019: Hardware & software requirements - SQL Server". learn.microsoft.com. Retrieved November 10, 2024.
- ^ "What's new in SQL Server 2019 (15.x)". March 16, 2023.
- ^ Bernard, Andy (February 13, 2023). "Microsoft SQL Server 2022: Here's what you need to know for a successful 2023". The SHI Resource Hub. Retrieved July 5, 2023.
- ^ Kumar, Rohan (November 16, 2022). "SQL Server 2022 is now generally available". Microsoft SQL Server Blog. Retrieved July 5, 2023.
- ^ "Deploy Azure SQL Edge using the Azure portal". January 15, 2023.
History of Microsoft SQL Server
View on GrokipediaEarly Development
Origins and Sybase Partnership
In January 1988, Microsoft Corporation announced a joint development agreement with Sybase, Inc., and Ashton-Tate Corporation to create a relational database management system (RDBMS) for Microsoft's OS/2 operating system.[7] Under the terms, Sybase licensed its existing relational database server technology—originally developed for UNIX platforms—to Microsoft for adaptation to local area networks (LANs) on OS/2, while Ashton-Tate handled integration with its popular dBASE product to enable seamless data access for existing applications.[7] This collaboration aimed to deliver a robust, multi-user database solution optimized for PC-based client-server environments, building on Sybase's core SQL engine to support industry-standard Structured Query Language (SQL) queries.[7] The partnership focused on porting and enhancing Sybase's Data Server for OS/2, emphasizing relational database management capabilities such as data integrity, transaction processing, and networked access for workgroup computing.[8] By leveraging Sybase's proven SQL engine, the project avoided building a database from scratch, allowing Microsoft to quickly enter the enterprise database market with a product that supported stored procedures, triggers, and basic indexing.[9] Ashton-Tate's role extended to retail distribution through its channels, while Sybase handled corporate sales of the integrated package, ensuring broad market reach for dBASE users transitioning to client-server architectures.[7] Microsoft SQL Server 1.0 was first shipped in April 1989 as an add-on product for OS/2 1.2, marking the first commercial version of the jointly developed RDBMS.[10][11] It was priced at a suggested retail of $2,495 per server installation, with no per-user limits, though upgrades from developer kits were available for $300.[10] Key technical specifications included support for Intel 80286 processors, compatibility with OS/2's memory model up to 16 MB of RAM, and the introduction of a basic Transact-SQL (T-SQL) dialect—an extension of ANSI SQL tailored for procedural extensions like control-of-flow language.[12] The product required approximately 10 MB of RAM for smooth operation and 30 MB of disk space, reflecting the era's hardware constraints for 16-bit server applications.[12] From the outset, SQL Server 1.0 was marketed as an affordable, open client-server RDBMS for LANs, directly targeting competition with established players like Oracle by offering scalable multi-user access for DOS, OS/2, and early Windows clients over networks such as 3Com 3+Open and IBM LAN Server.[10] This positioning emphasized its role in enabling networked, relational data management for business applications without the high costs of mainframe or proprietary systems.[11]Initial Releases (1989–1995)
The initial releases of Microsoft SQL Server marked Microsoft's entry into the relational database market through a partnership with Sybase, which provided the core codebase, and Ashton-Tate, which contributed to marketing and front-end integration efforts for the 1.0 version. Released in 1989 as a 16-bit server for OS/2, SQL Server 1.0 offered basic networking support and the System Administrator Facility (SAF) for database creation and queries, targeting departmental LAN environments.[11][13] In 1991, SQL Server 1.1 (codenamed Pietro) extended platform compatibility by adding support for OS/2 1.3 and a preview release of Windows NT 3.1, enabling early testing on Microsoft's emerging enterprise operating system while maintaining OS/2 compatibility. This version also coincided with the end of Ashton-Tate's direct involvement following its acquisition by Borland in 1991, as the partnership shifted focus away from dBASE integration toward broader Windows adoption. In 1993, SQL Server 4.21 (codenamed SQLNT) achieved full production support for Windows NT 3.1 alongside OS/2 1.3, introducing enhancements to stored procedures for reusable code execution, triggers for automated event-based actions, and views for simplified data abstraction, which improved developer productivity and data integrity.[13][14][15] The 1993 release of SQL Server 4.21 further expanded hardware compatibility by adding support for the DEC Alpha architecture, aiming to leverage RISC processors for better performance in non-x86 environments, though adoption remained limited due to optimization challenges and the x86-centric Windows ecosystem. SQL Server 6.0, released in 1995 (codenamed SQL95), represented a major incremental update with tight integration to Windows NT 3.51, introducing full-text search for efficient querying of unstructured data and replication features including snapshot, transactional, and merge types to support distributed database synchronization. These enhancements boosted scalability for mid-sized enterprises, yet SQL Server faced stiff market challenges from Oracle's established dominance in high-end relational databases, where Oracle held superior market share in the 1990s through its Unix-based scalability and enterprise features, while SQL Server struggled with perceptions of limited robustness on non-x86 platforms.[16][13][17]Transition to Independence
Departure from Sybase
In 1994, Microsoft and Sybase formally ended their joint development partnership for SQL Server, marking a pivotal shift in the product's evolution. The announcement came on April 12, 1994, with each company agreeing to pursue independent development paths. Microsoft acquired full ownership and rights to the Windows-based versions of SQL Server, allowing it to tailor the database exclusively for its operating systems, while Sybase retained control over the Unix versions, which would later be rebranded as Adaptive Server Enterprise (ASE). This separation stemmed from diverging strategic priorities, as Microsoft's growing emphasis on Windows NT clashed with Sybase's focus on cross-platform portability.[18][19] The agreement had immediate implications for ongoing product work, particularly SQL Server 6.0, released in June 1995 as the last major version developed collaboratively. Although the split occurred mid-development, Microsoft assumed complete responsibility for Windows and Intel x86 platform enhancements, enabling it to optimize the release for NT environments without Sybase's input on those fronts. Sybase continued to receive royalties from Microsoft's Windows sales during a transitional period, but the partnership's dissolution allowed both firms to eliminate overlapping efforts and reduce royalty dependencies that had previously tied their revenues—Sybase earned approximately $20 million in 1993 from a 5% royalty on Microsoft SQL Server sales. This transition ensured continuity for existing customers while setting the stage for divergent architectures.[20][21] Internally, the departure prompted Microsoft to restructure its database engineering efforts, establishing a more autonomous SQL Server development group to accelerate innovation tailored to Windows ecosystems. This reorganization emphasized building deeper integrations with Windows NT features, such as native threading and memory management, to position SQL Server as a superior choice for Windows-centric enterprises. By prioritizing this tight OS coupling, Microsoft aimed to differentiate its product from cross-platform rivals like Oracle and Sybase's Unix offerings, leveraging Windows' expanding market share to drive adoption among business users. The strategic pivot not only resolved tensions from the partnership but also fueled Microsoft's long-term dominance in the relational database market.[16]SQL Server 6.0 and 6.5
SQL Server 6.0, released in June 1995, marked a significant evolution in Microsoft's database offerings following the end of the Sybase partnership, with the product now fully under Microsoft's control. This version introduced enhanced security measures, including improved user authentication and access controls, to better protect enterprise data environments. It also added support for distributed queries, enabling seamless integration and querying across multiple data sources, which laid groundwork for more complex heterogeneous environments. Additionally, SQL Server 6.0 served as a precursor to OLAP services by incorporating early decision support capabilities that facilitated analytical processing on large datasets.[22] Building on 6.0, SQL Server 6.5 was released to manufacturing in April 1996 and became generally available in June 1996, focusing on stability and enterprise readiness as the final pre-rewrite iteration. A key addition was clustering support through integration with Compaq's Online Recovery Server, providing automatic failover for high availability in mission-critical scenarios. Performance tuning tools were enhanced with features like dynamic locking, which automatically adjusted lock granularity (from row to database level) to balance concurrency and throughput, and native Windows NT threading for improved parallelism. This release was also the last to support the MIPS R4000 architecture, catering to diverse hardware platforms including Intel x86, DEC Alpha, and Motorola PowerPC.[22][23] Both versions emphasized bug fixes and scalability improvements to address growing enterprise demands. SQL Server 6.0 and 6.5 supported databases up to 32 GB in size, a substantial increase from prior limits, enabling handling of larger workloads without frequent partitioning. Backup and restore processes were refined for greater reliability, with 6.5 introducing the ability to back up and restore individual tables alongside point-in-time recovery options via transaction logs, reducing downtime during maintenance. These enhancements included heterogeneous replication to databases like Oracle, IBM DB2, and Sybase, as well as distributed transaction coordination for atomic multiserver operations.[22][24] Mainstream support for SQL Server 6.0 ended in 2000, while extended support for 6.5 concluded on January 1, 2002, after which no further updates or security patches were provided. User feedback during this era highlighted issues with code bloat inherited from the Sybase codebase, including inefficient legacy structures that hampered performance and maintenance, ultimately influencing the decision for a ground-up rewrite in the next major version.[25][26]Rewrite and Core Modernization
Development of SQL Server 7.0
Following the experiences with SQL Server 6.5, which highlighted limitations in scalability and granular locking for high-concurrency online transaction processing environments, Microsoft launched a comprehensive rewrite project to create a fully independent, Windows-native database engine.[27] This initiative, spanning from approximately 1995 to 1998, aimed to transform SQL Server into a high-performance system optimized for the Windows platform, moving away from the shared Sybase codebase that had constrained prior versions.[28] Codenamed Sphinx internally, the project focused on building a componentized architecture that would enable better modularity, allowing individual components like storage and query processing to be developed and optimized independently. The development effort involved a dedicated team of Microsoft engineers led by key architects including David Vaskevitch, Peter Spiro, and Phil Bernstein, with contributions from researchers like Jim Gray to inform core design decisions.[29] Emphasis was placed on creating a scalable system capable of handling terabyte-scale data warehousing and enterprise workloads, with planned innovations such as a new cost-based query optimizer incorporating heuristics for faster plan generation and reduced compilation times.[30] Another major goal was advancing toward zero-administration capabilities through auto-configuration and auto-tuning features, intended to minimize manual intervention in setup, maintenance, and performance tuning for administrators.[29] These objectives aligned with Microsoft's broader vision for lower total cost of ownership, targeting both small-scale mobile deployments and large multi-processor servers. The project also introduced Data Transformation Services (DTS), an extract-transform-load (ETL) tool for data integration tasks.[31] Beta testing commenced in June 1997, with previews demonstrating substantial performance improvements over SQL Server 6.5; for instance, early benchmarks showed up to 10x gains in scalability for enterprise applications like Baan, alongside doubled throughput in SAP R/3 workloads.[32][29] By mid-1998, Beta 3 had reached over 100,000 production sites, providing extensive feedback that refined the engine's reliability and integration points.[29] During this phase, the team incorporated preview features from the upcoming Windows 2000, such as enhanced security protocols compatible with Active Directory, to ensure seamless interoperability and authentication in enterprise environments.[33] This forward-looking integration helped position SQL Server as a cornerstone of Microsoft's enterprise ecosystem, even before Windows 2000's release.SQL Server 7.0
SQL Server 7.0, codenamed Sphinx, was released to general availability in November 1998 after a delay from its originally planned earlier launch. This version represented Microsoft's first fully independent SQL Server release following the separation from Sybase, building on an extensive rewrite of the underlying codebase to enhance performance and scalability. The product marked a pivotal shift, introducing a completely new storage engine that supported row-level locking, improved concurrency, and more efficient logging and recovery mechanisms compared to prior versions.[34][35] Key innovations in SQL Server 7.0 included the Index Tuning Wizard, a tool designed to analyze workloads and recommend optimal index configurations to boost query performance without manual intervention. Additionally, it integrated English Query, a natural language processing interface that allowed users to submit database queries in everyday English sentences, translating them into SQL for execution. These features, combined with automated maintenance tasks like statistics updates and index reorganization, significantly simplified database administration and appealed to a broader range of users beyond expert DBAs. The rewrite process, which involved converting the code from C to C++ and redesigning core components, laid the foundation for these advancements, including enhanced full-text search capabilities.[36][27] SQL Server 7.0 was offered in three main editions: Standard for general-purpose use, Enterprise for high-volume transactional workloads with advanced scalability options, and Personal (also known as Desktop Edition) targeted at developers and small-scale applications. Pricing began at approximately $699 for the Personal Edition under promotional offers, making it more accessible for entry-level deployments while Enterprise editions commanded higher costs for robust features like failover clustering support. This edition lineup helped democratize access to enterprise-grade database technology.[37] The release was the last to support the DEC Alpha architecture, reflecting Microsoft's focus on x86 platforms amid shifting hardware trends. Mainstream support ended on December 31, 2005, with extended support concluding on January 11, 2011. In terms of market reception, SQL Server 7.0 propelled Microsoft to approximately 35% of the relational database market share on the Windows platform by 2000, lauded particularly for its ease of use and cost-effectiveness in Windows environments, which facilitated rapid adoption among mid-sized businesses and developers.[21][38]SQL Server 2000
Microsoft SQL Server 2000, codenamed Shiloh, reached release to manufacturing (RTM) on August 7, 2000, marking a significant evolution in Microsoft's database platform with a focus on enhanced scalability, web integration, and enterprise-level capabilities.[39] This version built upon the architectural foundations of SQL Server 7.0 while introducing features tailored for e-commerce and data-intensive applications, supporting up to 32 processors and 64 GB of RAM in its Enterprise Edition to handle growing business demands.[40] General availability followed on November 30, 2000, with Microsoft emphasizing its tight integration with Windows 2000 for improved reliability and performance in distributed environments.[41] A key advancement in SQL Server 2000 was its native XML support, including XML views that allowed relational data to be queried and returned directly as XML documents over HTTP, streamlining web-centric application development without requiring custom middleware.[42] This feature enabled developers to expose database content via URLs, facilitating easier integration with emerging web technologies and positioning SQL Server as a robust backend for XML-driven services. Complementing this, Analysis Services 2000 provided advanced OLAP functionality, supporting multidimensional data analysis through cubes, dimensions, and measures that enabled complex aggregations and slicing for business intelligence tasks.[43] Additionally, English Query 3.0 allowed end-users to interact with the database using natural language questions, translating English phrases into SQL queries to broaden accessibility for non-technical users.[44] The Enterprise Edition supported the IA-64 (Itanium) architecture from its initial release, enabling 64-bit processing for larger memory addressing and improved performance on enterprise servers. Editions were expanded to include the Developer Edition, which offered full Enterprise Edition features free of charge for non-production use, such as development and testing, to encourage broader adoption among developers.[45] SQL Server 2000 also previewed integration with the .NET Framework through enhanced XML capabilities and data access components, laying groundwork for future managed code interoperability in web and application development, and included a preview of Notification Services for event-driven applications.[46] Mainstream support ended on April 8, 2008, with extended support concluding on April 9, 2013.[4]Enterprise and Integration Advances
SQL Server 2005
SQL Server 2005, codenamed Yukon, was released on November 7, 2005, following delays from its originally planned 2004 launch due to the extensive scope of its architectural changes.[13] This version marked a significant evolution in Microsoft's database platform, emphasizing deeper integration with .NET Framework technologies and support for emerging hardware architectures, which enabled more robust enterprise applications and improved scalability. A major innovation was the integration of the Common Language Runtime (CLR) directly into the database engine, allowing developers to write stored procedures, functions, triggers, and user-defined types in managed languages such as C# or VB.NET.[47] This CLR support extended SQL Server's programmability beyond T-SQL, facilitating complex computations and custom logic within the database while maintaining security through code access security and permission sets. Complementing this, the introduction of the native XML data type provided built-in storage and querying for XML documents, building briefly on the XML enhancements from SQL Server 2000 by adding validation against XML schemas, indexing, and methods like .query() for XQuery operations.[48] Additionally, Service Broker emerged as a reliable asynchronous messaging framework for building database-integrated applications, supporting queued operations and conversations without external middleware.[49] SQL Server 2005 introduced native support for 64-bit (x64 and Itanium) architectures, allowing the database engine to fully leverage larger memory capacities and multi-core processors for better performance in data-intensive workloads.[50] Notification Services was another key addition, enabling the creation of event-driven alert systems that monitor data changes and deliver notifications via email, SMS, or other protocols, which proved useful for real-time applications like business intelligence dashboards.[51] The release expanded edition options to cater to diverse needs, including the free SQL Server 2005 Express Edition, a lightweight version limited to 1 GB of memory and 4 GB databases but suitable for development and small-scale deployments.[52] Security was bolstered with features like stricter default configurations—such as disabling ad-hoc remote queries and sa account—and in Express Edition, user instances that provided isolated, per-user database environments to prevent interference and enhance data protection.[53] Mainstream support for SQL Server 2005 ended on April 12, 2011, with extended support concluding on April 12, 2016.[50]SQL Server 2008
Microsoft SQL Server 2008, codenamed Katmai, was released on August 6, 2008, as a major update to the database management system, emphasizing advancements in data handling, security, and administrative automation.[54][55] This version built upon the .NET integration introduced in SQL Server 2005 by introducing features that improved efficiency for handling unstructured data, geospatial information, and resource allocation, while enhancing Transact-SQL (T-SQL) capabilities for more sophisticated data operations. It was designed to integrate seamlessly with Windows Server 2008, leveraging the operating system's enhanced security and clustering features for better scalability in enterprise environments. A key innovation in SQL Server 2008 was the FILESTREAM feature, which enabled the storage and management of binary large objects (BLOBs) directly in the NTFS file system while allowing full transactional consistency through SQL Server. This approach addressed performance limitations of traditional BLOB storage in the database by combining file system speed with database ACID properties, making it suitable for applications like document management and media storage.[56] SQL Server 2008 also introduced native support for spatial data through the GEOGRAPHY and GEOMETRY data types, along with associated methods and spatial indexing. The GEOGRAPHY type handled round-earth calculations for real-world locations, while GEOMETRY supported planar (Euclidean) geometries, enabling applications in geographic information systems (GIS), mapping, and location-based services to perform queries like distance calculations and overlap detection directly in SQL.[57] To manage resource contention in multi-workload environments, Resource Governor was added, allowing database administrators to classify sessions into resource pools and set limits on CPU, memory, and I/O usage.[58] This feature provided predictable performance by preventing any single workload from monopolizing server resources, particularly useful in consolidated server setups.[59] Enhancements to T-SQL included the MERGE statement, which combined INSERT, UPDATE, and DELETE operations into a single atomic statement based on a join condition between source and target tables.[60] This simplified ETL processes and reduced the need for multiple conditional statements, improving code readability and performance in data synchronization scenarios. Additionally, Change Data Capture (CDC) was introduced to asynchronously track insert, update, and delete operations on tables by reading the transaction log and storing changes in system tables for auditing or replication purposes.[61][62] Policy-Based Management provided a declarative framework for enforcing configuration standards across SQL Server instances, using facets, conditions, and policies to evaluate and remediate settings like surface area configurations or backup compliance.[63] This centralized approach reduced administrative overhead and ensured consistency in multi-server deployments.[64] Mainstream support for SQL Server 2008 ended on July 8, 2014, with extended support concluding on July 9, 2019; however, Extended Security Updates were available until July 2022 for organizations needing additional time to migrate.[65][66]SQL Server 2008 R2
Microsoft SQL Server 2008 R2, codenamed Kilimanjaro, reached release to manufacturing on April 20, 2010, and became generally available shortly thereafter as an incremental release building on SQL Server 2008.[67] This version emphasized advancements in business intelligence (BI), data management, and scalable data warehousing to support enterprise analytics needs. It introduced tools aimed at empowering business users with self-service capabilities while enhancing server-side processing for complex workloads. SQL Server 2008 R2 was the final version to provide native support for Itanium-based systems, aligning with the phasing out of IA64 architecture in subsequent Microsoft products.[68] Extended support concluded on July 9, 2019, with Extended Security Updates available until July 12, 2022.[69] A key addition was PowerPivot, a technology integrated directly into Microsoft Excel 2010 and SharePoint Server 2010, allowing business analysts to import, manage, and analyze millions of rows of data without requiring IT intervention. PowerPivot leverages the in-memory columnar storage engine known as VertiPaq and the Data Analysis Expressions (DAX) query language to enable interactive PivotTables, data modeling, and compression for large datasets sourced from various feeds. This feature democratized BI by extending Analysis Services capabilities to desktop users, facilitating faster insights from disparate data sources.[70] Master Data Services (MDS) was introduced as a comprehensive master data management solution, enabling organizations to create, maintain, and distribute a single, authoritative view of critical business entities such as products, customers, and accounts. MDS supports flexible hierarchies, business rules for data validation, versioning for audit trails, and role-based security, all accessible via a web-based interface and a Web services API for integration with custom applications. It helps ensure data consistency across systems, reducing errors in reporting and analytics.[70] Complementing this, the Parallel Data Warehouse (PDW) appliance provided a turnkey, massively parallel processing (MPP) solution for terabyte- to petabyte-scale data warehousing, utilizing a shared-nothing architecture to distribute queries across multiple nodes for high performance and scalability. PDW integrates with standard SQL Server tools and supports direct data loading from external sources, targeting large enterprises needing appliance-based deployment without custom hardware configuration.[70] StreamInsight debuted as a complex event processing (CEP) platform for real-time analytics on streaming data, such as sensor inputs or financial transactions, using temporal SQL extensions for operations like joins, aggregations, and windowing over high-velocity event streams. It processes events at rates exceeding millions per second, enabling low-latency detection of patterns and anomalies in scenarios like fraud detection or supply chain monitoring. Reporting Services in SQL Server 2008 R2 saw enhancements including support for new data sources like SharePoint lists and the PDW appliance, along with improved visualizations such as sparklines, maps, and dynamic formatting options to make reports more interactive and embeddable in SharePoint environments. These updates built on the spatial data types introduced in SQL Server 2008, allowing geographic visualizations in reports.[70]High Availability and Performance Focus
SQL Server 2012
Microsoft SQL Server 2012, codenamed Denali during development, was generally available on April 1, 2012.[71][72] This version emphasized enhancements in high availability, mission-critical performance, and security, building on prior releases to support enterprise-scale deployments. It introduced features aimed at reducing downtime, improving query efficiency for analytical workloads, and simplifying database portability, positioning SQL Server as a robust platform for business-critical applications.[73] A major advancement was Always On Availability Groups, which provided flexible high availability and disaster recovery by allowing up to five replicas per group, including support for readable secondary replicas to offload reporting and backups.[73] This feature replaced and extended database mirroring from earlier versions, enabling automatic failover and multi-site configurations without shared storage. Columnstore indexes were introduced to accelerate data warehousing queries, storing data in a columnar format that achieved up to 100 times better performance on analytics workloads through batch-mode processing and compression ratios up to 10 times higher than rowstore indexes.[74] Contained databases further enhanced security and portability by isolating user authentication and metadata within the database itself, eliminating dependencies on instance-level logins and facilitating easier migrations across servers.[75] Transact-SQL (T-SQL) saw key improvements for developer productivity, including the OFFSET and FETCH clauses for efficient pagination in result sets, which allowed skipping a specified number of rows before fetching the next batch—essential for large-scale data retrieval without custom logic.[76] The THROW statement was added for streamlined error handling, enabling developers to raise exceptions with a simple syntax that supports re-throwing from TRY...CATCH blocks and provides more precise error reporting than the deprecated RAISERROR.[77] SQL Server 2012 was the final version to include native support for the OLE DB provider via SQL Server Native Client 11.0, which handled connectivity for legacy applications; subsequent versions shifted to the separate Microsoft OLE DB Driver for SQL Server.[78] To address business intelligence needs, Microsoft introduced the Business Intelligence Edition, which bundled all Standard Edition features with advanced BI tools like PowerPivot, Analysis Services tabular models, and Reporting Services data alerts, available at a per-server + CAL licensing model.[79] Mainstream support for SQL Server 2012 ended on July 11, 2017, with extended support concluding on July 12, 2022; Extended Security Updates were available for three additional years, ending on July 8, 2025, to provide critical patches during migration.[80]SQL Server 2014
Microsoft SQL Server 2014, released on April 1, 2014, represented a significant advancement in database management by integrating in-memory capabilities and hybrid cloud functionalities, building on the high availability features introduced in prior versions. Developed under the codename Hekaton for its in-memory components, this version aimed to enhance performance for online transaction processing (OLTP) workloads while enabling seamless integration with cloud services. It was the final release to support 32-bit (x86) architectures, marking the transition to 64-bit exclusivity in subsequent versions.[81][82][83] A cornerstone feature was In-Memory OLTP, powered by the Hekaton engine, which introduced memory-optimized tables and natively compiled stored procedures to dramatically reduce latency and eliminate locking and latching overhead in high-throughput OLTP scenarios. This engine allowed tables to reside entirely in memory while maintaining full transactional consistency and durability through logging to disk, achieving up to 30 times the throughput of traditional disk-based OLTP in benchmarks. Memory-optimized tables could coexist with traditional rowstore and columnstore tables, enabling hybrid workloads without requiring a complete database redesign.[84][85] SQL Server 2014 pioneered hybrid cloud integration with features like backup to Azure Blob Storage via URL, allowing direct writes of backups to cloud storage without local intermediaries, and Managed Backup to Microsoft Azure, which automated backup scheduling based on data change rates. Stretch Database further extended this by enabling transparent migration of cold or historical data from on-premises tables to Azure SQL Database, where it remained queryable as if local, reducing storage costs and maintenance without application changes—though this feature was discontinued in July 2024. These capabilities facilitated a bridge between on-premises and cloud environments, supporting disaster recovery and archival scenarios.[86][87][88] Enhancements to Always On Availability Groups, originally introduced in SQL Server 2012, improved high availability by supporting up to eight secondary replicas (doubled from four) and enhancing readable secondaries for multi-site deployments, allowing read workloads to be offloaded more effectively across distributed environments. Extended support for SQL Server 2014 ended on July 9, 2024, with Extended Security Updates available for up to three additional years until July 12, 2027, to provide critical security patches for legacy deployments.[89][90][91]SQL Server 2016
SQL Server 2016, codenamed Helsinki, was released by Microsoft on June 1, 2016, marking a significant evolution in database analytics, security, and hybrid cloud integration.[92][93] This version introduced native support for advanced data processing and monitoring features, building on prior in-memory OLTP capabilities from SQL Server 2014 to enhance overall performance and scalability.[94] As the first SQL Server release exclusively supporting 64-bit (x64) processors, it discontinued compatibility with 32-bit (x86) systems, aligning with modern hardware trends and optimizing resource utilization.[95] A key addition was built-in JSON support within Transact-SQL (T-SQL), enabling developers to store, index, query, and modify JSON data directly in the database without external processing.[94] This facilitated easier integration with web and mobile applications by treating JSON as a first-class data type, including functions for parsing, validation, and extraction. Temporal tables, also known as system-versioned temporal tables, were introduced to automatically track historical data changes, maintaining a full audit trail with timestamps for each row modification, insertion, or deletion.[96] These tables use a current table for live data and a linked history table for past versions, simplifying compliance and trend analysis without custom triggers or application logic. SQL Server 2016 also debuted R Services (later renamed Machine Learning Services), allowing in-database execution of R scripts for advanced analytics and machine learning directly alongside relational data.[97] This integration, powered by the Microsoft R Open distribution, enabled secure, scalable data science workflows by processing data in-place, reducing data movement and enhancing privacy for sensitive information. The Query Store feature provided always-on performance diagnostics by persistently capturing query text, execution plans, and runtime statistics, aiding in regression detection and plan forcing.[98] It integrated with Always On Availability Groups, ensuring query insights across primary and readable secondary replicas for high-availability environments.[99] Stretch Database received enhancements in this release, expanding its hybrid capabilities for archiving infrequently accessed ("cold") data to Microsoft Azure transparently and securely, while keeping active data on-premises.[94] Features like row-level filtering and dynamic data migration improved efficiency, allowing seamless querying across local and cloud storage without application changes. SQL Server 2016 follows Microsoft's Fixed Lifecycle Policy, with mainstream support ending on July 13, 2021, and extended support concluding on July 14, 2026; Extended Security Updates are available for up to three additional years until July 17, 2029.[93]Cross-Platform and Cloud Era
SQL Server 2017
SQL Server 2017, version 14.0, marked a significant milestone in the evolution of Microsoft's relational database management system by introducing native support for Linux operating systems, expanding beyond its traditional Windows-centric deployment model. Released on October 2, 2017, this version enabled SQL Server to run directly on popular Linux distributions including Red Hat Enterprise Linux 7.3 and later, SUSE Linux Enterprise Server v12 SP2 and later, and Ubuntu 16.04 and later, as well as in Docker containers for containerized environments.[100][101][102] This cross-platform capability allowed organizations to leverage SQL Server's enterprise features in heterogeneous environments, supporting workloads such as high availability, security, and performance optimization on Linux without requiring Windows hosts.[102] A key enhancement in SQL Server 2017 was the expansion of Machine Learning Services to include Python integration, building on the R language support introduced in the previous version. This feature enabled in-database execution of Python scripts using the sp_execute_external_script stored procedure, allowing data scientists to perform advanced analytics, machine learning model training, and data processing directly within the database engine while maintaining data security and reducing latency from data movement.[103][104] Python support was available on Windows installations, with compatibility for popular libraries like pandas and scikit-learn, though it was not enabled on Linux in this release.[105] SQL Server 2017 also introduced a preview of adaptive query processing, a family of intelligent query optimization techniques designed to improve performance for complex workloads by dynamically adjusting execution plans based on runtime statistics. These included batch mode adaptive joins, which switch between nested loop and hash join strategies mid-execution; approximate distinct count using adaptive histograms for faster cardinality estimation; and interleaved execution for multi-statement table-valued functions to enhance parallelism.[106] Additionally, the release added graph data processing extensions, integrating node and edge tables with MATCH and shortest_path T-SQL predicates to model and query complex relationships, such as social networks or recommendation engines, natively within the relational engine.[107] Mainstream support for SQL Server 2017 ended on October 11, 2022, with extended support continuing until October 12, 2027.[108]SQL Server 2019
Microsoft SQL Server 2019 was released to general availability on November 4, 2019.[109] This version marked a significant shift toward integrating relational databases with big data and artificial intelligence capabilities, enabling organizations to analyze diverse data sources more efficiently.[110] Building on Linux support introduced in SQL Server 2017, the 2019 release expanded cross-platform deployment options while emphasizing scalability and intelligence.[111] A key innovation in SQL Server 2019 was the introduction of Big Data Clusters, which combine SQL Server with Apache Spark and Hadoop Distributed File System (HDFS) to form scalable, containerized clusters.[111] These clusters allow users to process and query large-scale, polyglot data using familiar T-SQL syntax, supporting both relational and non-relational workloads in a unified environment.[112] This feature facilitates machine learning on big data by integrating Spark for distributed processing and enabling data virtualization across on-premises, cloud, and edge scenarios.[113] SQL Server 2019 also advanced AI integration through enhancements to Machine Learning Services, including the addition of Java Language Extensions.[114] This extensibility framework permits the execution of Java code directly within the database, allowing developers to build and deploy machine learning models using Java libraries alongside R and Python scripts.[115] Such capabilities streamline AI workflows by keeping data processing in-database, reducing latency and data movement.[116] Intelligent Query Processing emerged as another cornerstone feature, comprising adaptive techniques like batch mode execution on rowstore tables and scalar user-defined function inlining to optimize query performance automatically.[117] These AI-driven optimizations adjust based on workload patterns, improving efficiency for complex queries without manual tuning.[109] Additionally, Unicode support was enhanced with native UTF-8 collations, enabling varchar columns to store Unicode characters while minimizing storage overhead for ASCII-dominant data and improving sorting for multilingual applications.[118] To bolster reliability, SQL Server 2019 introduced Accelerated Database Recovery, which redesigns the transaction log recovery process to achieve near-instantaneous restarts after failures.[119] By decoupling recovery from long-running transactions and using persistent versioning, this feature significantly reduces downtime in high-availability environments.[120] Mainstream support for SQL Server 2019 ended on February 28, 2025, with extended support available until January 8, 2030; note that Big Data Clusters reached end-of-life on February 28, 2025.[121]SQL Server 2022
Microsoft SQL Server 2022, codenamed Dallas, was generally available on November 16, 2022, marking a significant evolution in Microsoft's relational database management system with emphasis on security, seamless Azure integration, and capabilities for handling modern data workloads.[122][123] This release builds on prior versions by introducing features that enhance data integrity, performance optimization, and hybrid cloud connectivity, enabling organizations to manage operational data alongside analytics without extensive infrastructure changes.[124] A core security innovation is the Ledger feature, which provides tamper-proof tables through cryptographic verification and immutability guarantees, ensuring data cannot be altered without detection and supporting compliance in regulated environments.[125] Complementing this, Query Store hints empower database administrators to influence query execution plans directly via the Query Store, eliminating the need for application code modifications while improving performance predictability.[126] These tools address common challenges in maintaining secure and efficient database operations amid growing data volumes. For Azure integration, SQL Server 2022 introduces Azure Synapse Link, facilitating near real-time analytics on operational data by streaming changes to Azure Synapse Analytics without traditional ETL processes, thus reducing latency for hybrid scenarios.[127] Enhanced distributed availability groups further bolster high availability by utilizing multiple TCP connections to optimize network bandwidth across geographically dispersed replicas.[124] Additionally, integration with the Microsoft Fabric preview enables mirrored databases for advanced analytics, allowing SQL Server instances to sync data continuously to Fabric's lakehouse architecture for unified data management.[128] To support large-scale modern workloads, SQL Server 2022 adds approximate aggregate functions such asAPPROX_PERCENTILE_CONT and APPROX_PERCENTILE_DISC, which compute interpolated percentiles efficiently on massive datasets with low memory overhead, ideal for scenarios involving approximate distinct value analysis without exact counts.[129] Mainstream support for SQL Server 2022 ends on January 11, 2028, with extended support projected until January 11, 2033, during which cumulative updates including security fixes will continue to be provided.[130]
