History of Microsoft SQL Server: Difference between revisions

Revision as of 09:34, 4 March 2023

Revision as of 09:39, 4 March 2023

Line 212:

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|extract-transform-load (ETL)]] tool (initially called Data Transformation Services -or DTS-, and subsequentlylater called SQL Server Integration Services, or [[SQL Server Integration Services|SSIS]])

*[[SQL Server Reporting Services]] (SSRS), or "Reporting Server"

*an [[OLAP]] and [[data mining]] server ([[Microsoft Analysis Services|Analysis Services]])

Line 219:

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.<ref>{{cite web|url=http://www.informit.com/articles/article.aspx?p=25735|title=What's New in SQL Server 2000 &#124; New SQL Server 2000 Features &#124; InformIT}}</ref><ref>{{cite web|url=http://sqlmag.com/t-sql/sql-server-2000s-coolest-features|title=ITPro Today: IT News, How-Tos, Trends, Case Studies, Career Tips, More}}</ref>

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 EnterpriseSQL ManagerServer Management Studio, wouldwere still need to be run from 32-bit x86 clientsprograms. The first release of SQL IA-64 was version 8.00.760, with a build date of February 6, 2003.

Mainstream Supportsupport Endedended on April 8, 2008, and Extendedextended Supportsupport Endedended on April 9, 2013.

===SQL Server 2005===