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
Scroll to Top