Microsoft Unveils Tools to Increase Database Administrator Productivity For SQL Server 2000 and SQL Server “Yukon”

SEATTLE, Nov. 12, 2003 — Today at the 2003 Professional Association for SQL Server (PASS) Community Summit — Seattle, Microsoft Corp. unveiled details about upcoming tools that will increase database administration productivity. In the opening keynote address, Gordon Mangione, corporate vice president for SQL Server (TM) at Microsoft, highlighted the significant advancements that will be made to Microsoft’s extract, transform and load (ETL) technology, known as Data Transformation Services (DTS), in the next version of Microsoft®
SQL Server, code-named
In addition, he announced the availability of the Best Practices Analyzer (BPA) for SQL Server 2000, a tool designed to help database administrators (DBAs) develop better, more maintainable SQL Server applications and avoid common errors in managing SQL Server installations.

Also during his keynote address, Mangione highlighted that Microsoft SQL Server, part of the Microsoft Windows Server System (TM) , had been identified as one of the world’s largest and most heavily used databases by Winter Corporation, a leading center of expertise in database scalability for enterprise applications and business intelligence (BI). More than 20 SQL Server customers were included on four TopTen lists in the survey, which means customers on the lists chose SQL Server more than any other Windows-based database provider. Moreover, two winners were in the
“All Environments”
category, which includes the largest databases in the world. This recognition provides independent validation that SQL Server meets the demands of enterprise-class scalability.

“Winter Corp.’s survey proves that SQL Server exceeds the demands of large, enterprise-scale businesses,”
Mangione said.
“The customers included in this survey store multiple terabytes of data and rely on SQL Server. Not only do they get the scalability they need, but it comes at a much lower cost than with other systems.”


to Deliver Enterprise-Level, Out-of-the-Box ETL Capabilities

In SQL Server
users will see a complete redesign of the DTS architecture, which will provide developers and DBAs with enterprise-level ETL capabilities out of the box. The new DTS architecture enables scalable, manageable and reliable ETL with remarkable ease of use and performance. Features such as graphical debugging, and built-in transformations such as fuzzy lookup, will allow developers and DBAs to easily develop enterprise-class applications. The DTS architecture not only enables great performance and scale, but also provides transaction support, restartability, data error handling and data cleansing. The new DTS will enable DBAs to readily build data movement and ETL solutions that are inherently reliable.

“According to industry analysts, 70 to 80 percent of the costs to implement BI is from data integration,”
said Bill Baker, general manager for SQL Server business intelligence at Microsoft.
“The out-of-the-box capabilities available with Microsoft’s DTS capabilities enable customers to quickly and easily build ETL solutions at a fraction of the cost of what is available in the market today. With this technology, customers can get more from their data at a much lower total cost of ownership.”

DTS has tight integration with Analysis Services, Reporting Services and Web Services — metadata sharing gives a more complete design time experience, and at runtime this close integration powers end-to-end business intelligence.

A comprehensive API for developers means that DTS can be extended with custom data sources, transformations, workflow tasks and other objects, all of which take advantage of fundamental DTS abilities, such as debugging, error handling, restart and event handlers. Even better, these APIs can be used from native code for optimal performance, or from managed code for the simplicity, security and other advantages of Microsoft .NET.

Best Practices Analyzer: The Shortest Path to More Manageable SQL Server Applications

The Best Practices Analyzer for SQL Server 2000 is a noninvasive, extensible tool that compiles best practices and recommendations from the development team and SQL Server users. The tool is designed to help DBAs and developers build better, more maintainable SQL Server applications and avoid oversights in managing SQL Server installations. The best practices cover the usage and administration aspects of SQL Server databases. The configuration recommendations range from availability and backup/recover to management and performance. In addition, the BPA can scan for configurations that use deprecated features, which helps DBAs plan for future uses of the system. The BPA beta release is available today for download at .

About SQL Server

Microsoft SQL Server, part of the Windows Server System, is the complete database and analysis offering for rapidly delivering the next generation of scalable e-commerce, line-of-business and business intelligence solutions. It dramatically reduces the time required to bring these applications to market while offering the scalability needed for the most-demanding environments. More information on Microsoft SQL Server can be found at .

About Windows Server System

Microsoft Windows Server System is an integrated and interoperable server infrastructure that reduces IT complexity to enable IT professionals to deliver innovative solutions that meet the changing needs of business. With Windows Server™
2003 at the foundation, Windows Server System is engineered from the ground up for XML Web services based on Microsoft .NET technologies to connect information, people, systems and devices. Based on a common software architecture that spans all facets of IT, from design, development and deployment through ongoing management and usage, Windows Server System provides comprehensive IT infrastructure for operations (security, systems management, networked storage), applications (data management and analysis, e-business), and information work (messaging, communications and collaboration). More information on Microsoft Windows Server System can be found at .

About Microsoft

Founded in 1975, Microsoft (Nasdaq
) is the worldwide leader in software, services and Internet technologies for personal and business computing. The company offers a wide range of products and services designed to empower people through great software

any time, any place and on any device.

Microsoft, Windows Server System and Windows Server are either registered trademarks or trademarks of Microsoft Corp. in the United States and/or other countries.

The names of actual companies and products mentioned herein may be the trademarks of their respective owners.

Note to editors: If you are interested in viewing additional information on Microsoft, please visit the Microsoft Web page at on Microsoft’s corporate information pages. Web links, telephone numbers and titles were correct at time of publication, but may since have changed. For additional assistance, journalists and analysts may contact Microsoft’s Rapid Response Team or other appropriate contacts listed at .

Related Posts