Microsoft is pushing to make its SQL Server database more attractive to corporate users by simplifying its configuration and management while beefing up its scalability.
Executives from Microsoft discussed new extract, transform and load (ETL) capabilities as part of its next-generation Yukon enterprise database at the Professional Association for SQL Server Community Summit user conference in Seattle .
During a keynote speech yesterday morning, Gordon Mangione, vice president of SQL at Microsoft, also announced the availability of a Best Practices Analyzer for SQL Server 2000.
This tool comes with a checklist of 70 rules, compiled from the Microsoft development team and the SQL user community, to help database administrators configure their SQL installation and avoid the most common errors.
The offerings include pull-down menus, cover backup and recovery, management and performance functions, among other operations.
Mangione said Microsoft hopes to update the tool every quarter, with users eventually able to code rules to best suit their own environments.
Also coming to Yukon is a redesign of the SQL Server ETL architecture called Data Transformation Services (DTS), which will come with out-of-the-box features designed to ease the movement of data and make it easier to for companies to establish data warehouses and perform business intelligence operations.
Mangione cited a boost in the parallelism of DTS, allowing database administrators to do multiple complex tasks simultaneously. For instance, an administrator can now translate data, read it and write it back out again in one flow.
Microsoft has also opened up the software with a new application programming interface for developers who can work in Visual Basic or the .net environment without having to master DTS-specific code.
Scalability has also been boosted so that a process involving large loads of millions of columns of data can be executed in seconds, rather than minutes.
Some half-dozen users at the conference were interested in getting their hands on Yukon as well as some of the new DTS and analyzer features.
Mangione said about 10,000 users have downloaded Yukon.
Marc L Songini writes for Computerworld