List of Listings

Chapter 6. Security

Listing 6.1. Creating a database role

Listing 6.2. Assigning logins to a database role

Listing 6.3. DDL trigger to capture table creation details

Listing 6.4. DDL trigger to prevent table modifications

Listing 6.5. Logon trigger to prevent logon for a period of time

Listing 6.6. Setting up Change Data Capture

Listing 6.7. Modifying data and viewing CDC changes

Chapter 9. Data management

Listing 9.1. Create a multi-filegroup database

Chapter 10. Backup and recovery

Listing 10.1. Recovering a database to a point in time

Listing 10.2. Marking multiple transaction logs for coordinated restores

Listing 10.3. Creating a database with multiple filegroups for online restore

Listing 10.4. Filegroup backups

Listing 10.5. Online piecemeal restore: restoring the most important filegroup first

Listing 10.6. Online piecemeal restore for remaining filegroups

Chapter 12. DBCC validation

Listing 12.1. Page restore

Chapter 13. Index design and maintenance

Listing 13.1. Creating a heap table

Listing 13.2. Comparing query execution methods

Listing 13.3. Sorted and grouped sales orders

Listing 13.4. Creating an indexed view

Listing 13.5. Indexes not used since last instance restart

Listing 13.6. High-maintenance/low-value indexes

Listing 13.7. Simulating activity to view missing indexes by priority

Listing 13.8. Missing index DMV query with potential weighting

Listing 13.9. Displaying index fragmentation

Chapter 14. Monitoring and automation

Listing 14.1. T-SQL code to generate a deadlock