A component of a SQL Server Integration Services package that controls the flow of data within the package.
The integrity of data as measured by several standards.
An information store that can be connected to by various SQL Server technologies such as SQL Server Reporting Services for data retrieval.
A tool included in SQL Server 2005 that can be used to tune SQL Server 2000 and SQL Server 2005 databases.
A component of SQL Server 2005 that can be used to send email messages.
A tool accessible through Management Studio that can be used to schedule backups to run automatically.
The key used to encrypt all keys inside a database. This key is required to access any encrypted information within a database.
Any of the various items included in a database including tables, views, diagrams, and so on.
A database object used to group principals.
A feature of SQL Server 2005 that enables you to indefinitely store the state of the database at a particular point in time.
A database object that allows you to control the type of data that will be stored in a table’s column.
DataBase Console Command. A set of commands used by DBAs to perform administrative tasks.
Database Owner. Special predefined database user account that exists in every database.
Also a schema in SQL Server 2005.
Data Control Language. The ANSI SQL 92 category of SQL statements that allows you to define access control against database objects.
Data Definition Language. The ANSI SQL 92 category of SQL statements that allows you to define database objects. Data Definition Language is used to control schema changes and alterations to how the server functions. These statements operate on objects such as tables, views, logins, and other structures.
A SQL Server 2005 database object that automatically executes whenever a DDL operation is attempted at either the server level or the database level.
Part of BIDS, it allows a user to step through various actions in an SSIS package, inspect variables, or even stop just before a problematic section of the package.
A database object (data integrity mechanism) that automatically inserts a default value into a column if no value has been provided by the INSERT Transact-SQL statement.
The process used by SQL Server to forward the credentials of an authenticated Windows user.
An attack on a computer designed to prevent legitimate users or even administrators from accessing the resources on that computer. Often this is by overwhelming the computer’s resources.
The formal process of introducing redundancy back into the database design to improve performance.
The degree of duplicate values for the data contained in a table column.
Transact-SQL statement that explicitly denies/disallows an object or statement permission.
Whether a function always returns the same output given the same inputs.
A set of computers and servers used for testing code and schema changes. This environment usually has the lowest security and change control procedures.
A SQL Server Service Broker component that represents a conversation between two endpoints.
A collection of policies and procedures designed to be implemented in the event of a disaster. The plan might also specify steps to be taken to prevent or limit the effect of disasters.
A query that accesses data from multiple heterogeneous data sources.
System database in SQL Server 2005 used by the replication technology.
The replication agent in charge of moving the newly created snapshot jobs and transactions that are held in the distribution database to each subscriber for synchronization in a replication configuration.
A replication server role used to store and forward initial snapshots of publications and distribute them to subscribers. Distributors can also store transactions that need to be sent to subscribers.
Also, a component of SQL Server Notification Services that is responsible for formatting and sending notifications to subscribers.
Also, a role played by a SQL Server instance in a replication topology. The distributor is responsible for monitoring databases marked for replication and logging all data modifications to the distribution database.
Data Manipulation Language. The ANSI SQL 92 category of SQL statements that allows you to manipulate data in database entities. DML statements are designed to operate on data, making changes or retrieving data using the SELECT, INSERT, EXECUTE, DELETE, and UPDATE statements.
A Transact-SQL trigger that fires whenever a DML operation is performed on a table.
A relational database integrity mechanism that enforces the validity of data at the column level.
The ability in a SQL Server Reporting Services solution to go through the report to the source data used to generate the level of data within the report.
Distributed Transaction Coordinator. The DTC is an operating system component that is responsible for coordinating distributed transactions using the two-phase commit algorithm. A number of SQL Server technologies, such as transaction replication, take advantage of the DTC.
A SQL Server 2005 database object that exposes various internal memory structures, database engine components, and database components in a relational format.