fbpx
Wikipedia

History of Microsoft SQL Server

The 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 4.21a SQLNT  –
6.0 1995 ? ? SQL Server 6.0 SQL95 406
6.5 1996 ? ? SQL Server 6.5 Hydra 408
7.0 1998 Old version, no longer maintained: December 31, 2005 Old version, no longer maintained: January 11, 2011 SQL Server 7.0 Sphinx 515
1999 ? ? SQL Server 7.0 OLAP Tools Plato  –
8.0 2000 Old version, no longer maintained: April 8, 2008 Old version, no longer maintained: April 9, 2013 SQL Server 2000 Shiloh 539
8.0 2003 ? ? SQL Server 2000 64-bit Edition Liberty 539
9.0 January 14, 2006 Old version, no longer maintained: April 12, 2011 Old version, no longer maintained: April 12, 2016 SQL Server 2005 Yukon 611/612
10.0 November 6, 2008 Old version, no longer maintained: July 8, 2014 Old version, no longer maintained: 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 Old version, no longer maintained: July 8, 2014 Old version, no longer maintained: July 9, 2019 SQL Server 2008 R2 Kilimanjaro (aka KJ) 661
11.0 May 20, 2012 Old version, no longer maintained: July 11, 2017 Old version, no longer maintained: July 12, 2022 SQL Server 2012 Denali 706
12.0 2014 ? ? Azure SQL database  –  –
12.0 June 5, 2014 Old version, no longer maintained: July 9, 2019 Older version, yet still maintained: July 9, 2024 SQL Server 2014 Hekaton 782
13.0 June 1, 2016 Old version, no longer maintained: July 13, 2021 Older version, yet still maintained: July 14, 2026 SQL Server 2016 SQL16 852
14.0 September 29, 2017 Old version, no longer maintained: October 11, 2022 Older version, yet still maintained: October 12, 2027 SQL Server 2017 Helsinki 869
15.0 November 4, 2019 Older version, yet still maintained: January 14, 2025 Older version, yet still maintained: January 8, 2030 SQL Server 2019 Seattle 895
16.0 November 16, 2022 Current stable version: January 11, 2028 Current stable version: January 11, 2033 SQL Server 2022 Dallas 957
Legend:   Old version   Older version, still maintained   Latest version

Detailed history edit

Genesis edit

On June 12, 1988, Microsoft joined Ashton-Tate and Sybase to create a variant of Sybase SQL Server for IBM OS/2 (then developed jointly with Microsoft), which was released the following year.[1] 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.

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

 
SQL Server 7.0 Splash Screen

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[2]). 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[3]). By SQL Server 2005 the legacy Sybase code had been completely rewritten.[4]

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:

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.[5][6]

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") ws released in November 2005. 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 (protocol) requests. When the data is accessed over web services, results are returned as XML.[7]

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.[8]

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.

SQL Server 2005 introduced "MARS" (Multiple Active Results Sets), a method of allowing usage of database connections for multiple purposes.[9]

SQL Server 2005 introduced DMVs (Dynamic Management Views), which are 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.[10]

SQL Server 2005 was the first version with native support for the x64 platform.[11]

Service Pack 1 (SP1) of SQL Server 2005 introduced Database Mirroring, a high availability option that provides redundancy and failover capabilities at the database level.[12] Failover can be performed manually or can be configured for automatic failover. Automatic failover requires a witness partner and an operating mode of synchronous (also known as high-safety or full safety).[13] Database Mirroring was included in the first release of SQL Server 2005 for evaluation purposes only. Prior to SP1, it was not enabled by default, and was not supported by Microsoft.[citation needed]

Service Pack 1 was released on April 18, 2006, 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")[14][15] 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.[15]

Other new data types include specialized date and time types and a Spatial data type for location-dependent data.[16] Better support for unstructured and semi-structured data is provided using the new FILESTREAM[17] data type, which can be used to reference any file stored on the file system.[18] 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.[19] SQL Server 2008 also natively supports hierarchical data, and includes T-SQL constructs to directly deal with them, without using recursive queries.[19]

The full-text search functionality has been integrated with the database engine. According to a Microsoft technical article, this simplifies management and improves performance.[20]

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.[21]

SQL Server includes better compression features, which also helps in improving scalability.[22] 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.[17] 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.[23] 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.[24] 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.[16] The version of SQL Server Management Studio included with SQL Server 2008 supports IntelliSense for SQL queries against a SQL Server 2008 Database Engine.[25] 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.[26]

The final SQL Server 2008 service pack (10.00.6000, Service Pack 4) was released on September 30, 2014.[27]

SQL Server 2008 had mainstream support until July 8, 2014, and extended support until July 9, 2019.[28] Volume licensed Standard, Web, Enterprise, Workgroup and Datacenter editions of SQL Server 2008 are eligible for the Extended Security Updates program.[29] 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.[30][31] Those volume licensed editions rehosted on Microsoft Azure automatically received ESUs until July 11, 2023.[32][33][34][35]

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.[36] SQL Server 2008 R2 adds certain features to SQL Server 2008 including a master data management system branded as Master Data Services, a central management of master data entities and hierarchies. Also Multi Server Management, a centralized console to manage multiple SQL Server 2008 instances and services including relational databases, Reporting Services, Analysis Services & Integration Services.[37]

SQL Server 2008 R2 includes a number of new services,[38] including PowerPivot for Excel and SharePoint, Master Data Services, StreamInsight, Report Builder 3.0, Reporting Services Add-in for SharePoint, a Data-tier function in Visual Studio that enables packaging of tiered databases as part of an application, and a SQL Server Utility named UC (Utility Control Point), part of AMSM (Application and Multi-Server Management) that is used to manage multiple SQL Servers.[39]

The first SQL Server 2008 R2 service pack (10.50.2500, Service Pack 1) was released on July 11, 2011.[40] The second SQL Server 2008 R2 service pack (10.50.4000, Service Pack 2) was released on July 26, 2012.[41] The final SQL Server 2008 R2 service pack (10.50.6000, Service Pack 3) was released on September 26, 2014.[42]

SQL 2008 R2 would be the last version of SQL Server to run on the Itanium (IA-64) platform. However, the x64 platform would continue on in force. Extended support for SQL Server on Itanium would continue until 2018. [43]

SQL Server 2008 R2 had mainstream support until July 8, 2014, and extended support until July 9, 2019.[44] Volume licensed Standard, Enterprise, Datacenter and Embedded editions of SQL Server 2008 R2 are eligible for the Extended Security Updates program.[29] 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.[30][31] Those volume licensed editions rehosted on Microsoft Azure automatically received ESUs until July 11, 2023.[32]

SQL Server 2012 edit

At the 2011 Professional Association for SQL Server (PASS) summit on October 11, Microsoft announced that the next major version of SQL Server (codenamed "Denali"), would be SQL Server 2012. It was released to manufacturing on March 6, 2012.[45] 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.[46]

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,[47] Contained Databases which simplify the moving of databases between instances, new and modified Dynamic Management Views and Functions,[48] programmability enhancements including new spatial features,[49] metadata discovery, sequence objects and the THROW statement,[50] 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.[51][52]

SQL Server 2012 had mainstream support until July 11, 2017, and extended support until July 12, 2022.[53][32] All volume licensed editions of SQL Server 2012 are eligible for the Extended Security Updates program.[29] The first term of yearly installment ended on July 11, 2023, the second term will end on July 9, 2024, and the third and final term will end on July 8, 2025.[33][31] Those volume licensed editions rehosted on Microsoft Azure automatically receive ESUs until July 8, 2025.[35][34]

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.[54] Until November 2013 there were two CTP revisions, CTP1 and CTP2.[55] 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.[56]

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.[57]

SQL Server 2014 SP1, consisting primarily of bugfixes, was released on May 15, 2015.[58]

SQL Server 2014 is the last version available on x86/IA32 architecture.[59]

On windows Server 2008 R2, it is the last installable.[1]

SQL Server 2014 had mainstream support until July 9, 2019, and extended support until July 9, 2024.[60] All volume licensed editions of SQL Server 2014 are eligible for the Extended Security Updates program.[29][61] The first term of yearly installment will end 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.[31] 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 was June 1, 2016. The RTM version is 13.0.1601.5. Service pack 2 updates the version to 13.2.5026. Service Pack 1 was released on November 16, 2016, Service Pack 2 was released on April 24, 2018, and Service Pack 3 was released on September 15, 2021.

SQL Server 2016 is supported on x64 processors only. It is no longer supported on x86 processors.[59]

SQL Server 2016 is the last version to have Service Packs launched.

SQL Server 2017 edit

Microsoft launched SQL Server 2017 on October 2, 2017, along with support for Linux.[62][63]

On windows Server 2012 and 2012 R2, it is the last installable.[2]

SQL Server 2019 edit

Microsoft launched SQL Server 2019 on November 4, 2019. SQL Server 2019 (15.x) 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.[64]

SQL Server 2022 edit

Microsoft launched SQL Server 2022 on November 16, 2022.[65][unreliable source?] However, customers purchasing via OEM, and Services Provider License Agreement (SPLA) had to purchase SQL Server 2022 starting January 2023.[66]

Processor support edit

Processor support for SQL Server
Version x286 x386 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)[67] No

References edit

  1. ^ Harris, Scott; Curtis Preston (2007). Backup & Recovery: Inexpensive Backup Solutions for Open Systems. O'Reilly. p. 562. ISBN 978-0596102463.
  2. ^ "Developer tools, technical documentation and coding examples".
  3. ^ "Microsoft ending support for Itanium". April 4, 2010.
  4. ^ "All about the History of SQL Server". Scriptcase.net. August 14, 2013. Retrieved August 15, 2016.
  5. ^ "What's New in SQL Server 2000 | New SQL Server 2000 Features | InformIT".
  6. ^ "ITPro Today: IT News, How-Tos, Trends, Case Studies, Career Tips, More".
  7. ^ "Database Engine XML Enhancements". Retrieved December 3, 2007.
  8. ^ "Database Engine Enhancements". Retrieved December 3, 2007.
  9. ^ Multiple Active Result Sets (MARS) in SQL Server 2005. retrieved June 20, 2009
  10. ^ Dynamic Management Views and Functions. retrieved June 6, 2010
  11. ^ Don Jones (2005). The Definitive Guide to Scaling Out SQL Server 2005 Edition. realtimepublishers.com. ISBN 9781931491532.
  12. ^ "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.
  13. ^ "Automatic Failover". Msdn.microsoft.com. Retrieved September 4, 2011.
  14. ^ "Microsoft SQL Server 2008". Microsoft. Retrieved April 6, 2007.
  15. ^ a b . Archived from the original on March 22, 2007. Retrieved November 5, 2005.
  16. ^ a b . Archived from the original on October 11, 2007. Retrieved May 11, 2007.
  17. ^ a b . Archived from the original on June 23, 2008. Retrieved November 13, 2006.
  18. ^ "Guest Blogger: Ted Kummert". Retrieved November 20, 2007.
  19. ^ a b Christian Kleinerman. "SQL Server 2008 for developers". Channel 9. Retrieved March 7, 2008.
  20. ^ Fernando Azpeitia Lopez (September 4, 2009). "SQL Server 2008 Full-Text Search: Internals and Enhancements".
  21. ^ . Archived from the original on August 8, 2007. Retrieved September 7, 2007.
  22. ^ "Features of SQL 2008". Technet.microsoft.com. February 12, 2009. Retrieved September 4, 2011.
  23. ^ "SQL Server "Katmai" to Deliver Entity Data Platform and Support LINQ". Retrieved May 12, 2007.
  24. ^ . Archived from the original on June 5, 2011. Retrieved June 4, 2007.
  25. ^ "SQL Server IntelliSense". Retrieved August 18, 2008.
  26. ^ "SQL Server Support for PowerShell!". Retrieved December 3, 2007.
  27. ^ "SQL Server 2008 Service Pack 4 has released". SQL Release Services Blog. Retrieved October 1, 2014.
  28. ^ "SQL Server 2008 Support Lifecycle". Microsoft Product Lifecycle.
  29. ^ a b c d "What are Extended Security Updates for SQL Server?". Microsoft Documentation. July 13, 2023.
  30. ^ a b Numoto, Takeshi (July 12, 2018). "Announcing new options for SQL Server 2008 and Windows Server 2008 End of Support". from the original on October 30, 2018.
  31. ^ a b c d "Lifecycle FAQ - Extended Security Updates". Microsoft Documentation.
  32. ^ a b c "SQL Server 2012 and Windows Server 2012/2012 R2 end of support". June 29, 2022. from the original on July 3, 2022.
  33. ^ a b Lyons, Debbi; Kumar, Vijay (July 14, 2021). "Know your options for SQL Server 2012 and Windows Server 2012 End of Support". from the original on July 14, 2021.
  34. ^ a b Carrington, Logan (March 24, 2022). "Move end-of-support SQL Server 2012 to Azure Virtual Machines and save". from the original on March 25, 2022.
  35. ^ a b Hawk, Jessica (July 12, 2022). "SQL Server 2012 reaches end of support and Microsoft is here to help". from the original on July 12, 2022.
  36. ^ "SQL Server 2008 R2 Launches!". Retrieved April 21, 2010.
  37. ^ SQL Server Team. "TechEd 2009 – New SQL Server Innovations". MSDN Blogs. Retrieved May 12, 2009.
  38. ^ "Review: Microsoft SQL Server 2008 R2". Networkworld.com. May 3, 2010. Retrieved June 15, 2013.
  39. ^ "SQL SQL Server 2008 R2 Application and Multi-Server Management". Retrieved June 6, 2010.
  40. ^ "Microsoft® SQL Server® 2008 R2 SP1". Microsoft. Retrieved September 19, 2011.
  41. ^ "Microsoft® SQL Server® 2008 R2 SP2". Microsoft. Retrieved July 31, 2012.
  42. ^ "SQL Server 2008 R2 Service Pack 3 has released". SQL Release Services Blog. Retrieved October 1, 2014.
  43. ^ "Microsoft Dropping Itanium Support -".
  44. ^ "SQL Server 2008 R2 Support Lifecycle". Microsoft Product Lifecycle.
  45. ^ "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.
  46. ^ Lam, Rohan. "Microsoft is Aligning with ODBC for Native Relational Data Access — FAQ". SQL Server Forums. Microsoft Corporation. Retrieved March 7, 2012.
  47. ^ "Availability Enhancements (Database Engine)". Msdn.microsoft.com. May 24, 2013. Retrieved June 15, 2013.
  48. ^ "Manageability Enhancements (Database Engine)". Msdn.microsoft.com. July 13, 2011. Retrieved June 15, 2013.
  49. ^ Alastair Aitchison (2012). Pro Spatial with SQL Server 2012. Apress. pp. 21–23. ISBN 978-1-4302-3491-3.
  50. ^ "Programmability Enhancements (Database Engine)". Msdn.microsoft.com. April 2012. Retrieved June 15, 2013.
  51. ^ "Scalability and Performance Enhancements (Database Engine)". Msdn.microsoft.com. April 2012. Retrieved June 15, 2013.
  52. ^ "Security Enhancements (Database Engine)". Msdn.microsoft.com. Retrieved June 15, 2013.
  53. ^ "SQL Server 2012 Support Lifecycle". Microsoft Product Lifecycle.
  54. ^ "List of SQL Server Versions Build Numbers and Service Packs". May 9, 2016.
  55. ^ Anantharam, Deepthi (October 16, 2013). "SQL Server 2014 – CTP2 is now available". MSDN blogs. Retrieved August 15, 2016.
  56. ^ SQL Server 2012-2014-Explore. Server Cloud. Microsoft.com (2013-04-17). Retrieved on 2014-03-23
  57. ^ "Laden Sie die Testversion herunter: Microsoft SQL Server 2014" (in German). Microsoft. Retrieved November 5, 2014.
  58. ^ "SQL Server 2014 Service Pack 1 release information". Microsoft.com. Microsoft, Inc. Retrieved May 17, 2015.
  59. ^ a b "Requirements for Installing SQL Server 2016". msdn.microsoft.com. May 2, 2016. Retrieved July 28, 2016.
  60. ^ "SQL Server 2014 Support Lifecycle". Microsoft Product Lifecycle.
  61. ^ {{cite web|url=https://cloudblogs.microsoft.com/sqlserver/2023/09/28/protect-sql-server-2014-workloads-with-azure-flexibility%7Ctitle=Protect SQL Server 2014 workloads with Azure flexibility|first=Debbi|last=Lyons|date=September 28, 2023|archivedate=October 5, 2023|archiveurl= SQL Server Blog}|url-status=live}
  62. ^ 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.
  63. ^ "SQL Server 2017 on Windows Linux and Docker is now generally available". October 2, 2017.
  64. ^ "What's new in SQL Server 2019 (15.x)". March 16, 2023.
  65. ^ 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.
  66. ^ Kumar, Rohan (November 16, 2022). "SQL Server 2022 is now generally available". Microsoft SQL Server Blog. Retrieved July 5, 2023.
  67. ^ "Deploy Azure SQL Edge using the Azure portal". January 15, 2023.

history, microsoft, server, history, microsoft, server, begins, with, first, microsoft, server, database, product, server, relational, database, operating, system, released, 1989, contents, versions, detailed, history, genesis, server, server, 2000, server, 20. The 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 Contents 1 Versions 2 Detailed history 2 1 Genesis 2 2 SQL Server 7 0 2 3 SQL Server 2000 2 4 SQL Server 2005 2 5 SQL Server 2008 2 6 SQL Server 2008 R2 2 7 SQL Server 2012 2 8 SQL Server 2014 2 9 SQL Server 2016 2 10 SQL Server 2017 2 11 SQL Server 2019 2 12 SQL Server 2022 3 Processor support 4 ReferencesVersions editVersion ReleaseDate MainstreamEnd Date ExtendedEnd Date Release name Code name Internaldatabase version1 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 4 21a SQLNT 6 0 1995 SQL Server 6 0 SQL95 4066 5 1996 SQL Server 6 5 Hydra 4087 0 1998 Old version no longer maintained December 31 2005 Old version no longer maintained January 11 2011 SQL Server 7 0 Sphinx 515 1999 SQL Server 7 0 OLAP Tools Plato 8 0 2000 Old version no longer maintained April 8 2008 Old version no longer maintained April 9 2013 SQL Server 2000 Shiloh 5398 0 2003 SQL Server 2000 64 bit Edition Liberty 5399 0 January 14 2006 Old version no longer maintained April 12 2011 Old version no longer maintained April 12 2016 SQL Server 2005 Yukon 611 61210 0 November 6 2008 Old version no longer maintained July 8 2014 Old version no longer maintained July 9 2019 SQL Server 2008 Katmai 65510 25 2010 Azure SQL database initial release Cloud database or CloudDB 10 50 July 20 2010 Old version no longer maintained July 8 2014 Old version no longer maintained July 9 2019 SQL Server 2008 R2 Kilimanjaro aka KJ 66111 0 May 20 2012 Old version no longer maintained July 11 2017 Old version no longer maintained July 12 2022 SQL Server 2012 Denali 70612 0 2014 Azure SQL database 12 0 June 5 2014 Old version no longer maintained July 9 2019 Older version yet still maintained July 9 2024 SQL Server 2014 Hekaton 78213 0 June 1 2016 Old version no longer maintained July 13 2021 Older version yet still maintained July 14 2026 SQL Server 2016 SQL16 85214 0 September 29 2017 Old version no longer maintained October 11 2022 Older version yet still maintained October 12 2027 SQL Server 2017 Helsinki 86915 0 November 4 2019 Older version yet still maintained January 14 2025 Older version yet still maintained January 8 2030 SQL Server 2019 Seattle 89516 0 November 16 2022 Current stable version January 11 2028 Current stable version January 11 2033 SQL Server 2022 Dallas 957Legend Old version Older version still maintained Latest versionDetailed history editGenesis edit On June 12 1988 Microsoft joined Ashton Tate and Sybase to create a variant of Sybase SQL Server for IBM OS 2 then developed jointly with Microsoft which was released the following year 1 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 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 nbsp SQL Server 7 0 Splash ScreenSQL 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 2 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 3 By SQL Server 2005 the legacy Sybase code had been completely rewritten 4 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 ServicesSQL 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 5 6 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 ws released in November 2005 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 protocol requests When the data is accessed over web services results are returned as XML 7 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 8 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 SQL Server 2005 introduced MARS Multiple Active Results Sets a method of allowing usage of database connections for multiple purposes 9 SQL Server 2005 introduced DMVs Dynamic Management Views which are 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 10 SQL Server 2005 was the first version with native support for the x64 platform 11 Service Pack 1 SP1 of SQL Server 2005 introduced Database Mirroring a high availability option that provides redundancy and failover capabilities at the database level 12 Failover can be performed manually or can be configured for automatic failover Automatic failover requires a witness partner and an operating mode of synchronous also known as high safety or full safety 13 Database Mirroring was included in the first release of SQL Server 2005 for evaluation purposes only Prior to SP1 it was not enabled by default and was not supported by Microsoft citation needed Service Pack 1 was released on April 18 2006 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 14 15 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 15 Other new data types include specialized date and time types and a Spatial data type for location dependent data 16 Better support for unstructured and semi structured data is provided using the new FILESTREAM 17 data type which can be used to reference any file stored on the file system 18 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 19 SQL Server 2008 also natively supports hierarchical data and includes T SQL constructs to directly deal with them without using recursive queries 19 The full text search functionality has been integrated with the database engine According to a Microsoft technical article this simplifies management and improves performance 20 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 21 SQL Server includes better compression features which also helps in improving scalability 22 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 17 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 23 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 24 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 16 The version of SQL Server Management Studio included with SQL Server 2008 supports IntelliSense for SQL queries against a SQL Server 2008 Database Engine 25 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 26 The final SQL Server 2008 service pack 10 00 6000 Service Pack 4 was released on September 30 2014 27 SQL Server 2008 had mainstream support until July 8 2014 and extended support until July 9 2019 28 Volume licensed Standard Web Enterprise Workgroup and Datacenter editions of SQL Server 2008 are eligible for the Extended Security Updates program 29 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 30 31 Those volume licensed editions rehosted on Microsoft Azure automatically received ESUs until July 11 2023 32 33 34 35 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 36 SQL Server 2008 R2 adds certain features to SQL Server 2008 including a master data management system branded as Master Data Services a central management of master data entities and hierarchies Also Multi Server Management a centralized console to manage multiple SQL Server 2008 instances and services including relational databases Reporting Services Analysis Services amp Integration Services 37 SQL Server 2008 R2 includes a number of new services 38 including PowerPivot for Excel and SharePoint Master Data Services StreamInsight Report Builder 3 0 Reporting Services Add in for SharePoint a Data tier function in Visual Studio that enables packaging of tiered databases as part of an application and a SQL Server Utility named UC Utility Control Point part of AMSM Application and Multi Server Management that is used to manage multiple SQL Servers 39 The first SQL Server 2008 R2 service pack 10 50 2500 Service Pack 1 was released on July 11 2011 40 The second SQL Server 2008 R2 service pack 10 50 4000 Service Pack 2 was released on July 26 2012 41 The final SQL Server 2008 R2 service pack 10 50 6000 Service Pack 3 was released on September 26 2014 42 SQL 2008 R2 would be the last version of SQL Server to run on the Itanium IA 64 platform However the x64 platform would continue on in force Extended support for SQL Server on Itanium would continue until 2018 43 SQL Server 2008 R2 had mainstream support until July 8 2014 and extended support until July 9 2019 44 Volume licensed Standard Enterprise Datacenter and Embedded editions of SQL Server 2008 R2 are eligible for the Extended Security Updates program 29 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 30 31 Those volume licensed editions rehosted on Microsoft Azure automatically received ESUs until July 11 2023 32 SQL Server 2012 edit At the 2011 Professional Association for SQL Server PASS summit on October 11 Microsoft announced that the next major version of SQL Server codenamed Denali would be SQL Server 2012 It was released to manufacturing on March 6 2012 45 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 46 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 47 Contained Databases which simplify the moving of databases between instances new and modified Dynamic Management Views and Functions 48 programmability enhancements including new spatial features 49 metadata discovery sequence objects and the THROW statement 50 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 51 52 SQL Server 2012 had mainstream support until July 11 2017 and extended support until July 12 2022 53 32 All volume licensed editions of SQL Server 2012 are eligible for the Extended Security Updates program 29 The first term of yearly installment ended on July 11 2023 the second term will end on July 9 2024 and the third and final term will end on July 8 2025 33 31 Those volume licensed editions rehosted on Microsoft Azure automatically receive ESUs until July 8 2025 35 34 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 54 Until November 2013 there were two CTP revisions CTP1 and CTP2 55 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 56 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 57 SQL Server 2014 SP1 consisting primarily of bugfixes was released on May 15 2015 58 SQL Server 2014 is the last version available on x86 IA32 architecture 59 On windows Server 2008 R2 it is the last installable 1 SQL Server 2014 had mainstream support until July 9 2019 and extended support until July 9 2024 60 All volume licensed editions of SQL Server 2014 are eligible for the Extended Security Updates program 29 61 The first term of yearly installment will end 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 31 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 was June 1 2016 The RTM version is 13 0 1601 5 Service pack 2 updates the version to 13 2 5026 Service Pack 1 was released on November 16 2016 Service Pack 2 was released on April 24 2018 and Service Pack 3 was released on September 15 2021 SQL Server 2016 is supported on x64 processors only It is no longer supported on x86 processors 59 SQL Server 2016 is the last version to have Service Packs launched SQL Server 2017 edit Microsoft launched SQL Server 2017 on October 2 2017 along with support for Linux 62 63 On windows Server 2012 and 2012 R2 it is the last installable 2 SQL Server 2019 edit Microsoft launched SQL Server 2019 on November 4 2019 SQL Server 2019 15 x 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 64 SQL Server 2022 edit Microsoft launched SQL Server 2022 on November 16 2022 65 unreliable source However customers purchasing via OEM and Services Provider License Agreement SPLA had to purchase SQL Server 2022 starting January 2023 66 Processor support editProcessor support for SQL Server Version x286 x386 x64 DEC Alpha MIPS PowerPC Itanium ARM SH4SQL 1 0 Yes Yes No No No No No No NoSQL 1 1 Yes Yes No No No No No No NoSQL 4 2 Yes Yes No No No No No No NoSQL 4 21 No Yes No Yes Yes No No No NoSQL 6 0 No Yes No Yes Yes No No No NoSQL 6 5 No Yes No Yes Yes Ends after SP2 No No NoSQL 7 0 No Yes No Yes No No No No NoSQL 2000 No Yes No Pre release only No No Starts at SP3 No NoSQL 2000 CE No Yes Yes No Yes No No Yes YesSQL 2005 No Yes Yes No No No Yes No NoSQL 2005 CE No Yes Yes No Yes No No Yes YesSQL 2008 No Yes Yes No No No Yes No NoSQL 2008 R2 No Yes Yes No No No Yes No NoSQL 2012 No Yes Yes No No No No No NoSQL 2014 No Yes Yes No No No No No NoSQL 2016 17 No No Yes No No No No No NoSQL 2019 No No Yes No No No No Yes Edge 67 NoReferences edit Harris Scott Curtis Preston 2007 Backup amp Recovery Inexpensive Backup Solutions for Open Systems O Reilly p 562 ISBN 978 0596102463 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 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 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 Don Jones 2005 The Definitive Guide to Scaling Out SQL Server 2005 Edition realtimepublishers com ISBN 9781931491532 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 SQL Server Team TechEd 2009 New SQL Server Innovations MSDN Blogs Retrieved May 12 2009 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 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 SQL Server 2014 Support Lifecycle Microsoft Product Lifecycle cite web url https cloudblogs microsoft com sqlserver 2023 09 28 protect sql server 2014 workloads with azure flexibility 7Ctitle Protect SQL Server 2014 workloads with Azure flexibility first Debbi last Lyons date September 28 2023 archivedate October 5 2023 archiveurl https web archive org web 20231005210526 https cloudblogs microsoft com sqlserver 2023 09 28 protect sql server 2014 workloads with azure flexibility 7Cwebsite Microsoft SQL Server Blog url status live 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 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 Retrieved from https en wikipedia org w index php title History of Microsoft SQL Server amp oldid 1179583705 SQL Server 2014, wikipedia, wiki, book, books, library,

article

, read, download, free, free download, mp3, video, mp4, 3gp, jpg, jpeg, gif, png, picture, music, song, movie, book, game, games.