Monday, April 16, 2007

Microsoft SQL Server: SQL Server 2005 Features at a Glance

Microsoft SQL Server: SQL Server 2005 Features at a Glance


High Availability
Failover clustering and database mirroring technology in SQL Server 2005 will enable enterprises to deliver highly reliable, available applications to employees, customers, and partners.
Management Tools
SQL Server 2005 introduces an integrated suite of management tools and management application programming interfaces (APIs) to provide ease of use, manageability, and support for operating large-scale SQL Server deployments.
Security Enhancements
SQL Server 2005 has been designed to help provide the highest level of security for enterprise data through features such as database encryption, more secure default settings, password policy enforcement, granular permissions control, and an enhanced security model.
Scalability
Scalability advancements in SQL Server 2005 include table partitioning, replication enhancements, and 64-bit support.