MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide

A communication channel set up in SQL Server 2005 for some purpose. An endpoint can be created for TSQL communication, Service Broker queries, SOAP queries, or database mirroring functions.

An object in our logical model that is used to store information about a “thing of interest.”

A relational database integrity mechanism that ensures that duplicate rows do not exist in a table.

Requiring that all rows in a table have a unique identifier.

Extract, Transform, and Load. Refers to the process of taking data from a source, cleaning/standardizing/altering the data as needed, and then loading it into a final destination (often a SQL Server table).

Something of interest that has happened in the context of a SQL Server Notification Services solution that you want to be notified of.

A component of SQL Server Notification Services that is responsible for collecting event data and submitting it to SQL Server Notification Services.

The security permission set within which a SQL Server module is executed.

A stored procedure in SQL Server that provides an interface to external COM components (typically DLL files).

A collection of eight contiguous pages used internally by the storage engine in SQL Server 2005 to track the allocation of file space to table and indexes.