The Microsoft SQL Server is a relational database management system that provides an open, comprehensive, and integrated approach to information management. A database server is the key to solving the problems of information management. A database server must also prevent unauthorized access and provide efficient solutions for failure recovery. The Microsoft SQL Server provides efficient and effective solutions with the following features.

Large Database and Space Management: Microsoft SQL Server supports the largest databases, to make efficient use of expensive hardware devices; it allows full control of space usage.

High Transaction Processing Performance: Microsoft SQL Server maintains the preceding features with a high degree of overall system performance. Database users do not suffer from slow processing performance.

High Availability: At some sites, Microsoft SQL Server works 24 hours per day with no down time to limit database throughput. Normal system operations such as database backup and partial computer system failures do not interrupt database use.

Controlled Availability: Microsoft SQL Server selectively controls the availability of data, at the database level and sub database level. For example, an administrator can disallow use of specific application so that the application’s data can be reloaded, without affecting other applications.

Openness, Industry Standards: Microsoft SQL Server adheres to industry-accepted standards for the data access language, operating system, user interfaces, and network communication protocols. It is an open system that protects a customer’s investment.

Manageable Security: To protect against unauthorized database access and use, Microsoft SQL Server provides fail-safe security features to limit and monitor data access. These features make it easy to manage even the most complex design for data access.

Database Enforced Integrity: Microsoft SQL Server enforces data integrity, business rules that dictate the standard for acceptable data. As a result, the costs of coding and managing checks in many database applications are eliminated.

Compatibility: Microsoft SQL Server software is compatible with industry standards, including most industry standard operating system (windows).