MCSE SQL 2000 Administration Book

	Introduction	xix
	Self-Assessment	xxxiii
Chapter 1	Microsoft Certification Exams	1
	Assessing Exam-Readiness	2
	What to Expect at the Testing Center	2
	Exam Layout and Design	4
	Multiple-Choice Question Format	5
	Build-List-and-Reorder Question Format	6
	Create-a-Tree Question Format	8
	Drag-and-Connect Question Format	10
	Select-and-Place Question Format	11
	Microsoft's Testing Formats	12
	Strategies for Different Testing Formats	14
	Case Study Exam Strategy	15
	Fixed-Length and Short-Form Exam Strategy	16
	Adaptive Exam Strategy	17
	Question-Handling Strategies	18
	Mastering the Inner Game	19
	Additional Resources	19
Chapter 2	SQL Server 2000 Overview	23
	Database Basics	24
	Relational Databases	25
	Client/Server	26
	Two-Tier Architecture	27
	Three-Tier Architecture	27
	n-Tier Architectures	28
	Collaborative Enterprise Architectures	28
	SQL Server 2000 Databases	28
	System Databases	29
	User Databases	29
	Database File Types	30
	Versions of SQL Server 2000	30
	Practice Questions	32
	Need to Know More?	37
Chapter 3	Installation Planning	39
	Instances	40
	Default Instance	41
	Named Instances	41
	Multiple Versions	41
	Options	42
	Editions	42
	Installation	44
	Components	44
	File Paths	46
	Network Libraries	46
	Collations	48
	Requirements	50
	Hardware	50
	Software	50
	Services	51
	Service Accounts	51
	Authentication	52
	Practice Questions	53
	Need to Know More?	58
Chapter 4	Basic Installation	59
	Before You Begin	60
	Default Instance	61
	Installation	61
	Typical, Minimum, and Custom Installations	68
	Named Instance	68
	Subinstallations	71
	Client Tools Only	71
	Connectivity Only	73
	Adding Components	75
	Adding or Removing Components	75
	Upgrading Installed Components	78
	Installing Additional Components	78
	Analysis Services	78
	English Query	81
	Uninstalling	83
	SQL Server 2000 Uninstallation	83
	Add/Remove Programs Uninstallation	85
	Practice Questions	87
	Need to Know More?	95
Chapter 5	Advanced Installation and Upgrade	97
	Before You Begin	98
	Advanced Installation	98
	Remote Installation	98
	Remote Uninstallation	105
	Unattended Installation	105
	Custom Installation	110
	Registry Rebuild	117
	Failover Clustering	117
	New Virtual Server	119
	Adding a Node	120
	Removing a Node	121
	Virtual Server Uninstallation	122
	Configuration	123
	Configuring Services Accounts	123
	Configuring Network Libraries	125
	Upgrades	126
	Upgrading Existing SQL Server 7.0 Installations	127
	Upgrading SQL Server 7.0 Databases	127
	Upgrading SQL Server 6.5 Databases	131
	Upgrading Existing SQL Server 2000 Instances	132
	Practice Questions	133
	Need to Know More?	140
Chapter 6	Creating Databases	141
	Basic Requirements	142
	Files	142
	Filegroups	143
	Transaction Logs	143
	Creating a Database	144
	Creating a Database Using the Enterprise Manager	145
	Creating a Database Using the Query Analyzer	148
	Deleting a Database Using the Enterprise Manager	153
	Deleting a Database Using the Query Analyzer	153
	Creating an Object	154
	Creating a Table Using the Enterprise Manager	155
	Creating a View Using the Enterprise Manager	156
	Creating a Stored Procedure Using the Enterprise Manager	157
	Deleting an Object Using the Enterprise Manager	158
	Practice Questions	160
	Need to Know More?	167
Chapter 7	Managing Databases	169
	Getting Started	170
	Restricting Database Access	170
	Returning Database Access to Normal	171
	Managing Databases	171
	Attaching a Database	172
	Detaching a Database	173
	Expanding a Database	174
	Shrinking a Database	174
	Altering Databases	176
	Managing Objects	181
	Modifying a Table Using the Enterprise Manager	181
	Modifying a View Using the Enterprise Manager	183
	Modifying a Stored Procedure Using the Enterprise Manager	183
	Modifying an Index Using the Enterprise Manager	184
	Practice Questions	187
	Need to Know More?	195
Chapter 8	Disaster Recovery	197
	Disaster Recovery Planning	198
	Considerations	198
	Backup Types	200
	Recovery Model Options	201
	Database Backups	202
	Performing a Full Backup	203
	Performing a Differential Backup	205
	Performing a Transaction Log Backup	206
	Performing a File or Filegroup Backup	207
	Database Restoration	208
	Performing Database Restorations	209
	Filegroup and File Restoration	210
	Creating a Standby Server	211
	Creating a Cold Standby Server	211
	Practice Questions	213
	Need to Know More?	220
Chapter 9	Troubleshooting and Integrity Checking	221
	Data Integrity	222
	Enforcing Integrity	223
	Creating Table Relationships	224
	Creating a UNIQUE Constraint	225
	Creating Check Constraint	226
	Deadlocking	226
	Monitoring Transactions and Data Integrity	228
	Monitoring with SQL Profiler	229
	Monitoring with the Enterprise Manager	230
	Monitoring with Transact-SQL (T-SQL)	233
	DBCC Statements	234
	Maintenance DBCC Statements	236
	Status DBCC Statements	237
	Validation DBCC Statements	239
	Miscellaneous DBCC Statements	241
	Practice Questions	243
	Need to Know More?	250
Chapter 10	Extracting and Transforming Data	251
	Command-Line Statements	252
	INSERT Statement	252
	BULK INSERT Statement	254
	SELECT...INTO Statement	257
	bcp Utility	257
	Data Transformation Services (DTS)	261
	Distributed Solutions	264
	Replication	264
	Linked Server	267
	Practice Questions	268
	Need to Know More?	274
Chapter 11	SQL Server 2000 Security	275
	Overview	276
	Authentication	277
	Windows Authentication	277
	SQL Server Authentication (Mixed-Mode)	280
	Special Logins	282
	Authorization	283
	Permissions	283
	Roles	285
	Application Roles	290
	Auditing SQL Server Security	290
	Practice Questions	291
	Need to Know More?	297
Chapter 12	Automation and Server Agents	299
	Automating Administration Tasks	300
	Administration Components	300
	Multiserver Administration	301
	Administration Agents	303
	Creating Jobs	304
	Creating Operators	308
	Creating Alerts	309
	Database Maintenance Planning Wizard	311
	Practice Questions	313
	Need to Know More?	318
Chapter 13	Optimizing Performance	319
	Performance Monitoring	320
	Establishing a Baseline	322
	Identifying Problem Areas	322
	Optimizing Performance	324
	Index Defragmentation	325
	Bulk Copy Optimization	326
	Practice Questions	328
	Need to Know More?	333
Chapter 14	Sample Test	335
Chapter 15	Answer Key	359
	Glossary	375
	Index	385