A Database Primer
The following sections discuss the fundamental terminology and concepts necessary to manage a SQL Server database.
What Is a Database?
A database is an organized collection of data (see Figure 8.1). This collection of data is logically structured and systematically maintained. SQL Server extends the concept of a database by allowing you to create and store other types of objects, such as stored procedures, triggers, views, and other objects that interact with your data.
Figure 8.1. A database.
What Is the Transaction Log?
The transaction log is the history of data modifications to a database (see Figure 8.2). Whenever you create ...
Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition 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.
