Content deleted Content added
m Grammar fix |
No edit summary |
||
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}}</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
===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
===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)|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)|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)|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
===SQL Server 2014===
Line 291:
SQL Server 2014 is the last version available on x86/IA32 architecture.<ref name="2016 Requirements"/>
On
===SQL Server 2016===
The official General Availability (GA) release date for SQL Server 2016 was June 1, 2016. The [[Release to manufacturing|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.<ref name="2016 Requirements">{{cite web|title=Requirements for Installing SQL Server 2016|url=https://msdn.microsoft.com/en-us/library/ms143506(v=sql.130).aspx|publisher=msdn.microsoft.com|date=May 2, 2016|accessdate=July 28, 2016}}</ref>
SQL Server 2016 is the last version to have Service Packs launched.
===SQL Server 2017===
Microsoft launched SQL Server 2017 on October 2, 2017, along with support for [[Linux]].<ref>{{cite web|url=https://techcrunch.com/2017/07/17/how-microsoft-brought-sql-server-to-linux|title=How Microsoft brought SQL Server to Linux|last=Lardinois|first=Frederic|date=July 17, 2017|website=TechCrunch|publisher=Oath Inc.|accessdate=September 5, 2017|quote=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.}}</ref><ref>{{Cite web|url=https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/02/sql-server-2017-on-windows-linux-and-docker-is-now-generally-available/|title=SQL Server 2017 on Windows Linux and Docker is now generally available|date=October 2, 2017}}</ref>
On
===SQL Server 2019===
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.<ref>{{cite web|title=What's new in SQL Server 2019 (15.x)|url=https://docs.microsoft.com/en-us/sql/sql-server/what-s-new-in-sql-server-ver15?view=sql-server-ver15}}</ref>
===
Microsoft launched SQL Server 2022 on November 16, 2022.<ref>{{
==Processor support==
Line 534 ⟶ 514:
==References==
{{reflist
[[Category:Client-server database management systems]]
| |||