Microsoft KB Archive/323049

= INF: What's New in SQL Server 2000 (White Paper) =

Article ID: 323049

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q323049



SUMMARY
With SQL Server 2000, users have an excellent, streamlined database platform for large-scale online transactional processing (OLTP), data warehousing, and e-commerce applications. The white paper that this article references provides brief overviews of the improvements that Microsoft made to SQL Server 7.0. In SQL Server 2000, users have a fully-integrated Extensible Markup Language (XML) environment, a new data mining feature in Analysis Services, and enhanced repository technology with Meta Data Services.

The Analysis Services that Microsoft SQL Server 2000 includes significantly enhance the capabilities of the OLAP Services component that was introduced in SQL Server version 7.0. Analysis Services introduces data mining, which users can use to discover information in OLAP cubes and relational databases. In this white paper, learn how SQL Server 2000 improves security controls, enhances client connectivity, and makes real-time data analysis possible.

Microsoft SQL Server 2000 Meta Data Services extends and renames the former repository component known as Microsoft Repository. Learn how Meta Data Services extends repository technology with the introduction of a new browser for viewing data in a repository database, new XML interchange support, and new repository engine features.

To view this white paper, visit the following Microsoft Web site:

What's New in SQL Server 2000

Included in this document:

What's New in Microsoft SQL Server 2000

 * Relational Database Enhancements
 * XML Integration of Relational Data
 * Graphical Administration Enhancements
 * Replication Enhancements
 * Data Transformation Services Enhancements
 * Analysis Services Enhancements
 * Meta Data Services Enhancements
 * English Query Enhancements
 * Documentation Enhancements

What's New in Analysis Services

 * Cube Enhancements
 * Dimension Enhancements
 * Data Mining Enhancements
 * Security Enhancements
 * Client Connectivity Enhancements in PivotTable Service
 * Other Enhancements

What's New in Meta Data Services

 * Meta Data Browser Enhancement
 * XML Encoding Enhancements
 * Repository Engine Programming Enhancements
 * Repository Engine Modeling Enhancements

Keywords: kbinfo kbwhitepaper KB323049

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.