Microsoft released SQL Server 2005 Service Pack 1

Yesterday, Microsoft released Service Pack 1 for SQL Server 2005 to fix a series of errors in the server database application software.

Thus, Service Pack 1 has officially been released to users exactly 5 months after the release of SQL Server 2005. This is a product that Microsoft hopes to gain a higher competitive edge compared to similar products of rivals Oracle and IBM.

In addition to overcoming 40 errors in the application, Service Pack 1 also incorporates some new features such as database image creation. Database image creation is a feature that allows the creation of a database version in the best operating state to assist in quick recovery when the application is malfunctioning.

Microsoft also added two new components to SQL Server 2005 Reporting Services to support businesses in using SAP AG's smart business software. These components include Microsoft .Net Data for NetWeaver Business Intelligence of SAP and MDX Query Designer. New functions allow newspapers to be created and managed directly in SAP Business Warehouse.

SQL Server 2005 Service Pack 1 also incorporates peer-to-peer technology that supports transfer replication. This technology allows subscribers to use a database that can access the latest transactions with other objects or with distributed databases.

A master database will be copied into sub-databases arranged in different locations to help increase response time and address some of the more functional allocation requirements for the motors. Distributed database

The free version of SQL Server 2005 Express Edition is also upgraded with an image management tool. Previously, administrators had to use the command line in the DOS window to install the database version.

However, according to experts, most businesses will not choose to upgrade to Service Pack 1 version but they will wait for a while longer.

HVD - (Computerworld)