MCSE Administering SQL Server 7考前冲刺PDF电子书下载

Chapter 1 Microsoft Certification Exams 1

Assessing Exam-Readiness 2

The Exam Situation 2

Exam Layout And Design 3

Microsoft s Testing Formats 5

Strategies For Different Testing Formats 7

Exam-Taking Basics 10

Mastering The Inner Game 10

Additional Resources 11

Chapter 2 SQL Server Overview 13

Introduction To Application Architectures 14

SQL Server Architecture Overview 15

SQL Server Functions And Features 16

The Four System Databases In SQL Server 7 17

Practice Questions 19

Need To Know More? 21

Chapter 3 Server Installation,Configuration,And Upgrades 23

Overview Of Installing SQL Server 24

Planning For Installation 24

Preparing For Installation 30

Installing SQL Server 31

Upgrading SQL Server 32

Unattended Installations 38

Troubleshooting The Installation 40

Troubleshooting An Upgrade 40

Testing An Installation 40

Starting And Stopping SQL Server 41

Configuring SQL Server 42

Configuring SQL Mail 44

Setting Up A Failover Server 45

Installing A Client Computer 46

Uninstalling SQL Server 47

Practice Questions 48

Need To Know More? 52

Chapter 4 Security 53

Security Overview 54

Authentication 54

Accessing Databases 59

Roles 61

Permissions 67

Limitations On Logins,Users,Roles,And Passwords 71

Practice Questions 72

Need To Know More? 76

Chapter 5 Databases And Files 77

Database Overview 78

The Transaction Log 80

Creating Databases 81

Planning A Database 81

Altering Databases 83

Configuring Databases 88

Viewing Database Information 90

Practice Questions 92

Need To Know More? 95

Chapter 6 Transferring Data 97

The INSERT Statement 98

The SELECT INTO Statement 103

The BULK INSERT Statement 104

The bcp Program 107

The Data Transformation Service 112

Practice Questions 119

Need To Know More? 123

Chapter 7 Backing Up Databases 125

Backup Devices 126

Types Of Backups 126

The BACKUP Command 128

Choosing A Backup Strategy 137

Practice Questions 138

Need To Know More? 141

Chapter 8 Restoring Databases 143

The RESTORE Command 144

Other RESTORE Options 151

Relevant System Tables 154

Practice Questions 155

Need To Know More? 157

Chapter 9 Monitoring The Server 159

The SHOWPLAN Command 160

The UPDATE STATISTICS Command 163

The Error Log 165

The sp_who Stored Procedure 167

The sp_lock Stored Procedure 168

The sp_spaceused Stored Procedure 169

The sp_monitor Stored Procedure 170

The Database Consistency Checker(DBCC) 172

Detecting And Resolving Locking Problems 172

SQL Server Profiler 175

Monitoring With Windows NT Performance Monitor 176

Practice Questions 177

Need To Know More? 181

Chapter 10 Automating Administrative Tasks 183

Overview Of Automated Administration 184

Defining Jobs,Operators,and Alerts 186

Practice Questions 195

Need To Know More? 198

Chapter 11 Replication 199

The Publish And Subscribe Model 200

Overview 200

Setting Up Replication 202

Practice Questions 236

Need To Know More? 240

Chapter 12 Remote Data Access 241

Overview 242

Remote Procedure Calls 242

Distributed Queries 247

Distributed Transactions 253

Practice Questions 257

Need To Know More? 261

Chapter 13 SQL Server 7 Troubleshooting 263

Handling Problems With Upgrading From SQL Server 6.x 264

Handling Problems With BACKUP And RESTORE Operations 265

Handling Replication Problems 267

Handling Distributed Query Problems 271

Handling Problems With Access To SQL Server,Databases,And Database Objects 273

Practice Questions 275

Need To Know More? 278

Chapter 14 Sample Test 279

Questions,Questions,Questions 280

Picking Proper Answers 280

Decoding Ambiguity 281

Working Within The Framework 282

Deciding What To Memorize 283

Preparing For The Test 284

Taking The Test 284

Sample Test 286

Chapter 15 Answer Key To Sample Test 305

Appendix Pubs Database 313

Glossary 321

Index 339