List of Figures

Chapter 2. Server assessment and configuration

Figure 2.1. Two instances of SQL Server are installed.

Figure 2.2. Connecting to SQL Server

Figure 2.3. Observing SQL Server version numbers

Figure 2.4. Inventorying the databases in localhost\SQL2

Figure 2.5. Inventorying a database’s files

Figure 2.6. Members of the sysadmin fixed server role

Figure 2.7. Viewing installed SQL Server services

Chapter 3. T-SQL crash course

Figure 3.1. Selecting a database for the query window

Figure 3.2. Running a sample query

Figure 3.3. The online documentation is easy to access from anywhere.

Figure 3.4. Viewing the columns in Person.Person

Figure 3.5. The table design reveals details about its structure.

Figure 3.6. Database Diagrams folders are located in each database.

Figure 3.7. Adding an owner to the database

Figure 3.8. Database Diagrams start with a list of tables.

Figure 3.9. Arranging the tables creates a better layout.

Figure 3.10. Locate the BusinessEntityID relationship and click it.

Figure 3.11. A multitable query

Chapter 4. Managing databases

Figure 4.1. The General tab includes basic information about the database.

Figure 4.2. You have two options when detaching a database.

Chapter 5. Backup and recovery

Figure 5.1. Loading a page into the buffer pool

Figure 5.2. SQL Server copies all queries into the transaction log.

Figure 5.3. SQL Server commits the page and checkpoints the log.

Figure 5.4. Start the recovery process in this dialog.

Figure 5.5. Choose alternate file restore locations.