Part 3 - SQL Server Architecture

The topics in "SQL Server Architecture" describe how all of the features and components of Microsoft SQL Server work together to increase its effectiveness as an SQL-based, client/server, relational database.

Topic	Description
Fundamentals of SQL Server Architecture	Describes key concepts of SQL Server architecture.
SQL Server Features	Highlights the features of SQL Server.
Client/Server Architecture	Describes the components involved in the communications between client applications and SQL Server.
Database Architecture	Describes the logical components defined in SQL Server databases and how they are physically implemented in database files.
Server Architecture	Describes the features of the server engine that make it efficient at processing large numbers of concurrent requests for data from many users.
Administration Architecture	Describes how the tools provided with SQL Server and the dynamic configuration capabilities of SQL Server minimize routine administrative tasks.
Replication Architecture	Describes the replication and data transformation services (DTS) components of SQL Server and how they can be used to distribute data between databases.
Data Warehousing and Online Analytical Processing	Describes Data Transformation Services (DTS) and Microsoft SQL Server OLAP Services, and how they help in building and analyzing a data warehouse or data mart.
Application Development Architecture	Describes how SQL Server supports the various database programming APIs to let users build robust database applications.
Implementation Details	Discusses implementation details such as the maximum capacities of Transact-SQL statements, the ranges of SQL Server configuration options, memory usage of SQL Server objects, and the differences between the various editions of SQL Server.