1 ■ Before you begin 1
2 ■ Server assessment and configuration 8
3 ■ T-SQL crash course 16
4 ■ Managing databases 34
5 ■ Backup and recovery 44
6 ■ Authentication: who are you? 56
7 ■ Authorization: what are you allowed to do? 65
8 ■ Accounting: what did you do? 75
9 ■ Analyzing indexes 82
10 ■ Maintaining indexes 92
11 ■ Tuning index designs 101
12 ■ Reading query execution plans 110
13 ■ Block and deadlock analysis 119
14 ■ Automating management with SQL Server Agent 128
15 ■ Multiserver management 137
16 ■ Windows PowerShell and SQL Server 143
17 ■ Using Extended Events 153
18 ■ Monitoring and analyzing performance 166
19 ■ Options for high availability 178
20 ■ Virtualizing SQL Server 189
21 ■ Moving, migrating, and upgrading databases 197
22 ■ SQL Server performance checklist 205
23 ■ Never the end 207
