History of Microsoft SQL Server: Difference between revisions

Revision as of 21:30, 14 January 2023

Revision as of 22:11, 14 January 2023

Line 252:

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=2014-10-01}}</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}}</ref> The first term of yearly installment ended on 14 July, 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 receive ESUs until 11 July, 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|first=Debbi|last=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===

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.<ref name="SQL Server 2008 R2">{{cite web|url=http://blogs.technet.com/sqlserverexperts/archive/2010/04/21/sql-server-2008-r2-launches.aspx|title=SQL Server 2008 R2 Launches!|accessdate=2010-04-21}}</ref> SQL Server 2008 R2 adds certain features to SQL Server 2008 including a [[master data management]] system branded as [[Microsoft SQL Server Master Data Services|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.<ref name="Innovations">{{cite web|url=http://blogs.technet.com/dataplatforminsider/archive/2009/05/11/teched-2009-new-sql-server-innovations.aspx|publisher=MSDN Blogs|author=SQL Server Team|accessdate=2009-05-12|title=TechEd 2009&nbsp;– New SQL Server Innovations}}</ref>

Line 264:

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 14 July, 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 receive ESUs until 11 July, 2023.<ref name=SQL2012ESU(Reminder)/>

===SQL Server 2012===

Line 273:

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)|publisher=Msdn.microsoft.com|accessdate=2013-06-15}}</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=2011-07-13|accessdate=2013-06-15}}</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)|publisher=Msdn.microsoft.com|accessdate=2013-06-15}}</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)|publisher=Msdn.microsoft.com|accessdate=2013-06-15}}</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=2013-06-15}}</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 will end on 11 July, 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===