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. Microsoft SQL Server 4.2 was shipped around 1993 (available bundled with Microsoft OS/2 version 1.3).
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. Until 1994 Microsoft's SQL Server carried three Sybase copyright notices as an indication of its origin.
A stripped down version of Microsoft SQL Server known as MSDE (Microsoft SQL Server Desktop Engine) is distributed with products such as Visual FoxPro, Microsoft Access, MS Web Matrix, and other products. The MSDE has some restrictions: A limit of 2 GB databases, 8 concurrent connections and it comes with no tools to administer it. It also has a workload governor which reduces its speed once you exceed 5 concurrent workloads on the engine.
MS SQL Server uses a variant 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 additional syntax for use in stored procedures, and affects the syntax of transactions support. (Note that SQL standards require atomic, consistent, isolated, durable transactions.) 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]) in order to allow more kinds of client applications to communicate with MS SQL Server and Sybase databases. MS SQL Server also supports Open Database Connectivity (ODBC).
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. It is possible that this worm caused the largest degradation in Internet performance since the infamous Morris worm (November 2, 1988).
In September 2001, SQL Server had ~14% of the commercial database market, according to Gartner.