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
  • Microsoft SQL Server 2012
  • Microsoft SQL Server 2014

 


Have a project in mind?

Get in touch with us for your MS SQL development needs!