APPENDIX B
Glossary
ACID
An acronym for the four properties that guarantee the reliable processing of database transactions. ACID stands for:
- Atomicity
- Consistency
- Isolation
- Durability
Active Directory
A directory service that supports user and group permissions in Windows networks. It can be used in conjunction with SQL Server–integrated security to control permissions to your SQL Server.
Apply and Rollback Scripts
Apply scripts apply a change of some sort to the database; rollback scripts remove those changes. Normally, for each apply script there will exist a correlating rollback script.
Cartesian Product
Usually the result of a poorly structured ...
Get Introducing SQL Server 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.
