Practical Microsoft SQL Server 7

With Practical Microsoft SQL Server 7 readers will learn everything they need to know about SQL Server and how to use it in a corporate setting. They will cover all the essential topics in a straight forward, no-nonsense manner. Progressing through the book they will move into: Part 1: Learning the Basics of SQL Server; Part 2: Installing and Configuring SQL Server; Part 3: Administering SQL Server; Part 4: Securing Data; Part 5: Preventing Data Loss; and Part 6: Performing Critical Administration Tasks. After completing the book, the reader will be able to implement SQL Server in their organization and perform all necessary operations.

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.

SQL Server Basics	p. 9
Introduction to SQL Server 7.0	p. 11
SQL Server Helps You to Master Business Information	p. 12
What Is SQL Server?	p. 13
A Little Background on SQL Server	p. 15
Major Features of SQL Server 7.0	p. 15
How SQL Server Is Integrated with Windows NT Server and Microsoft BackOffice	p. 22
What You Need to Know to Be a Successful SQL Server DBA	p. 25
SQL Server and Database Fundamentals	p. 35
SQL Server Fundamentals	p. 36
SQL Server Administration Fundamentals	p. 40
SQL Server Architecture Fundamentals	p. 42
Database Fundamentals	p. 49
Database Object Fundamentals	p. 51
Database Architecture Fundamentals	p. 56
What Is Transact-SQL?	p. 66
Installing and Configuring SQL Server	p. 71
Planning a SQL Server Installation	p. 73
Planning Is an Important First Step	p. 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 Data	p. 92
Plan Your SQL Server Software Requirements	p. 97
Plan Your SQL Server Hardware Requirements	p. 100
Formalizing and Carrying Out the Plan	p. 107
Installing SQL Server	p. 111
What You Need to Know Before Installing SQL Server 7.0	p. 112
Minimum Hardware and Software Requirements	p. 112
Different Ways to Install SQL Server	p. 120
SQL Server Installation and Configuration Options	p. 123
Installing SQL Server	p. 143
Post-Installation Issues	p. 151
Troubleshooting a SQL Server Installation	p. 167
How to Remove SQL Server	p. 170
Installing SQL Client Utilities	p. 171
What Are the SQL Server Management Tools?	p. 172
SQL Server Management Tools	p. 172
Choosing Online Documentation to Install on Clients	p. 174
Management Tool Hardware and Software Requirements	p. 175
Where to Install the Management Tools From	p. 176
How to Install the SQL Server Management Tools	p. 177
How to Use the Client Configuration Utility	p. 184
Troubleshooting a Management Tools Installation	p. 189
Upgrading SQL Server From 6.5 to 7.0	p. 191
Developing an Upgrade Strategy and Plan	p. 192
Upgrade Troubleshooting	p. 211
Upgrade Planning FAQ	p. 214
Administering SQL Server	p. 217
SQL Server Tools	p. 219
Using the Microsoft Management Console (MMC)	p. 220
SQL Enterprise Manager Overview	p. 222
SQL Server Setup	p. 226
SQL Server Service Manager	p. 226
SQL Server Client Configuration Utility	p. 228
SQL Server Performance Monitor	p. 229
SQL Server Profiler	p. 229
SQL Server Query Analyzer	p. 232
SQL Server Books Online	p. 234
BCP	p. 236
ISQL Utility	p. 236
osql	p. 238
makepipe and readpipe	p. 241
SQL Server Wizards	p. 243
Register Server Wizard	p. 244
Managing Databases	p. 251
Planning SQL Server Databases	p. 253
How to Delete (Drop) a SQL Server Database	p. 263
Setting SQL Server Database Options	p. 265
Files and Filegroups	p. 268
Documenting SQL Server Database Creation Steps	p. 271
Scheduling Tasks and Alerts	p. 275
SQL Server Agent Overview	p. 277
How to Manage Jobs	p. 284
Alerts and Operators	p. 291
How to Set Up SQL Server to Send Email	p. 297
Troubleshooting	p. 302
Maintaining SQL Server	p. 307
Maintaining SQL Server Over the Long Haul	p. 308
Document Your SQL Servers	p. 308
Create a Formal SQL Server Maintenance Plan	p. 311
Monitor Log Files	p. 313
Monitor Security	p. 317
Monitor User Activity	p. 325
Monitor SQL Server Performance	p. 327
Manage Current and Create New Databases	p. 330
Maintaining SQL Server Software	p. 331
Verify the Integrity of SQL Server Databases	p. 333
Maintain Database Indexes	p. 334
Backup Databases and Transaction Logs	p. 336
NT Server-Related Maintenance Tasks	p. 336
Working with Developers	p. 338
How to Use the Database Maintenance Plan Wizard	p. 338
SQL Server Maintenance Checklist	p. 352
SQL Server Security	p. 355
Introduction to SQL Security	p. 357
SQL Server Security Basics	p. 358
Planning SQL Server Security	p. 359
The SQL Server Security Architecture	p. 360
What Is a Security Mode?	p. 366
SQL Server Mixed Authentication Security Mode	p. 367
Using the Windows NT Authentication Security Mode	p. 371
Managing Users	p. 375
How Do Users Gain Access to SQL Server?	p. 376
Introduction to SQL Server Accounts	p. 376
How to Create and Manage Login IDs	p. 378
How to Create and Manage Database User IDs	p. 382
How to Manage SQL Server Roles	p. 383
How to Manage Users Using SQL Enterprise Manager	p. 387
How to Use the SQL Server Create Login Wizard to Manage SQL Server Accounts	p. 388
How to Manually Create, Modify, and Delete SQL Server Login IDs and Database User IDs	p. 393
How to Create and Configure Login IDs	p. 404
Assigning User Permissions	p. 419
Permissions Determine Who Can Access Data	p. 420
Statement Permissions	p. 422
Object Permissions	p. 423
Implied Permissions	p. 424
Understanding Permission Precedence	p. 428
Using Views and Stored Procedures to Enforce Security	p. 431
Understanding Ownership Chains	p. 432
Best Practices for Managing Permissions	p. 435
How to Display Information on Permissions	p. 436
How to Grant and Revoke Permission	p. 443
How to Grant and Revoke Statement Permissions Using SQL Enterprise Manager	p. 443
How to Grant and Revoke Object Permissions Using SQL Enterprise Manager	p. 446
Preventing Data Loss	p. 451
Backing Up Databases	p. 453
Ways to Prevent Data Loss	p. 455
Establishing a Backup Strategy	p. 466
Implementing SQL Server Backups	p. 476
Restoring SQL Data	p. 483
Restore Overview	p. 484
How to Restore Data	p. 496
How to Restore System Databases	p. 501
Advanced SQL Server Administration	p. 507
Importing, Exporting, and Distributing Data	p. 509
Data Transformation Service (DTS)	p. 510
Bulk Copy Program (BCP)	p. 520
Bulk Insert	p. 532
Improving Load Performance	p. 534
Working with Batch Files	p. 535
Distributing Databases on Removable Media	p. 537
Setting Up and Configuring Data Replication	p. 541
SQL Server Replication Overview	p. 542
Publications and Articles	p. 544
SQL Server Replication Architecture	p. 547
How to Use Wizards to Configure Replication	p. 553
Setting Up Replication Using the SQL Enterprise Manager	p. 553
SQL Server Optimization and Tuning Fundamentals	p. 563
Advances in Tuning for SQL Server 7.0	p. 564
Why Should You Tune Your Server?	p. 564
Monitoring and Establishing a Baseline	p. 565
Using the SQL Server Profiler	p. 572
Using the SQL Server Performance Monitor	p. 577
Analyzing Data	p. 579
What Options to Tune	p. 581
Setting Configuration Options	p. 596
Troubleshooting SQL Server	p. 599
The Troubleshooting Process	p. 600
SQL Server Information Sources	p. 602
SQL Server Error Messages	p. 607
Using the Database Consistency Checker	p. 611
Using Trace Flags	p. 624
Dealing with Corrupted Databases	p. 628
Preventive Maintenance	p. 630
Other Common Problems	p. 631
Other Sources of Information	p. 633
Transact-SQL Quick Reference	p. 637
New in SQL Server 7.0	p. 637
Creating Database Objects	p. 639
Tables	p. 640
Renaming Objects	p. 644
Adding Columns to a Table	p. 644
Temporary Tables	p. 645
SQL Server Functions	p. 657
Programming Constructs	p. 672
Cursors	p. 695
Glossary	p. 711
Index	p. 719
Table of Contents provided by Syndetics. All Rights Reserved.

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.