What is Microsoft SQL?

Microsoft SQL Server is a relational database management system that supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environments.

A database server is a computer program that provides database services to other programs or computers, as defined by the client-server model. Therefore, a Microsoft SQL Server is a database server that implements the Structured Query Language (SQL).

Microsoft 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.