Glossary

A

ACID Atomicity, Consistency, Isolation, and Durability. Properties considered compulsory in relational database theory to ensure transactions are executed correctly by an RDBMS.

ACL Access Control List. A list maintained by the Windows operating system that is used to control which permissions users and groups have to a resource.

Activity Monitor A component of the SQL Server Management Studio that shows what processes are currently connected to the SQL Server instance, what objects they are accessing, what locks have been acquired, and related information.

AD Active Directory. Information stored and used by a Windows 2003 network. Used by administrators to manage security accounts and control security.

Ad hoc report A report in SQL ...

Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.