Microsoft SQL Server
is a relational database management system developed by Microsoft.
As a database, it is a software product whose primary function is to
store and retrieve data as requested by other software applications, be
it those on the same computer or those running on another computer
across a network (including the Internet). There are at least a dozen
different editions of Microsoft SQL Server aimed at different audiences
and for different workloads (ranging from small applications that store
and retrieve data on the same computer, to millions of users and
computers that access huge amounts of data from the Internet at the same
time). Its primary query languages are T-SQL and ANSI SQL.
Genesis
Prior
to version 7.0 the code base for MS SQL Server was sold by Sybase SQL
Server to Microsoft, and was Microsoft's entry to the enterprise-level
database market, competing against Oracle, IBM, and, later, Sybase.
Microsoft, Sybase and Ashton-Tate originally teamed up to create and
market the first version named SQL Server 1.0 for OS/2 (about 1989)
which was essentially the same as Sybase SQL Server 3.0 on Unix, VMS,
etc. Microsoft SQL Server 4.2 was shipped around 1992 (available bundled
with IBM OS/2
version 1.3). Later Microsoft SQL Server 4.21 for Windows NT was
released at the same time as Windows NT 3.1. Microsoft SQL Server v6.0
was the first version designed for NT, and did not include any direction
from Sybase.
About the time Windows NT
was released in July 1993, Sybase and Microsoft parted ways and each
pursued its own design and marketing schemes. Microsoft negotiated
exclusive rights to all versions of SQL Server written for Microsoft
operating systems. (In 1996 Sybase changed the name of its product to Adaptive Server Enterprise
to avoid confusion with Microsoft SQL Server.) Until 1994, Microsoft's
SQL Server carried three Sybase copyright notices as an indication of
its origin.
SQL
Server 7.0 and SQL Server 2000 included modifications and extensions to
the Sybase code base, adding support for the IA-64 architecture. By SQL
Server 2005 the legacy Sybase code had been completely rewritten.
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 ETL tool (SQL Server Integration Services or SSIS)
a Reporting Server
an OLAP and data mining server (Analysis Services)
several messaging technologies, specifically Service Broker and Notification Services
a Reporting Server
an OLAP and data mining server (Analysis Services)
several messaging technologies, specifically Service Broker and Notification Services
Tutorials Information
From:- kudvenkat chanel
64 Tutorials
0 التعليقات:
Post a Comment