History of Microsoft SQL Server: Difference between revisions

Revision as of 14:50, 11 March 2017

Revision as of 05:50, 3 April 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 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 172:

The [[full-text search]] functionality has been integrated with the database engine. According to a Microsoft technical article, this simplifies management and improves performance.<ref name="Full-Text Search">{{ 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 }}</ref>

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.<ref name="Spatial Support">{{ 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 = httphttps://web.archive.org/web/20070808001216/http://www.directionsmag.com/editorials.php?article_id=2477&trv=1 | archivedate = 2007-08-08 |deadurl=yes |df= }}</ref>

SQL Server includes better compression features, which also helps in improving scalability.<ref name="Features of SQL 2008">{{ cite web | url = http://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 }}</ref> 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 Data Encryption|transparent encryption of data]] (TDE) as well as compression of backups.<ref name="mary" /> 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]].<ref name="Entity Data Platform">{{ 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 }}</ref> [[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.<ref name="Tech-Ed 2007">{{ 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 }}</ref> 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.<ref name="iWeek" /> The version of [[SQL Server Management Studio]] included with SQL Server 2008 supports [[IntelliSense]] for SQL queries against a SQL Server 2008 Database Engine.<ref name="IntelliSense">{{ cite web | url = http://msdn.microsoft.com/en-us/library/ms173434.aspx | title = SQL Server IntelliSense | accessdate = 2008-08-18 }}</ref> 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]].<ref name="PowerShell">{{ 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 }}</ref> '''