Microsoft SQL Server
Microsoft SQL Server is a relational database server, that comes with a variety of tools and a front end management application. It supports the Transact-SQL language for queries, but the .NET languages can be used as well.
Advantages
- Support for large amounts of data
- Reliability against data loss
- Full support for relational databases
Disadvantages
- Large installation footprint
- Requires more powerful hardware
Components
- Data Storage Engine
- Data Retrieval Engine
- Transaction Broker
- Reporting Services
- Full Text Search Service
Development tools
- SQL Server Management Studio
- Microsoft Visual Studio
Editions
- SQL Server Compact Edition (SQL CE)
- SQL Server Datacenter Edition
- SQL Server Developer Edition
- SQL Server 2005 Embedded Edition (SSEE)
- SQL Server Enterprise Edition
- SQL Server Evaluation Edition
- SQL Server Express Edition
- SQL Server Fast Track
- SQL Server Standard Edition
- SQL Server Web Edition
- SQL Server Workgroup Edition
Versions
- Microsoft SQL Server 2000
- Microsoft SQL Server 2005
- Microsoft SQL Server 2008
- Microsoft SQL Server 2008 R2