Microsoft has released details of tools planned for increasing database administration capabilities in the existing and upcoming versions of the company's SQL Server database.
The company revealed the details during its 2003 Professional Association for SQL Server (PASS) Community Summit meeting in Seattle.
One of the tools to be featured in the Yukon version of SQL Server due out next year, a reconstituted Data Transformation Services (DTS) technology for extracting, transforming, and loading (ETL) of data, is intended to provide scalable and manageable ETL services.
DTS will feature graphical debugging and built-in transformations such as "fuzzy lookup" to allow developers to develop enterprise applications more easily. Also to be featured in the DTS architecture are transaction support, the ability to restart, data error handling and data cleansing.
An API for developers enables DTS to be extended with custom data sources, transformations, workflow tasks and other objects.
Microsoft also announced the beta availability of Best Practices Analzyer (BPA) for SQL Server 2000, a tool intended to help DBAs develop better SQL Server applications and avoid common errors in managing database installations.
The tool features configuration recommendations on subjects ranging from availability and backup and recovery, to management and performance. The tool can also help DBAs plan for future use of the system.
The BPA tool is available for download at www.microsoft.com/sql.
Paul Krill writes for InfoWorld