SQL Server 2005 manages 10 of the most important features

This article describes the 10 most important features of SQL Server2005 from the aspects of database management.

Database Mirroring

The new database mirroring method is used to extend the performance of record file transfer. You will be able to use database mirroring to enhance the availability of your SQL Server system by establishing an automated failover to a server that is being used.

Online recovery

With the SQL Server2005 version server, the database administrator will be able to perform a recovery operation when the SQL Server is running. Online recovery improves the availability of SQL Servers because only the data being recovered is unusable, while the rest of the database is still online and available for use.

Online retrieval operations

The online retrieval option allows synchronous modification of the base table, or clustered index data, and any related retrievals during the execution of the exponential data definition language (DDL). For example, when a clustered index is being rebuilt, you can continue to update the base data and query the data.

Rapid recovery

New faster recovery options can improve the availability of SQL Server databases. The manager will be able to reconnect to the database being restored after the transaction log has been scrolled forward.

Improved safety performance

SQL Server 2005 includes some security-performance improvements, such as database encryption, setting security defaults, enhanced password policies, rigorous licensing control, and an enhanced security model.

New SQL Server Management Studio

SQL Server2005 introduces SQL Server Management Studio, a new, unified management Tool Group. The tool group will include new features to develop, configure, and repair failures in the SQL Server database, and the tool group has also made some improvements to previous functions.

Dedicated Administrator connections

SQL Server2005 will introduce a dedicated administrator connection, even if a server is locked, or for other reasons cannot be used, the administrator can through this connection, connect to the running server. This feature will enable administrators to find and resolve identified problems by manipulating diagnostic functions, or Transact-SQL directives.

Snapshot isolation

We will provide a new snapshot isolation (SI) standard at the database level. With snapshot isolation, the user will be able to view the database with a traditional, consistent view and access the last line of data that is executed. This feature will provide the server with greater scalability.

Data segmentation

Data segmentation will enhance the segmentation of this surface retrieval, which makes the large tables and indexes can be managed efficiently.

Enhance replication capabilities

For distributed databases, SQL SERVER2005 provides comprehensive schema modification (DDL) replication, next-generation monitoring performance, built-in replication from Oracle to SQL Server, and merge replication for multiple Hypertext Transfer protocols (HTTP). and a major improvement in the scalability and operation of merge replication. In addition, the new Peer-to-peer transactional replication performance improves its support for data scaling out by using replication.