D


Data flow

A component of a SQL Server Integration Services package that controls the flow of data within the package.

Data quality

The integrity of data as measured by several standards.

Data source

An information store that can be connected to by various SQL Server technologies such as SQL Server Reporting Services for data retrieval.

Database Engine Tuning Advisor

A tool included in SQL Server 2005 that can be used to tune SQL Server 2000 and SQL Server 2005 databases.

Database Mail

A component of SQL Server 2005 that can be used to send email messages.

Database Maintenance Plan Wizard

A tool accessible through Management Studio that can be used to schedule backups to run automatically.

Database master key

The key used to encrypt all keys inside a database. This key is required to access any encrypted information within a database.

Database objects

Any of the various items included in a database including tables, views, diagrams, and so on.

Database role

A database object used to group principals.

Database snapshot

A feature of SQL Server 2005 that enables you to indefinitely store the state of the database at a particular point in time.

Datatype

A database object that allows you to control the type of data that will be stored in a table’s column.

DBCC

DataBase Console Command. A set of commands used by DBAs to perform administrative tasks.

dbo

Database Owner. Special predefined database user account that exists in every database.

Also a schema in SQL Server 2005.

DCL

Data Control Language. The ANSI SQL 92 category of SQL statements that allows you to define access control against database objects.

DDL

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.

DDL trigger

A SQL Server 2005 database object that automatically executes whenever a DDL operation is attempted at either the server level or the database level.

Debugger

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.

DEFAULT definition

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.

Delegation

The process used by SQL Server to forward the credentials of an authenticated Windows user.

Denial-of-service attack

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.

Denormalization

The formal process of introducing redundancy back into the database design to improve performance.

Density

The degree of duplicate values for the data contained in a table column.

DENY

Transact-SQL statement that explicitly denies/disallows an object or statement permission.

Deterministic

Whether a function always returns the same output given the same inputs.

Development environment

A set of computers and servers used for testing code and schema changes. This environment usually has the lowest security and change control procedures.

Dialog

A SQL Server Service Broker component that represents a conversation between two endpoints.

Disaster recovery plan

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.

Distributed query

A query that accesses data from multiple heterogeneous data sources.

Distribution

System database in SQL Server 2005 used by the replication technology.

Distribution Agent

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.

Distributor

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.

DML

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.

DML trigger

A Transact-SQL trigger that fires whenever a DML operation is performed on a table.

Domain integrity

A relational database integrity mechanism that enforces the validity of data at the column level.

Drill through

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.

DTC

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.

Dynamic management view

A SQL Server 2005 database object that exposes various internal memory structures, database engine components, and database components in a relational format.



MCITP Administrator. Microsoft SQL Server 2005 Optimization and Maintenance Study Guide (70-444)
MCITP Administrator: Microsoft SQL Server 2005 Optimization and Maintenance (Exam 70-444) Study Guide
ISBN: 0470127457
EAN: 2147483647
Year: 2004
Pages: 146

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net