History of Microsoft SQL Server: Difference between revisions

Revision as of 16:43, 4 August 2017

Revision as of 06:35, 26 August 2017

Line 180:

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=https://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 = httphttps://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> '''

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 = 2014-10-01 }}</ref>

Line 188:

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.<ref name="Innovations">{{ 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&nbsp;– New SQL Server Innovations}}</ref>

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, [httphttps://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 | accessdate = 2011-09-19 }}</ref>

Line 212:

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.<ref name="Testversion">{{ cite web | url = httphttps://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 }}</ref>

SQL Server 2014 SP1, consisting primarily of bugfixes, was released on May 15, 2015.<ref name="SQL Server 2014 Service Pack 1">{{ 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 }}</ref>