A column of a table typically used to store an indivisible element of an entity.
A logical means of controlling the placement of database objects on a file or set of files.
A special type of backup specifically designed for very large databases, terabytes in size, that backs up small sections of the database.
A role that is created by SQL Server 2005 in each database with a set of permissions that are predetermined and cannot be altered. Users can be added to one or more fixed database roles.
A predefined role at the server level that is used to control administrative access to the SQL Server instance.
Used to maintain relationships between entities. Implemented as a field in a child table that has a corresponding primary key that it references.
A database object (data integrity mechanism) that maintains referential integrity by establishing and enforcing a link between the data in two tables.
A doubly linked series of pages whose logical order does not equal the physical order.
A backup of the entire database that includes the database files, the locations of those files, and the portions of the transaction log (from the LSN recorded at the start of the backup to the LSN at the end of the backup). This is the first type of backup you will need to do in any backup strategy because all the other backup types depend on the existence of a full backup. A full backup is sometimes called a baseline in a backup strategy.
This model fully logs all transactions and retains all the transaction log records until after they are backed up. In the Enterprise Edition of SQL Server 2005, the full recovery model allows a database to be recovered to the point of failure, assuming that the tail of the log has been backed up after the failure.
The SSIS transformation to use if you do not have an established set of master data but are merely combining a variety of data sources for a “best fit.”
The SSIS transformation to use if you already have a well-established set of master data and are trying to match another source of data against this standardized set.