Contents at a Glance
Introduction....................................................................................................1
Part I Welcome to Microsoft SQL Server
1 SQL Server 2008 Overview..............................................................................9
2 What’s New in SQL Server 2008...................................................................35
3 Examples of SQL Server Implementations ...................................................51
Part II SQL Server Tools and Utilities
4 SQL Server Management Studio ...................................................................63
5 SQL Server Command-Line Utilities ..........................................................103
6 SQL Server Profiler ......................................................................................121
Part III SQL Server Administration
7 SQL Server System and Database Administration......................................165
8 Installing SQL Server 2008..........................................................................185
9 Upgrading to SQL Server 2008 ...................................................................227
10 Client Installation and Configuration .......................................................263
11 Security and User Administration ..............................................................291
12 Data Encryption..........................................................................................335
13 Security and Compliance............................................................................359
14 Database Backup and Restore .....................................................................377
15 Database Mail..............................................................................................427
16 SQL Server Scheduling and Notification....................................................449
17 Administering SQL Server 2008 with PowerShell ......................................481
18 SQL Server High Availability ......................................................................523
19 Replication ..................................................................................................545
20 Database Mirroring .....................................................................................617
21 SQL Server Clustering .................................................................................655
22 Administering Policy-Based Management..................................................687
Part IV Database Administration
23 Creating and Managing Databases .............................................................709
24 Creating and Managing Tables ...................................................................741
25 Creating and Managing Indexes ................................................................791
26 Implementing Data Integrity......................................................................811
27 Creating and Managing Views in SQL Server ............................................837
28 Creating and Managing Stored Procedures ................................................869
29 Creating and Managing User-Defined Functions. .....................................917
30 Creating and Managing Triggers . ..............................................................949
31 Transaction Management and the Transaction Log . ................................995
32 Database Snapshots. .................................................................................1043
33 Database Maintenance. ............................................................................1069
Part V SQL Server Performance and Optimization
34 Data Structures, Indexes, and Performance . ...........................................1091
35 Understanding Query Optimization . ......................................................1209
36 Query Analysis . ........................................................................................1301
37 Locking and Performance.........................................................................1341
38 Database Design and Performance . .........................................................1403
39 Monitoring SQL Server Performance. ......................................................1427
40 Managing Workloads with the Resource Governor . ...............................1493
41 A Performance and Tuning Methodology. ..............................................1519
Chapters on the CD
Part VI SQL Server Application Development
42 What’s New for Transact-SQL in SQL Server 2008. .................................1551
43 Transact-SQL Programming Guidelines, Tips, and Tricks . ......................1637
44 Advanced Stored Procedure Programming and Optimization.................1733
45 SQL Server and the .NET Framework . .....................................................1787
46 SQLCLR: Developing SQL Server Objects in .NET . .................................1825
47 Using XML in SQL Server 2008 . ..............................................................1865
48 SQL Server Web Services . .........................................................................1927
49 SQL Server Service Broker . .......................................................................1959
50 SQL Server Full-Text Search . ....................................................................1997
Part VII SQL Server Business Intelligence Features
51 SQL Server 2008 Analysis Services. ..........................................................2029
52 SQL Server Integration Services . ..............................................................2099
53 SQL Server 2008 Reporting Services . .......................................................2169
Part VIII Bonus Chapters
54 Managing Linked and Remote Servers . ...................................................2243
55 Configuring, Tuning, and Optimizing SQL Server Options . ..................2273
56 SQL Server Disaster Recovery Planning. ..................................................2329
Index 2353
- Log in to post comments