Yesterday, Microsoft released Service Pack 1 for SQL Server 2005 to fix a range of issues in the database server application software.
Thus, Service Pack 1 has officially launched for users exactly five months after the SQL Server 2005 version hit the market. This is a product that Microsoft hopes will achieve a higher competitive edge compared to similar offerings from rivals Oracle and IBM.
In addition to fixing 40 bugs in the application, Service Pack 1 also integrates several new features, such as a database snapshot function. The database snapshot feature allows the creation of a database version in optimal operational condition to assist with quick recovery when the application encounters issues.
Microsoft has also added two new components to SQL Server 2005 Reporting Services to support businesses in using enterprise software from SAP AG. These components include Microsoft .NET Data for SAP’s NetWeaver Business Intelligence and MDX Query Designer. The new functions allow reports to be created and managed directly within SAP Business Warehouse.
SQL Server 2005 Service Pack 1 also incorporates peer-to-peer replication technology to assist with data transfer. This technology allows subscribers using a database to access the latest transactions with other objects or with distributed databases.
A master database will replicate into multiple child databases located in different locations to enhance response times while addressing some requirements for greater functionality distribution among distributed databases.
The free version, SQL Server 2005 Express Edition, has also been upgraded with new management tools. Previously, administrators had to use command line prompts in the DOS window to install the database version.
However, experts assess that most businesses will not opt to upgrade immediately to Service Pack 1 but will wait for some additional time.
HVD – (Computerworld)
