Why Upgrade A complete database and analysis package, SQL Server 2000 delivers a new generation of features and functionality that help you adapt to ever-changing data management and analysis requirements. Great support for Web standards, powerful new tools for system management and tuning, and truly affordable scalability and reliability make SQL Server 2000 the clear choice for enterprise-class database solutions. One of the most important design goals for the SQL Server 2000 team was to construct a database that provides all the tools needed to create powerful e-commerce applications quickly and easily. XML support vastly simplifies back-end system integration and allows for seamless data transfer, even across firewalls. The ability to query and search database information has been improved in SQL Server 2000 as well.
Security is a critical consideration for Web-enabled database applications.
Powerful New Data Analysis Tools SQL Server 7.0 delivered robust analysis functionality with the introduction of OLAP Services. SQL Server 2000 significantly extends this functionality with SQL Server 2000 Analysis Services. Engineered to be more scalable and easier to program, Analysis Services offers built-in data mining tools and storage options that make it possible to build and analyze data warehouses of any size. With SQL Server 2000, these analysis capabilities have expanded out onto the Web. Analysis Services also offers key security upgrades, including the power to define security for cells as well as dimensions.