SQL Server

This topic describes the uses and components of Microsoft SQL Server. Users in a cloud environment are not able to directly interact with the SQL server, so this information is for reference only for those users.

Microsoft SQL Server is used to:

Maintain the relationships between data in the database
Ensure that data is stored correctly and that the rules defining data relationships are not violated
Manage data and user security
Optimize server function performance
Recover all data to a point of known consistency in case of system failures

SQL Server is primarily responsible for managing databases that interact with enterprise business systems. Some of the components that make up these databases are:

Tables
Views
Stored procedures
Triggers
Constraints
Indexes
Keys
User defined data types