请输入您要查询的百科知识：

　

词条 History of Microsoft SQL Server
释义

  1. Release summary

  2. Detailed history

     Genesis  SQL Server 7.0  SQL Server 2000   SQL Server 2005    SQL Server 2008    SQL Server 2008 R2    SQL Server 2012    SQL Server 2014    SQL Server 2016    SQL Server 2017  

  3. Processor Support

  4. References

  5. External links

The history of Microsoft SQL Server begins with the first Microsoft SQL Server product - SQL Server 1.0, a 16-bit server for the OS/2 operating system in 1989 - and extends to the current day.

Release summary

SQL Server release history
Version Year Release name Code name Internal database version
o|1.0}} (OS/2) 1989 SQL Server 1.0 (16-bit) Filipi -
o|1.1}} (OS/2) 1991 SQL Server 1.1 (16-bit) Pietro -
o|4.2A}} (OS/2) 1992 SQL Server 4.2A (16-bit) - -
o|4.2B}} (OS/2) 1993 SQL Server 4.2B (16-bit) - -
o|4.21a}} (WinNT) 1993 SQL Server 4.21a SQLNT -
o|6.0}} 1995 SQL Server 6.0 SQL95 -
o|6.5}} 1996 SQL Server 6.5 Hydra 408
o|7.0}} 1998 SQL Server 7.0 Sphinx 515
o|-}} 1999 SQL Server 7.0 OLAP Tools Palato mania -
o|8.0}} 2000 SQL Server 2000 Shiloh 539
o|8.0}} 2003 SQL Server 2000 64-bit Edition Liberty 539
o|9.0}} 2005 SQL Server 2005 Yukon 611/612
co|10.0}} 2008 SQL Server 2008 Katmai 655
o|10.25}} 2010 Azure SQL database (initial release) Cloud database or CloudDB
co|10.50}} 2010 SQL Server 2008 R2 Kilimanjaro (aka KJ) 661
co|11.0}} 2012 SQL Server 2012 Denali 706
co|12.0}} 2014 SQL Server 2014 Hekaton 782
co|13.0}} 2016 SQL Server 2016 - 852
c|14.0}} 2017SQL Server 2017 vNext 869
c|Not yet released}} 2019SQL Server 2019 CTP Aris 895
{{Version |l |show=011110}}
{{clear}}

Detailed history

Genesis

On June 12th 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, 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

SQL Server 7.0 was a major rewrite (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.

SQL Server 2000

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 (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.[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 Enterprise Manager, would still need to be run from 32-bit x86 clients. The first release of SQL IA-64 was version 8.00.760, with a build date of February 6, 2003.

SQL Server 2005

SQL Server 2005 (formerly codenamed "Yukon") 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 is converted to an internal binary data type before being stored in the database. Specialized indexing methods were made available for XML data. 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|date=June 2015}}

Extended support for SQL Server 2005 ended on April 12, 2016.

SQL Server 2008

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 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.[28] 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.[29]

SQL Server 2008 R2 includes a number of new services,[30] including PowerPivot for Excel and SharePoint, Master Data Services, StreamInsight, Report Builder 3.0, [https://technet.microsoft.com/en-us/sqlserver/ff660783.aspx 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.[31]

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

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

SQL Server 2012

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.[36] SQL Server 2012 Service Pack 1 was released to manufacturing on November 9, 2012, and Service Pack 2 was released to manufacturing on June 10, 2014.

It was announced to be the last version to natively support OLE DB and instead to prefer ODBC for native connectivity.[37]

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,[38] Contained Databases which simplify the moving of databases between instances, new and modified Dynamic Management Views and Functions,[39] programmability enhancements including new spatial features,[40] metadata discovery, sequence objects and the THROW statement,[41] 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.[42][43]

SQL Server 2014

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.[44] Until November 2013 there were two CTP revisions, CTP1 and CTP2.[45] 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.[46]

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

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

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

SQL Server 2016

The official General Availability (GA) release date for SQL Server 2016 was June 1, 2016.

The RTM version is 13.0.1601.5.

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

SQL Server 2017

Microsoft SQL Server 2017 is the most recent version available. Microsoft launched SQL Server 2017 on October 2nd, 2017 along with support for Linux.[50][51]

Processor Support

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+{{no}}{{no}}{{yes}}{{no}}{{no}}{{no}}{{no}}{{no}}{{no}}

References

1. ^{{cite book|last=Harris|first=Scott|author2=Curtis Preston |title=Backup & Recovery: Inexpensive Backup Solutions for Open Systems|url=https://books.google.co.uk/books?id=M9mbAgAAQBAJ&lpg=PA562&dq=origins%20of%20SQL%20Server%20Sybase&pg=PA562#v=onepage&q=origins%20of%20SQL%20Server%20Sybase&f=false|year=2007|publisher=O'Reilly|isbn=0596102461|page=562}}
2. ^https://technet.microsoft.com/en-us/library/aa175393%28v=sql.80%29.aspx
3. ^http://www.computerworld.com/article/2516742/computer-hardware/microsoft-ending-support-for-itanium.html
4. ^{{cite web |url=http://www.scriptcase.net/blog/all-about-the-history-of-sql-server/ |title=All about the History of SQL Server |website=Scriptcase.net. |date=August 14, 2013 |accessdate=2016-08-15}}
5. ^http://www.informit.com/articles/article.aspx?p=25735
6. ^http://sqlmag.com/t-sql/sql-server-2000s-coolest-features
7. ^{{ cite web | url = http://msdn.microsoft.com/en-us/library/ms170809.aspx | title = Database Engine XML Enhancements | accessdate = 2007-12-03 }}
8. ^{{ cite web | url = http://msdn.microsoft.com/en-us/library/ms170910.aspx | title = Database Engine Enhancements | accessdate = 2007-12-03 }}
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. ^{{cite book|url=https://books.google.com/books?id=MhkaNTEGCdgC&pg=PA218&lpg=PA218#v=onepage&q&f=false|title=The Definitive Guide to Scaling Out SQL Server 2005 Edition|author=Don Jones|publisher=realtimepublishers.com}}
12. ^{{ cite web | url = http://support.microsoft.com/kb/907741 | title = Issues to consider when you use the database mirroring feature in the initial release of SQL Server 2005 | publisher = Support.microsoft.com | date = 2007-11-20 | accessdate = 2011-09-04 }}
13. ^{{ cite web | url = http://msdn.microsoft.com/en-us/library/ms189590.aspx | title = Automatic Failover | publisher = Msdn.microsoft.com | accessdate = 2011-09-04 }}
14. ^{{ cite web | url = http://www.microsoft.com/sql/prodinfo/futureversion/default.mspx | title = Microsoft SQL Server 2008 | accessdate = 2007-04-06 }}
15. ^1 {{ cite web|title=ChannelWeb: Next SQL Server stop: Katmai |url=http://www.crn.com/storage/170702999 |accessdate=2005-11-05 |deadurl=yes |archiveurl=https://web.archive.org/web/20070322212538/http://www.crn.com/storage/170702999 |archivedate=2007-03-22 |df= }}
16. ^1 {{ cite web | url = http://www.informationweek.com/software/showArticle.jhtml?articleID=199500164&subSection=Development | title = Microsoft Gives Peek At Next Version Of SQL Server | accessdate = 2007-05-11 }}
17. ^1 {{ cite web | url = http://blogs.zdnet.com/microsoft/?p=937 | title = One more test build to go for SQL Server 2008 | accessdate = 2006-11-13 }}
18. ^{{ cite web | url = http://blogs.msdn.com/stevengu/archive/2007/11/13/guest-blogger-ted-kummert.aspx | title = Guest Blogger: Ted Kummert | accessdate = 2007-11-20 }}
19. ^1 {{ cite web | url = http://channel9.msdn.com/Showpost.aspx?postid=387069 | title = SQL Server 2008 for developers | author = Christian Kleinerman | publisher = Channel 9 | accessdate = 2008-03-07 }}
20. ^{{ cite web | url = http://msdn.microsoft.com/en-us/library/cc721269.aspx | title = SQL Server 2008 Full-Text Search: Internals and Enhancements | author = Fernando Azpeitia Lopez }}
21. ^{{ cite web|url=http://www.directionsmag.com/editorials.php?article_id=2477&trv=1 |title=Microsoft Shares Details on SQL Server 2008 Spatial Support by Directions Staff |accessdate=2007-09-07 |archiveurl=https://web.archive.org/web/20070808001216/http://www.directionsmag.com/editorials.php?article_id=2477&trv=1 |archivedate=2007-08-08 |deadurl=yes |df= }}
22. ^{{ cite web | url = https://technet.microsoft.com/en-us/library/cc721270%28SQL.100%29.aspx | title = Features of SQL 2008 | publisher = Technet.microsoft.com | date = 2009-02-12 | accessdate = 2011-09-04 }}
23. ^{{ cite web | url = http://oakleafblog.blogspot.com/2007/05/sql-server-to-deliver-entity-data.html | title = SQL Server "Katmai" to Deliver Entity Data Platform and Support LINQ | accessdate = 2007-05-12 }}
24. ^{{ cite web | url = http://www.earthtimes.org/articles/show/news_press_release,115898.shtml | title = Microsoft Details Dynamic IT Strategy at Tech-Ed 2007 | accessdate = 2007-06-04 }}
25. ^{{ cite web | url = http://msdn.microsoft.com/en-us/library/ms173434.aspx | title = SQL Server IntelliSense | accessdate = 2008-08-18 }}
26. ^{{ cite web | url = http://blogs.msdn.com/powershell/archive/2007/11/13/sql-server-support-for-powershell.aspx | title = SQL Server Support for PowerShell! | accessdate = 2007-12-03 }}
27. ^{{ 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 }}
28. ^{{ 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 }}
29. ^{{ 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 – New SQL Server Innovations}}
30. ^{{ cite web | url = http://www.networkworld.com/reviews/2010/050310-microsoft-sql-server-2008-test.html?ap1=rcb | title = Review: Microsoft SQL Server 2008 R2 | publisher = Networkworld.com | date = 2010-05-03 | accessdate = 2013-06-15 }}
31. ^{{ cite web | url = http://msdn.microsoft.com/en-us/library/ee364757%28SQL.100%29.aspx | title = SQL SQL Server 2008 R2 Application and Multi-Server Management | accessdate = 2010-06-06 }}
32. ^{{ cite web | url = http://www.microsoft.com/download/en/details.aspx?id=26727 | title = Microsoft® SQL Server® 2008 R2 SP1 | accessdate = 2011-09-19 }}
33. ^{{ cite web | url = http://www.microsoft.com/en-us/download/details.aspx?id=30437 | title = Microsoft® SQL Server® 2008 R2 SP2 | accessdate = 2012-07-31 }}
34. ^{{ cite web | url = http://blogs.msdn.com/b/sqlreleaseservices/archive/2014/09/26/sql-server-2008-r2-service-pack-3-has-released.aspx | website = SQL Release Services Blog | title = SQL Server 2008 R2 Service Pack 3 has released | accessdate = 2014-10-01 }}
35. ^https://rcpmag.com/articles/2010/04/05/microsoft-dropping-itanium-support.aspx
36. ^{{ cite web | title = Microsoft Releases SQL Server 2012 to Help Customers Manage "Any Data, Any Size, Anywhere" | url = http://www.microsoft.com/Presspass/press/2012/mar12/03-06SQLServer12PR.mspx | work = Microsoft News Center | publisher = Microsoft | accessdate = March 7, 2012 | date = March 6, 2012 }}
37. ^{{ cite web | title = Microsoft is Aligning with ODBC for Native Relational Data Access — FAQ | url = http://social.technet.microsoft.com/Forums/en/sqldataaccess/thread/e696d0ac-f8e2-4b19-8a08-7a357d3d780f | work = SQL Server Forums | publisher = Microsoft Corporation | accessdate = March 7, 2012 | last = Lam | first = Rohan }}
38. ^{{ 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 }}
39. ^{{ 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 }}
40. ^{{ 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 }}
41. ^{{ 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 }}
42. ^{{ 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 }}
43. ^{{ 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 }}
44. ^http://www.faceofit.com/list-of-sql-server-versions-build-numbers-and-service-packs
45. ^{{cite web |url=http://blogs.msdn.com/b/data__knowledge__intelligence/archive/2013/10/17/sql-server-2014-ctp2-is-now-available.aspx |title=SQL Server 2014 – CTP2 is now available |first=Deepthi |last=Anantharam |work=MSDN blogs |date=October 16, 2013 |accessdate=2016-08-15}}
46. ^SQL Server 2012-2014-Explore. Server Cloud. Microsoft.com (2013-04-17). Retrieved on 2014-03-23
47. ^{{ cite web | url = https://technet.microsoft.com/de-DE/evalcenter/dn205290.aspx | title = Laden Sie die Testversion herunter: Microsoft SQL Server 2014 | language = German | publisher = Microsoft | accessdate = 2014-11-05 }}
48. ^{{ cite web | title = SQL Server 2014 Service Pack 1 release information | url = https://support.microsoft.com/en-us/kb/3058865 | website = Microsoft.com | publisher = Microsoft, Inc. | accessdate = 17 May 2015 }}
49. ^1 {{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= 2016-05-02|accessdate= 2016-07-28}}
50. ^{{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= 2017-07-17 |website= TechCrunch |publisher= Oath Inc. |access-date= 2017-09-05 |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. }}
51. ^https://blogs.technet.microsoft.com/dataplatforminsider/2017/10/02/sql-server-2017-on-windows-linux-and-docker-is-now-generally-available/

External links

  • [https://sqlserverbuilds.blogspot.com Microsoft SQL Server Version List]

7 : Client-server database management systems|Database management systems|History of Microsoft|History of software|Microsoft database software|Relational database management systems|Windows Server System
随便看

　

开放百科全书收录14589846条英语、德语、日语等多语种百科知识，基本涵盖了大多数领域的百科知识，是一部内容自由、开放的电子版国际百科全书。

　

Copyright © 2023 OENC.NET All Rights Reserved
京ICP备2021023879号 更新时间：2024/11/14 13:22:11