History of Microsoft SQL Server: Difference between revisions

Revision as of 16:07, 1 February 2022

Revision as of 01:08, 15 February 2022

Line 232:

=== SQL Server 2008 ===

SQL Server 2008 (formerly codenamed "Katmai")<ref name="2k8">{{ cite web | url = http://www.microsoft.com/sql/prodinfo/futureversion/default.mspx | title = Microsoft SQL Server 2008 | website = [[Microsoft]] | accessdate = 2007-04-06 }}</ref><ref name="PaulFlessner">{{ cite web|title=ChannelWeb: Next SQL Server stop: Katmai |url=http://www.crn.com/storage/170702999 |accessdate=2005-11-05 |url-status=dead |archiveurl=https://web.archive.org/web/20070322212538/http://www.crn.com/storage/170702999 |archivedate=2007-03-22 }}</ref> 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 data|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 [[Binary large object|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.<ref name="PaulFlessner" />

Other new data types include specialized date and time types and a ''Spatial'' data type for ___location-dependent data.<ref name="iWeek">{{ 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 }}</ref> Better support for unstructured and semi-structured data is provided using the new ''FILESTREAM''<ref name="mary">{{ 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 }}</ref> data type, which can be used to reference any file stored on the file system.<ref name="Kummert">{{ 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 }}</ref> 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 [[API]]s 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.<ref name="kleinerman">{{ cite web | url = http://channel9.msdn.com/Showpost.aspx?postid=387069 | title = SQL Server 2008 for developers | author = Christian Kleinerman | publisher = [[Channel 9 (Microsoft)|Channel 9]] | accessdate = 2008-03-07 }}</ref> SQL Server 2008 also natively supports hierarchical data, and includes [[T-SQL]] constructs to directly deal with them, without using recursive queries.<ref name="kleinerman" />

Line 250:

SQL Server 2008 R2 includes a number of new services,<ref name="Networkworld">{{ 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 }}</ref> including [[PowerPivot]] for [[MS Excel|Excel]] and [[SharePoint]], [[Master Data Services]], [http://msdn.microsoft.com/en-us/sqlserver/ee476990.aspx 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.<ref name="Multi-Server Management">{{ 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 }}</ref>

The first SQL Server 2008 R2 service pack (10.50.2500, Service Pack 1) was released on July 11, 2011.<ref name="SQL Server® 2008 R2 SP1">{{ cite web | url = http://www.microsoft.com/download/en/details.aspx?id=26727 | title = Microsoft® SQL Server® 2008 R2 SP1 | website = [[Microsoft]] | accessdate = 2011-09-19 }}</ref> The second SQL Server 2008 R2 service pack (10.50.4000, Service Pack 2) was released on July 26, 2012.<ref name="SQL Server® 2008 R2 SP2">{{ cite web | url = http://www.microsoft.com/en-us/download/details.aspx?id=30437 | title = Microsoft® SQL Server® 2008 R2 SP2 | website = [[Microsoft]] | accessdate = 2012-07-31 }}</ref> The final SQL Server 2008 R2 service pack (10.50.6000, Service Pack 3) was released on September 26, 2014.<ref name="SQL Server 2008 R2 Service Pack 3">{{ 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 }}</ref>

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>https://rcpmag.com/articles/2010/04/05/microsoft-dropping-itanium-support.aspx</ref>

Line 262:

=== 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.<ref>{{Cite web|url=http://www.faceofit.com/list-of-sql-server-versions-build-numbers-and-service-packs|title = List of SQL Server Versions Build Numbers and Service Packs|date = 9 May 2016}}</ref> Until November 2013 there were two CTP revisions, CTP1 and CTP2.<ref name="CTP2">{{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&nbsp;– CTP2 is now available |first=Deepthi |last=Anantharam |work=MSDN blogs |date=October 16, 2013 |accessdate=2016-08-15}}</ref> SQL Server 2014 provides a new in-memory capability for tables that can fit entirely in memory (also known as [[Hekaton (database)|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 [[Random-access memory|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.<ref name="SQL Server 2012-2014-Explore">[http://www.microsoft.com/en-us/sqlserver/sql-server-2014.aspx SQL Server 2012-2014-Explore. Server Cloud. Microsoft.com (2013-04-17). Retrieved on 2014-03-23]</ref>

For disk-based SQL Server applications, it also provides the SSD Buffer Pool Extension, which can improve performance by cache between [[Random-access memory|RAM]] and spinning media.

Line 303:

|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=2 October 2017}}</ref>

=== SQL Server 2019 ===

Line 508:

|{{no}}

|{{no}}

|{{yes}}(Edge)<ref>{{Cite web|url=https://docs.microsoft.com/en-us/azure/azure-sql-edge/deploy-portal|title = Deploy Azure SQL Edge using the Azure portal}}</ref>

|{{no}}

|}