Office applications Toolkit

Microsoft eases SQL administration

Martin LaMonica CNET News.com

Published: 13 Nov 2003 11:50 GMT

Microsoft on Wednesday introduced tools to ease database administration for both the current and forthcoming edition of its SQL Server database.

At an SQL Server customer conference in Seattle, the software giant spelled out new features targeted at simplifying day-to-day management of its SQL Server databases and making administrators more productive, a company representative said.

Microsoft released a tool on Wednesday that scans a database and provides guidelines on how to best configure and maintain SQL Server databases for better performance. Called Best Practices Analyser, the software is designed to work with the current edition of the company database, SQL Server 2000.

For the forthcoming edition of SQL Server, code-named Yukon and expected to be completed by the end of 2004, Microsoft plans to include tools for moving data into data warehouses, which are used to analyse company operations. The Data Transformation Services in Yukon are being redesigned to help developers and administrators move and reformat data more quickly and eliminate the need for some third-party tools, according to Microsoft.

The planned enhancements underscore the growing importance of management tools among cost-conscious buyers in the highly competitive database arena. The top three providers -- Oracle, IBM and Microsoft -- are each bulking up their respective databases with management-related features to reduce the cost of operating databases.

Oracle last week detailed a number of enhancements it has planned for its Oracle Database 10g, which is slated for an end-of-the-year delivery. Oracle hopes that lowering the maintenance costs of its database will keep Microsoft from luring away its core customer base of large corporations.

Oracle and IBM are also counting on lower costs and simpler administration to penetrate the market for small and mid-sized companies, which is Microsoft's largest customer segment.

Did you find this article useful?
45 out of 96 people found this useful

More In Office applications

Company/Topic Alerts

Create a new alert from the list below:

Featured Talkback

Why do so many (virtually all) software packages think that they are so important that they have to be started automatically every time the computer boots? What is the largest number of "speed access", "update check", "camera download" and whatever other background programs you have ever seen running? Of those, how many did you really need?