History of Microsoft SQL Server: Difference between revisions

Revision as of 03:36, 9 May 2017

Revision as of 05:11, 1 August 2017

Line 166:

=== 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 | 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 |deadurl=yes |archiveurl=https://web.archive.org/web/20070322212538/http://www.crn.com/storage/170702999 |archivedate=2007-03-22 |df= }}</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 includes2s 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" />