Allows you to make changes to how a package executes without actually changing the package.
Encompasses options that control whether other users can see sensitive data contained in the package or even open the package at all.
The basic unit of I/O within SQL Server 2005. It is 8KB (8,192 bytes) in size. Used to store data rows.
A report in SQL Server Reporting Services that accepts input parameters.
This type of backup contains all the data in the primary filegroup, every read-write filegroup, and any optionally specified files. Partial backups are useful when a database contains one or more read-only filegroups that have been read-only since the last full backup. A partial backup of a read-only database contains only the primary filegroup.
A partial differential backup records only the data that has changed in the filegroups since the preceding partial backup; such a partial backup is called the base for the differential. Therefore, partial differential backups are smaller and faster than partial backups, and this facilitates making frequent backups to decrease your risk of data loss.
A database object that determines how data within a partitioned table will be split.
A database object that maps the partitions of a partition function to a set of filegroups.
A table that has been separated into a number of logical horizontal partitions (which are mapped to different physical files) through a partition scheme.
The process of replacing a table with multiple smaller units. Tables can be partitioned horizontally or vertically.
A query that is passed through uninterrupted to an external database engine.
Windows operating system components used to monitor the performance of a particular operating system subsystem or application.
A Windows operating system tool that can be used to capture performance information into logs and generate alerts when thresholds criteria are met.
The infrastructure and procedures that protect the physical assets, computer hardware, and wiring, from unauthorized access.
Used to restore the primary filegroup and (optionally) some secondary filegroups and make them accessible to users. Remaining secondary filegroups can be restored later if needed.
Unencoded data.
Recovering only the transactions within a log backup committed before a specific point in time, instead of recovering the entire backup.
The first file used by SQL Server’s storage engine to store the database. A primary data file stores the system tables and data.
A database object (data integrity mechanism) that maintains entity integrity. Primary keys do not allow null values, and the same value cannot be used twice.
The default filegroup within a SQL Server database.
A user or process that requests access to a resource. Windows logins, Windows groups, SQL Server logins, database users, database roles, and application roles are principals in SQL Server 2005.
In database mirroring, the primary database that is being protected and contains the live data used up until a failover occurs.
Part of an asymmetric key encryption system that is kept secret by the party who holds it. It can be used to encrypt information that can be decrypted by the public key of the party or decrypt information that was encrypted by the public key matching this private key.
The servers that are being used by end users and clients and contain the data of record. The production environment has the highest security and change control procedures.
Part of an asymmetric key encryption system. This key is disclosed to any party, which can then use it to decrypt information encrypted by the private key, which provides authentication. This key can also be used to encrypt information that can be decrypted only by the private key.
A collection of articles acting as a basis for subscription in replication.
A role played by a SQL Server instance in a replication topology. The Publisher contains a database that is available for replication.