Pro SQL Server Administration
About the Author ..................................................................................................xxiii
About the Technical Reviewers .............................................................................xxv
■■Part I: Installing and Configuring SQL Server ..................................... 1
■■Chapter 1: Planning the Deployment ..................................................................... 3
■■Chapter 2: GUI Installation ................................................................................... 29
■■Chapter 3: Server Core Installation ..................................................................... 65
■■Chapter 4: Configuring the Instance .................................................................... 89
■■Part II: Database Administration .................................................... 129
■■Chapter 5: Files and Filegroups ......................................................................... 131
■■Chapter 6: Configuring Tables ........................................................................... 163
■■Chapter 7: Indexes and Statistics ...................................................................... 199
■■Chapter 8: Database Consistency ...................................................................... 249
■■Part III: Security, Resilience, and Scaling ....................................... 277
■■Chapter 9: SQL Server Security Model .............................................................. 279
■■Chapter 10: Encryption ...................................................................................... 317
■■Chapter 11: High Availability and Disaster Recovery Concepts ........................ 341
■■Chapter 12: Implementing Clustering ................................................................ 365
■■Chapter 13: Implementing AlwaysOn Availability Groups ................................. 417
