Cover image for Practical Microsoft SQL Server 7.0
Practical Microsoft SQL Server 7.0
McGehee, Brad, 1957-
Publication Information:
Indianapolis, Ind. : Que, [1999]

Physical Description:
xvii, 746 pages : illustrations ; 24 cm
General Note:
Includes index.
Title Subject:
Subject Term:
Added Author:
Format :


Call Number
Material Type
Home Location
Item Holds
QA76.9.D3 P715 1999 Adult Non-Fiction Central Closed Stacks

On Order



With Practical Microsoft SQL Server 7 you will learn everything you need to know about SQL Server and how to use it in a corporate setting. Youll cover all the essential topics in a straight forward, no-nonsense manner. Progressing through the book you will learn the basics of SQL Server, how to install and Configure SQL Server, how to administer SQL Server, how to securing data and prevent data loss, and how to perform critical administration tasks. After completing the book, you will be able to implement SQL Server in your organization and perform all necessary operations.

Author Notes

Brad McGehee, MCSE, MCT, MCP, is a full-time computer trainer and database professional. He has been involved in the computer industry as a trainer and consultant since 1981. Brad has been writing about the computer industry since 1983 and is the author of four books and hundreds of articles.
Rob Kraft, MCSD, MCT, has been developing applications for SQL Server since version 4.2. He is a certified Microsoft SQL Server trainer and has taught Visual Basic at Microsoft developer events.

Table of Contents

I SQL Server Basicsp. 9
1 Introduction to SQL Server 7.0p. 11
SQL Server Helps You to Master Business Informationp. 12
What Is SQL Server?p. 13
A Little Background on SQL Serverp. 15
Major Features of SQL Server 7.0p. 15
How SQL Server Is Integrated with Windows NT Server and Microsoft BackOfficep. 22
What You Need to Know to Be a Successful SQL Server DBAp. 25
2 SQL Server and Database Fundamentalsp. 35
SQL Server Fundamentalsp. 36
SQL Server Administration Fundamentalsp. 40
SQL Server Architecture Fundamentalsp. 42
Database Fundamentalsp. 49
Database Object Fundamentalsp. 51
Database Architecture Fundamentalsp. 56
What Is Transact-SQL?p. 66
II Installing and Configuring SQL Serverp. 71
3 Planning a SQL Server Installationp. 73
Planning Is an Important First Stepp. 74
How Will SQL Server Be Used in Your Organization?p. 75
How Will SQL Server Fit into Your Current Network?p. 84
Plan How to Protect SQL Server Datap. 92
Plan Your SQL Server Software Requirementsp. 97
Plan Your SQL Server Hardware Requirementsp. 100
Formalizing and Carrying Out the Planp. 107
4 Installing SQL Serverp. 111
What You Need to Know Before Installing SQL Server 7.0p. 112
Minimum Hardware and Software Requirementsp. 112
Different Ways to Install SQL Serverp. 120
SQL Server Installation and Configuration Optionsp. 123
Installing SQL Serverp. 143
Post-Installation Issuesp. 151
Troubleshooting a SQL Server Installationp. 167
How to Remove SQL Serverp. 170
5 Installing SQL Client Utilitiesp. 171
What Are the SQL Server Management Tools?p. 172
SQL Server Management Toolsp. 172
Choosing Online Documentation to Install on Clientsp. 174
Management Tool Hardware and Software Requirementsp. 175
Where to Install the Management Tools Fromp. 176
How to Install the SQL Server Management Toolsp. 177
How to Use the Client Configuration Utilityp. 184
Troubleshooting a Management Tools Installationp. 189
6 Upgrading SQL Server From 6.5 to 7.0p. 191
Developing an Upgrade Strategy and Planp. 192
Upgrade Troubleshootingp. 211
Upgrade Planning FAQp. 214
III Administering SQL Serverp. 217
7 SQL Server Toolsp. 219
Using the Microsoft Management Console (MMC)p. 220
SQL Enterprise Manager Overviewp. 222
SQL Server Setupp. 226
SQL Server Service Managerp. 226
SQL Server Client Configuration Utilityp. 228
SQL Server Performance Monitorp. 229
SQL Server Profilerp. 229
SQL Server Query Analyzerp. 232
SQL Server Books Onlinep. 234
BCPp. 236
ISQL Utilityp. 236
osqlp. 238
makepipe and readpipep. 241
SQL Server Wizardsp. 243
Register Server Wizardp. 244
8 Managing Databasesp. 251
Planning SQL Server Databasesp. 253
How to Delete (Drop) a SQL Server Databasep. 263
Setting SQL Server Database Optionsp. 265
Files and Filegroupsp. 268
Documenting SQL Server Database Creation Stepsp. 271
9 Scheduling Tasks and Alertsp. 275
SQL Server Agent Overviewp. 277
How to Manage Jobsp. 284
Alerts and Operatorsp. 291
How to Set Up SQL Server to Send Emailp. 297
Troubleshootingp. 302
10 Maintaining SQL Serverp. 307
Maintaining SQL Server Over the Long Haulp. 308
Document Your SQL Serversp. 308
Create a Formal SQL Server Maintenance Planp. 311
Monitor Log Filesp. 313
Monitor Securityp. 317
Monitor User Activityp. 325
Monitor SQL Server Performancep. 327
Manage Current and Create New Databasesp. 330
Maintaining SQL Server Softwarep. 331
Verify the Integrity of SQL Server Databasesp. 333
Maintain Database Indexesp. 334
Backup Databases and Transaction Logsp. 336
NT Server-Related Maintenance Tasksp. 336
Working with Developersp. 338
How to Use the Database Maintenance Plan Wizardp. 338
SQL Server Maintenance Checklistp. 352
IV SQL Server Securityp. 355
11 Introduction to SQL Securityp. 357
SQL Server Security Basicsp. 358
Planning SQL Server Securityp. 359
The SQL Server Security Architecturep. 360
What Is a Security Mode?p. 366
SQL Server Mixed Authentication Security Modep. 367
Using the Windows NT Authentication Security Modep. 371
12 Managing Usersp. 375
How Do Users Gain Access to SQL Server?p. 376
Introduction to SQL Server Accountsp. 376
How to Create and Manage Login IDsp. 378
How to Create and Manage Database User IDsp. 382
How to Manage SQL Server Rolesp. 383
How to Manage Users Using SQL Enterprise Managerp. 387
How to Use the SQL Server Create Login Wizard to Manage SQL Server Accountsp. 388
How to Manually Create, Modify, and Delete SQL Server Login IDs and Database User IDsp. 393
How to Create and Configure Login IDsp. 404
13 Assigning User Permissionsp. 419
Permissions Determine Who Can Access Datap. 420
Statement Permissionsp. 422
Object Permissionsp. 423
Implied Permissionsp. 424
Understanding Permission Precedencep. 428
Using Views and Stored Procedures to Enforce Securityp. 431
Understanding Ownership Chainsp. 432
Best Practices for Managing Permissionsp. 435
How to Display Information on Permissionsp. 436
How to Grant and Revoke Permissionp. 443
How to Grant and Revoke Statement Permissions Using SQL Enterprise Managerp. 443
How to Grant and Revoke Object Permissions Using SQL Enterprise Managerp. 446
V Preventing Data Lossp. 451
14 Backing Up Databasesp. 453
Ways to Prevent Data Lossp. 455
Establishing a Backup Strategyp. 466
Implementing SQL Server Backupsp. 476
15 Restoring SQL Datap. 483
Restore Overviewp. 484
How to Restore Datap. 496
How to Restore System Databasesp. 501
VI Advanced SQL Server Administrationp. 507
16 Importing, Exporting, and Distributing Datap. 509
Data Transformation Service (DTS)p. 510
Bulk Copy Program (BCP)p. 520
Bulk Insertp. 532
Improving Load Performancep. 534
Working with Batch Filesp. 535
Distributing Databases on Removable Mediap. 537
17 Setting Up and Configuring Data Replicationp. 541
SQL Server Replication Overviewp. 542
Publications and Articlesp. 544
SQL Server Replication Architecturep. 547
How to Use Wizards to Configure Replicationp. 553
Setting Up Replication Using the SQL Enterprise Managerp. 553
18 SQL Server Optimization and Tuning Fundamentalsp. 563
Advances in Tuning for SQL Server 7.0p. 564
Why Should You Tune Your Server?p. 564
Monitoring and Establishing a Baselinep. 565
Using the SQL Server Profilerp. 572
Using the SQL Server Performance Monitorp. 577
Analyzing Datap. 579
What Options to Tunep. 581
Setting Configuration Optionsp. 596
19 Troubleshooting SQL Serverp. 599
The Troubleshooting Processp. 600
SQL Server Information Sourcesp. 602
SQL Server Error Messagesp. 607
Using the Database Consistency Checkerp. 611
Using Trace Flagsp. 624
Dealing with Corrupted Databasesp. 628
Preventive Maintenancep. 630
Other Common Problemsp. 631
Other Sources of Informationp. 633
Transact-SQL Quick Referencep. 637
New in SQL Server 7.0p. 637
Creating Database Objectsp. 639
Tablesp. 640
Renaming Objectsp. 644
Adding Columns to a Tablep. 644
Temporary Tablesp. 645
SQL Server Functionsp. 657
Programming Constructsp. 672
Cursorsp. 695
Glossaryp. 711
Indexp. 719