SQL Server 2005 — Enhancements

What are the enhancements for Data Base Administrators in SQL Server 2005 ?

SQL Server 2005 has provide single management console that enables data base Administrators monitor, manage and tune all databases and services. SQL Management Object (SMO) is an efficient management infrastructure to easily program. SMO provides all the management functionalities of the SQL Server and is implemented as a Microsoft .NET Framework assembly.
The primary purpose of the SMO is to automate administrative tasks such as retrieving configuration settings, creating new databases, applying T-SQL scripts, Creating SQL Server Agent jobs and so on

1. SQL Server Management Studio :
It is a one point access to a number of services – the relational database, the Integration services, Analysis services, Reporting services, Notification Services and SQL Mobile.
Indexing capabilities
The SQL Server 2005 has been greatly enhanced. Indexes can be created, rebuilt or dropped online without disturbing existing indexes. This online indexing capability allows parallel processing, concurrent modifications to the table in the database or clustered index data or any other associated indexes.

2. Peer to peer model of replication
It is enables synchronization of transactions with an identical peer database. This further improves availability of data.

3. Table and index partitioning
It is concept of large databases by dividing the whole into manageable chunks. The concept is not new to the SQL Server, but the partitioning of tables horizontally across file groups in the database is new.

4. Snapshot isolation
This feature allows users access the last row that was committed by providing a transactional and consistent view of the database.

5. Replication monitor tool
It defines a new standard for managing complex data replication operations. Its interface is intuitive and has a number of data metrics that are useful.

6. New security model
Security model of the database platform now provides more precise and flexible control for ensuring security of store data.

7. Encryption capabilities
Data encryption of the database has been integrated with the management infrastructure for centralization of security assurance and server policy.

8. Secure computing measures
Those things have been put in place to enable deployment of a secure environment.
SQL Server Express Manager (XM)
This is a free Query Editor tool that is available for download.

9. Improved Business Intelligence

10. Improved Analysis Services

11. Improved Reporting services