History of Microsoft SQL Server: Difference between revisions

Revision as of 13:31, 13 September 2023

Revision as of 02:42, 11 October 2023

Line 255:

The final SQL Server 2008 service pack (10.00.6000, Service Pack 4) was released on September 30, 2014.<ref name="Service Pack 4">{{cite web|url=http://blogs.msdn.com/b/sqlreleaseservices/archive/2014/09/30/sql-server-2008-service-pack-4-has-released.aspx|website=SQL Release Services Blog|title=SQL Server 2008 Service Pack 4 has released|accessdate=October 1, 2014}}</ref>

SQL Server 2008 had mainstream support until July 8, 2014, and extended support until July 9, 2019.<ref>{{cite web|title=SQL Server 2008 Support Lifecycle|url=https://learn.microsoft.com/en-us/lifecycle/products/microsoft-sql-server-2008|website=Microsoft Product Lifecycle}}</ref> [[volume licensing|Volume licensed]] Standard, Web, Enterprise, Workgroup and Datacenter editions of SQL Server 2008 are eligible for the Extended Security Updates program.<ref name=ESU4SQL(Doc)>{{cite web|title=What are Extended Security Updates for SQL Server?|url=https://learn.microsoft.com/en-us/sql/sql-server/end-of-support/sql-server-extended-security-updates|website=Microsoft Documentation|date=July 13, 2023 }}</ref> 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.<ref name=SQL2008ESU(Blog)>{{cite web|title=Announcing new options for SQL Server 2008 and Windows Server 2008 End of Support|first=Takeshi|last=Numoto|url=https://azure.microsoft.com/en-us/blog/announcing-new-options-for-sql-server-2008-and-windows-server-2008-end-of-support|archiveurl=https://web.archive.org/web/20181030193930/https://azure.microsoft.com/en-us/blog/announcing-new-options-for-sql-server-2008-and-windows-server-2008-end-of-support|date=July 12, 2018|archivedate=October 30, 2018|url-status=live}}</ref><ref name=Products_with_ESU>{{cite web|title=Lifecycle FAQ - Extended Security Updates|url=https://learn.microsoft.com/en-us/lifecycle/faq/extended-security-updates|website=Microsoft Documentation}}</ref> Those volume licensed editions rehosted on [[Microsoft Azure]] automatically received ESUs until July 11, 2023.<ref name=SQL2012ESU(Reminder)>{{cite web|title=SQL Server 2012 and Windows Server 2012/2012 R2 end of support|url=https://learn.microsoft.com/en-us/lifecycle/announcements/sql-server-2012-windows-server-2012-2012-r2-end-of-support|archiveurl=https://web.archive.org/web/20220703155353/https://20220703155353/docs.microsoft.com/en-us/lifecycle/announcements/sql-server-2012-windows-server-2012-2012-r2-end-of-support|date=June 29, 2022|archivedate=July 3, 2022|url-status=live}}</ref><ref name=SQL2012ESU(Blog)>{{cite web|title=Know your options for SQL Server 2012 and Windows Server 2012 End of Support|first1=Debbi|last1=Lyons|first2=Vijay|last2=Kumar|url=https://cloudblogs.microsoft.com/sqlserver/2021/07/14/know-your-options-for-sql-server-2012-and-windows-server-2012-end-of-support|archiveurl=https://web.archive.org/web/20210714150745/https://cloudblogs.microsoft.com/sqlserver/2021/07/14/know-your-options-for-sql-server-2012-and-windows-server-2012-end-of-support|date=July 14, 2021|archivedate=July 14, 2021|url-status=live}}</ref><ref name=SQL2012ESU(Blog2)>{{cite web|title=Move end-of-support SQL Server 2012 to Azure Virtual Machines and save|first=Logan|last=Carrington|url=https://cloudblogs.microsoft.com/sqlserver/2022/03/24/move-end-of-support-sql-server-2012-to-azure-virtual-machines-and-save|date=March 24, 2022|archiveurl=https://web.archive.org/web/20220325031012/https://cloudblogs.microsoft.com/sqlserver/2022/03/24/move-end-of-support-sql-server-2012-to-azure-virtual-machines-and-save|archivedate=March 25, 2022|url-status=live}}</ref><ref name=SQL2012ESU(Blog3)>{{cite web|title= SQL Server 2012 reaches end of support and Microsoft is here to help|first=Jessica|last=Hawk|url=https://cloudblogs.microsoft.com/sqlserver/2022/07/12/sql-server-2012-reaches-end-of-support-and-microsoft-is-here-to-help|date=July 12, 2022|archiveurl=https://web.archive.org/web/20220712160411/https://cloudblogs.microsoft.com/sqlserver/2022/07/12/sql-server-2012-reaches-end-of-support-and-microsoft-is-here-to-help|archivedate=July 12, 2022|url-status=live}}</ref>

===SQL Server 2008 R2===

Line 267:

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. <ref>{{cite web|url=https://rcpmag.com/articles/2010/04/05/microsoft-dropping-itanium-support.aspx|title=Microsoft Dropping Itanium Support -}}</ref>

SQL Server 2008 R2 had mainstream support until July 8, 2014, and extended support until July 9, 2019.<ref>{{cite web|title=SQL Server 2008 R2 Support Lifecycle|url=https://learn.microsoft.com/en-us/lifecycle/products/microsoft-sql-server-2008-r2|website=Microsoft Product Lifecycle}}</ref> [[volume licensing|Volume licensed]] Standard, Enterprise, Datacenter and Embedded editions of SQL Server 2008 R2 are eligible for the Extended Security Updates program.<ref name=ESU4SQL(Doc)/> 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.<ref name=SQL2008ESU(Blog)/><ref name=Products_with_ESU/> Those volume licensed editions rehosted on [[Microsoft Azure]] automatically received ESUs until July 11, 2023.<ref name=SQL2012ESU(Reminder)/>

===SQL Server 2012===

Line 276:

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,<ref name="Availability Enhancements">{{cite web|url=http://msdn.microsoft.com/en-us/library/cc645581(v=sql.110).aspx|title=Availability Enhancements (Database Engine)|date=May 24, 2013 |publisher=Msdn.microsoft.com|accessdate=June 15, 2013}}</ref> Contained Databases which simplify the moving of databases between instances, new and modified Dynamic Management Views and Functions,<ref name="Manageability Enhancements">{{cite web|url=http://msdn.microsoft.com/en-us/library/cc645579(v=sql.110).aspx|title=Manageability Enhancements (Database Engine)|publisher=Msdn.microsoft.com|date=July 13, 2011|accessdate=June 15, 2013}}</ref> programmability enhancements including new spatial features,<ref name="Aitchison2012">{{cite book|author=Alastair Aitchison|title=Pro Spatial with SQL Server 2012|url=https://books.google.com/books?id=NdvJXu7hT8oC&pg=PA21|year=2012|publisher=Apress|isbn=978-1-4302-3491-3|pages=21–23}}</ref> metadata discovery, sequence objects and the THROW statement,<ref name="Programmability Enhancements">{{cite web|url=http://msdn.microsoft.com/en-us/library/cc645577(v=sql.110).aspx|title=Programmability Enhancements (Database Engine)|date=April 2012 |publisher=Msdn.microsoft.com|accessdate=June 15, 2013}}</ref> 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.<ref name="Scalability and Performance Enhancements">{{cite web|url=http://msdn.microsoft.com/en-us/library/cc645580(v=sql.110).aspx|title=Scalability and Performance Enhancements (Database Engine)|date=April 2012 |publisher=Msdn.microsoft.com|accessdate=June 15, 2013}}</ref><ref name="Security Enhancements">{{cite web|url=http://msdn.microsoft.com/en-us/library/cc645578(v=sql.110).aspx|title=Security Enhancements (Database Engine)|publisher=Msdn.microsoft.com|accessdate=June 15, 2013}}</ref>

SQL Server 2012 had mainstream support until July 11, 2017, and extended support until July 12, 2022.<ref>{{cite web|title=SQL Server 2012 Support Lifecycle|url=https://learn.microsoft.com/en-us/lifecycle/products/microsoft-sql-server-2012|website=Microsoft Product Lifecycle}}</ref><ref name=SQL2012ESU(Reminder)/> All volume licensed editions of SQL Server 2012 are eligible for the Extended Security Updates program.<ref name=ESU4SQL(Doc)/> 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.<ref name=SQL2012ESU(Blog)/><ref name=Products_with_ESU/> Those volume licensed editions rehosted on [[Microsoft Azure]] automatically receive ESUs until July 8, 2025.<ref name=SQL2012ESU(Blog3)/><ref name=SQL2012ESU(Blog2)/>

===SQL Server 2014===

Line 292:

On [[windows Server 2008 R2]], it is the last installable.[https://kb360.esilaw.com/knowledge-base/hardware-and-software-requirements-for-installing-sql-server-2014/]

SQL Server 2014 had mainstream support until July 9, 2019, and extended support until July 9, 2024.<ref>{{cite web|title=SQL Server 2014 Support Lifecycle|url=https://learn.microsoft.com/lifecycle/products/sql-server-2014|website=Microsoft Product Lifecycle}}</ref> All volume licensed editions of SQL Server 2014 are eligible for the Extended Security Updates program.<ref name=ESU4SQL(Doc)/><ref>{{cite web|url=https://cloudblogs.microsoft.com/sqlserver/2023/09/28/protect-sql-server-2014-workloads-with-azure-flexibility|title=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|website=Microsoft SQL Server Blog}|url-status=live}</ref> 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.<ref name=Products_with_ESU/> Those volume licensed editions rehosted on [[Microsoft Azure]] automatically receive ESUs until July 12, 2027.

===SQL Server 2016===