Back to top
Glossary Term: 

SQL Server

Is Microsoft's relational database management system. It is a full-featured database primarily designed to compete against competitors Oracle Database (DB) and MySQL. Like all major RBDMS, SQL Server supports ANSI SQL, the standard SQL language. However, SQL Server also contains T-SQL, its own SQL implementation. SQL Server is sometimes referred to as MSSQL and Microsoft SQL Server.

  • SQL Server is offered in several editions with different feature set and pricing options to meet a variety of user needs, including the following:
  • Enterprise: Designed for large enterprises with complex data requirements, data warehousing and Web-enabled databases. Has all the features of SQL Server, and its license pricing is the most expensive.
  • Standard: Targeted toward small and medium organizations. Also supports e-commerce and data warehousing.
  • Workgroup: For small organizations. No size or user limits and may be used as the backend database for small Web servers or branch offices.
  • Express: Free for distribution. Has the fewest number of features and limits database size and users. May be used as a replacement for an Access database.

Search All Glossary Terms

. A B C D E F H I L M N O P Q R S T U V W