P


Package configuration

Allows you to make changes to how a package executes without actually changing the package.

Package security

Encompasses options that control whether other users can see sensitive data contained in the package or even open the package at all.

Page

The basic unit of I/O within SQL Server 2005. It is 8KB (8,192 bytes) in size. Used to store data rows.

Parameterized report

A report in SQL Server Reporting Services that accepts input parameters.

Partial backup

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.

Partial differential backup

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.

Partition function

A database object that determines how data within a partitioned table will be split.

Partition scheme

A database object that maps the partitions of a partition function to a set of filegroups.

Partitioned table

A table that has been separated into a number of logical horizontal partitions (which are mapped to different physical files) through a partition scheme.

Partitioning

The process of replacing a table with multiple smaller units. Tables can be partitioned horizontally or vertically.

Pass-through query

A query that is passed through uninterrupted to an external database engine.

Performance counters

Windows operating system components used to monitor the performance of a particular operating system subsystem or application.

Performance Logs and Alerts tool

A Windows operating system tool that can be used to capture performance information into logs and generate alerts when thresholds criteria are met.

Physical security

The infrastructure and procedures that protect the physical assets, computer hardware, and wiring, from unauthorized access.

Piecemeal restore

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.

Plain text

Unencoded data.

Point-in-time restore

Recovering only the transactions within a log backup committed before a specific point in time, instead of recovering the entire backup.

Primary data file

The first file used by SQL Server’s storage engine to store the database. A primary data file stores the system tables and data.

Primary key constraint

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.

PRIMARY filegroup

The default filegroup within a SQL Server database.

Principal

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.

Principal database

In database mirroring, the primary database that is being protected and contains the live data used up until a failover occurs.

Private key

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.

Production environment

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.

Public key

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.

Publication

A collection of articles acting as a basis for subscription in replication.

Publisher

A role played by a SQL Server instance in a replication topology. The Publisher contains a database that is available for replication.



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