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