E

Endpoint

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.

Entity

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

Entity integrity

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.

ETL

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).

Event

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

Event provider

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

Execution context

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

Extended stored procedure

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

Extent

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.