User Manual

Contents ix
Chapter 6: Managing Transactions and Locks 187
Manage SQL Server Locks 189
Identify Lock Types and Behaviors 189
Identify Lock Compatibility 193
Manage Locking Behavior 194
Manage Transactions 199
Creating Transactions 200
Handling Transaction Errors 203
Using Savepoints in Transactions 205
Implement Distributed Transactions 208
Understanding Distributed Queries 209
Defining Distributed Transactions 215
Manage Special Transaction Situations 217
Concurrency and Performance 217
Managing Deadlocks 218
Setting Lock Time-Outs 220
Chapter 7: Managing Security 221
Implement User Security 222
Understand the Security Architecture 222
Implement Server Logins 229
Implement Database Users 232
Implement Roles 234
Manage Server Roles 234
Implement Database Roles 236
Implement Application Roles 237
Implement Permissions 240
Understand the Permissions Model 240
Manage Permissions through SSMS 241
Manage Permissions through a Transact SQL Script 244
Encrypt Data with Keys 245
Understand SQL Server Keys 246
Manage SQL Server Keys 247
Encrypt and Decrypt Data with Keys 253
Implement Transparent Data Encryption 255
Part III: Data Administration 259
Chapter 8: Implementing Availability and Replication 261
Implement Availability Solutions 262
Understand RAID 263
Understand Clustering 264
Implement Log Shipping 265
Implement Database Mirroring 276
96602book.indb 9 7/23/09 4:04:17 PM