Database Repository—SQL Server

Aside from the operating systems, when it comes to scalability, SQL Server is the champion of Microsoft servers for scalability. As the data store for nearly all the enterprise servers with the exception of Exchange, Microsoft depends on SQL Server as the center for its offensive line.

SQL Server 2000 introduced a host of features to boost scalability and availability, including:

  • Large memory support

  • Support for large Windows 2000 Data Center Server clusters

  • Multiple instances of SQL Server 2000 on a single server

  • Integration with Active Directory to provide location transparent access to SQL Servers

  • Log shipping for hot standby servers

  • Updateable partitioned views among cluster nodes

  • Improved parallelism in data and ...

Get Building Portals, Intranets, and Corporate Web Sites Using Microsoft Servers now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.