|
|  |
|
Product Information
Product Overview
Develop your database solutions with the new and enhanced capabilities of SQL Server 2000. Built on the extensible foundation of SQL Server 7.0, it represents the next-generation database of the Microsoft .NET Enterprise Servers. SQL Server 2000 is the complete relational database management and analysis system for building scalable e-commerce, line-of-business, and data warehousing solutions.
Why upgrade to SQL Server 2000
Compare editions of SQL Server 2000
 | Data Warehousing
| |
Since the introduction of SQL Server 7.0 online analytical processing (OLAP) services, Microsoft has become a leader for Business Intelligence (BI) solutions. Enterprises need to integrate, consolidate, and summarize information from heterogeneous data sources. Data warehouses provide this capability through large, central data stores where information is collected, organized, and made readily available to decision makers for analysis. Decision makers thus gain insights, assess patterns and trends, make better business decisions, and predict future behavior.
Microsoft provides you with new data warehousing functionality for analysis services that include integrated data mining, OLAP Services, security enhancements, and the ability to access and securely link to cubes over the Internet. For more information see the Data Warehousing Overview page.
|
 |
E-Commerce
| |
E-commerce solutions place heavy demands on database applications. As users worldwide access e-commerce sites around the clock, high transactional loads must be handled effectively. Programmatic flexibility is also critical to ensure both interoperability with existing systems, and the ability to respond quickly to changing business requirements. Besides providing the scalability and reliability required for e-commerce, SQL Server 2000 provides extensive database programming capabilities—built on Web standards—to ensure interoperability and flexibility. Relevant, new features in SQL Server 2000 include rich extensible markup language (XML) functionality, support for Worldwide Web Consortium (W3C) standards, the ability to manipulate XML data using Transact SQL (T-SQL), flexible and powerful Web-based analysis, and secure access to your data over the Web using Hypertext Transfer Protocol (HTTP). For more information, see the E-Commerce Overview page.
|
 | Line-of-Business
| |
SQL Server has become the preferred database of Customer Relationship Management (CRM), Business Intelligence (BI), Enterprise Resource Planning (ERP), and other line-of-business application vendors and customers due to SQL Server scalability on symmetric multiprocessing (SMP) hardware and low database maintenance requirements. With SQL Server 2000 Server, you get the enhanced reliability, scalability, and simplified management and tuning that is required to successfully and rapidly deploy your line-of-business applications. SQL Server 2000 not only enables centralized database management, but also automates management and tuning as much as possible to reduce the burden on the administrator. For more information, see the Line-of-Business Overview page.
|
Visit the Product & Technology Web site to find answers to commonly asked questions about SQL Server 2000.
| |
|
