SQL Administration (cont'd)

Powerful, flexible Web-based analysis. SQL Server 2000 Analysis Services capabilities are extended to the Internet. You can access and manipulate cube data by means of a Web browser.
Highly Scalable and Reliable
Achieve unparalleled scalability and reliability with SQL Server 2000. With scale up and scale out capabilities, SQL Server meets the needs of demanding ecommerce and enterprise applications.
§ Scale up. SQL Server 2000 takes advantage of symmetrical multiprocessor (SMP) systems. SQL Server Enterprise Edition can use up to 32 processors and 64 GB of RAM.
§ Scale out. Scale out distributes the database and data load across servers.
§ Availability. SQL Server 2000 achieves maximum availability through enhanced failover clustering, log shipping, and new backup strategies.
Fastest Time-to-Market
SQL Server 2000 is the data management and analysis backbone of the Microsoft .NET Enterprise Servers. SQL Server 2000 includes tools to speed development from concept to final delivery.
§ Integrated and extensible analysis services. With SQL Server 2000, you can build end-to-end analysis solutions with integrated tools to create value from data. Additionally, you can automatically drive business processes based on analysis results and flexibly retrieve custom result sets from the most complex calculations.
§ Quick development, debugging, and data transformation. SQL Server 2000 features the ability to interactively tune and debug queries, quickly move and transform data from any source, and define and use functions as if they were built in to Transact-SQL. You can visually design and code database applications from any Visual Studio tool.
§ Simplified management and tuning. With SQL Server 2000, it is easy to manage databases centrally alongside all enterprise resources. Stay online while easily moving and copying databases across computers or between instances.