Encyclopedia > Microsoft SQL Server

  Article Content

Microsoft SQL Server

Microsoft SQL Server is a database management system produced by Microsoft. It supports a dialect of SQL, the most common database language. It is commonly used by governments and businesses for small databases, and competes with other SQL databases such as MySQL and PostgreSQL for this market segment.

The codebase[?] for Microsoft SQL Server originated in Sybase SQL Server, and was Microsoft's entry to the enterprise-level database market, competing against Oracle, IBM, and Sybase. The first version was SQL Server for OS/2 (about 1989) which was essentially the same as Sybase SQL Server 4.0 on Unix, VMS, etc.

About the time Windows NT was coming out, Sybase and Microsoft parted ways and pursued their own design and marketing schemes. Later, Sybase changed the name of its product to Adaptive Server Enterprise[?] to avoid confusion with Microsoft SQL Server.

MS SQL Server uses a variety of SQL called T-SQL, or Transact-SQL, a superset of SQL-92[?] (The ISO standard for SQL, certified in 1992). T-SQL mainly adds support for transactions, and additional syntax for use in stored procedures[?]. MS SQL Server and Sybase/ASE both communicate over networks using an application-level protocol called Tabular Data Stream (TDS). The TDS protocol has also been implemented by the FreeTDS project ([1] (http://www.freetds.org)) in order to allow more kinds of client applications to communicate with MS SQL Server and Sybase databases.

A computer worm named the SQL slammer worm which exploits a security vulnerability in this system was discovered in January 2003, and caused a large Internet slowdown on January 24.Possibly this worm caused the largest malfunction in Internet functionality since the infamous Morris worm November 2, 1988.

In September 2001, SQL Server had ~14% of the commercial database market, according to Gartner Group[?].



All Wikipedia text is available under the terms of the GNU Free Documentation License

 
  Search Encyclopedia

Search over one million articles, find something about almost anything!
 
 
  
  Featured Article
Dynabee

... axis of the gyroscope in the Dynabee is fixed to the spinning mass and it rests in a little groove inside the wrist exerciser device, which almost completely covers the ...

 
 
 
This page was created in 52 ms