Advertisement
Promo

Office applications Toolkit

Microsoft eases SQL administration

Martin LaMonica CNET News

Published: 13 Nov 2003 11:50 GMT

  • Email
  • Trackback
  • Clip Link
  • Print friendly
  • Post Comment

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.

  • Email
  • Trackback
  • Clip Link
  • Print friendlyPrint with EPSON

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


Company/Topic Alerts

Create a new alert from the list below:




Video icon

Video

Win a BlackBerry with Vlingo voice recognition

Win a BlackBerry with Vlingo voice recognition

What is ZDNet UK's usual tagline?

Competition closes - 14 Jan 2010

Discussions

Shibley R Shibley R

Copyright in a new light

Monday 28 December 2009, 1:29 PM

7 comments
Shibley R Shibley R

Eigg

Sunday 27 December 2009, 1:04 PM

1 comment

Vista Upgrade Blog

How to Upgrade From Windows Vista to W...

Did you get the news? Microsoft has unzipped its kitty and kept its latest, supposedly the best, offering on display. This is the brand new version of Microsoft operating system, named... More

Post a comment

Tinsel on the TARDIS

There were shepherds on the hill, and the Doctor popped his head out of the TARDIS and said "you might want to see this" and they were astounded. WHY do we pay for a TV license?... More

Post a comment

Can I have fries with that? (Consumer...

Licence policies of Tech company's have been for a long time both complicated and 'Dick Turpin-esque', people just click 'I agree' without reading the Agreement. I do the same, but... More

1 comment


Skip Sub Navigation Links to CNET Brand Links

Help

Become part of the ZDNet community.

Newsletters