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.



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.