| Foreword | p. xvii |
| Acknowledgments | p. xix |
| Introduction | p. xxi |
| Understanding SQL Server | p. 1 |
| Getting Started (Enter the World of Relational Databases) | p. 3 |
| What is a Relational Database? | p. 4 |
| Introduction to a Database Management System (DBMS) | p. 5 |
| Different Computing Models | p. 7 |
| SQL Server 7.0 | p. 10 |
| Installing MS SQL Server | p. 17 |
| Hardware/Software Requirements | p. 18 |
| SQL Server Licensing Modes | p. 20 |
| SQL Server Database Files | p. 21 |
| Database File Groups | p. 22 |
| Installing SQL Server using SMS | p. 23 |
| Unattended Installation | p. 24 |
| Backward-Compatibility Modes | p. 24 |
| Creating Windows NT Accounts for SQL Server and SQL Server Agent | p. 25 |
| SQL Server Directory Structure | p. 27 |
| Restoring the SQL Server Registry Entries | p. 28 |
| SQL Server Installation Modes | p. 29 |
| SQL Server Step-by-Step Installation | p. 30 |
| Verifying Installation | p. 39 |
| Starting SQL Server Services | p. 41 |
| Hiding SQL Server on a Network | p. 41 |
| Using MS SQL Server Client Tools and Utilities | p. 43 |
| Client Network Utility | p. 44 |
| Server Network Library Configuration | p. 46 |
| Microsoft Management Console | p. 48 |
| 1 Enterprise Manager (Microsoft Management Console) | p. 49 |
| SQL Server Query Analyzer | p. 50 |
| SQL Server Profiler | p. 52 |
| SQL Server Agent | p. 54 |
| SQL Server Service Manager | p. 56 |
| Rebuilding System Databases | p. 57 |
| SQL Performance Monitor | p. 58 |
| SQL Mail | p. 60 |
| MS DTC | p. 63 |
| Wizards | p. 64 |
| SQL Server Books Online | p. 66 |
| Transact SQL | p. 69 |
| Database Objects | p. 70 |
| Data Types | p. 73 |
| Accessing Data | p. 76 |
| Modifying Data | p. 100 |
| Managing Objects | p. 102 |
| Subquery | p. 111 |
| SQL Server Internal Functions | p. 112 |
| Distributed Queries | p. 115 |
| Dynamic SQL | p. 119 |
| Administering SQL Server | p. 121 |
| Database Administration | p. 123 |
| System Catalogs and Processes | p. 124 |
| Creating a Database | p. 132 |
| Backup and Restore Strategies | p. 140 |
| Managing Jobs and Alerts and Operator | p. 151 |
| Multiserver Administration | p. 158 |
| Database Maintenance | p. 161 |
| SQL Server Physical Storage Structure | p. 162 |
| Database Consistency Checks | p. 165 |
| Recompiling Stored Procedures | p. 178 |
| Setting Up Failover Support | p. 179 |
| Data Importing/Exporting Techniques | p. 187 |
| Database Security | p. 215 |
| Securing Databases--A Basic Approach | p. 216 |
| Windows NT Security Architecture | p. 217 |
| Active Directory | p. 219 |
| Understanding "Role-Based" Security | p. 220 |
| SQL Server Security Model | p. 227 |
| Creating Views and Stored Procedures to Implement Security | p. 233 |
| SQL Server Security Stored Procedures and Commands | p. 235 |
| Establishing Encrypted SQL Server Connections Using Multiprotocol Net-Library | p. 237 |
| Managing Security with Linked Servers | p. 239 |
| Security Setup on Windows 95/98 SQL Server 7 Configurations | p. 242 |
| SQL Server Performance Optimization | p. 247 |
| Factors Contributing to Performance Optimization | p. 248 |
| Monitoring Performance | p. 278 |
| Transaction Management and Locking | p. 291 |
| What Are Transactions? | p. 292 |
| Locking and Concurrency Control | p. 294 |
| Using Transactions | p. 303 |
| Distributed transactions | p. 310 |
| Deadlocks | p. 315 |
| Replication | p. 323 |
| What Is Replication? | p. 324 |
| Publication/Subscriber Model | p. 326 |
| Replication Components | p. 326 |
| Replication Types | p. 330 |
| Planning and Implementing Replication | p. 339 |
| Configuring Publishing | p. 345 |
| Setting Snapshot Publication | p. 346 |
| Setting up Transactional Publication | p. 350 |
| Setting Up Merge Publication | p. 353 |
| Using Enterprise Manager to Set Up a Publication | p. 355 |
| Setting Up Subscriptions | p. 355 |
| Monitoring Replication | p. 357 |
| Replicating Heterogeneous Databases | p. 361 |
| Disabling Publishing and Distribution | p. 362 |
| Developing Applications With SQL Server | p. 363 |
| Writing Stored Procedures and Triggers | p. 365 |
| Creating Stored Procedures | p. 366 |
| Remote Procedure Calls | p. 386 |
| Triggers | p. 387 |
| Delayed Name Resolution | p. 394 |
| Building Applications with SQL Server | p. 397 |
| Introduction | p. 398 |
| COM and DCOM | p. 399 |
| Client Server Communication Architecture | p. 399 |
| Tiered Architecture | p. 414 |
| Microsoft Transaction Server | p. 416 |
| Building Data Warehousing Applications | p. 417 |
| Microsoft Repository | p. 419 |
| SQL Server and the Web | p. 423 |
| Introduction | p. 424 |
| Electronic Transactions and Security | p. 427 |
| SQL Server Internet Data Access | p. 429 |
| SQL Server Licensing Issues for Web Clients | p. 436 |
| Case Studies | p. 437 |
| Microsoft OLAP Server and Data Warehousing | p. 441 |
| Introduction | p. 442 |
| Building an OLAP Application | p. 447 |
| Microsoft Data Warehousing Framework | p. 456 |
| Microsoft OLAP Server | p. 457 |
| OLAP Server Architecture | p. 459 |
| Performance and Scalability | p. 460 |
| Performance and Scalability | p. 461 |
| Pivot Table Service | p. 461 |
| Creating Cubes Using OLAP Manager | p. 462 |
| Building a Cube Using the Editor | p. 466 |
| Partitioning Cubes | p. 472 |
| Partition Wizard | p. 473 |
| Virtual Cubes | p. 473 |
| Managing Roles | p. 474 |
| Data Explosion for OLAP Server | p. 475 |
| Usage Analysis Wizard | p. 476 |
| Usage Based Optimization Wizard | p. 479 |
| Version Upgrade | p. 484 |
| Backward Compatibility Issues | p. 495 |
| Index | p. 501 |
| Table of Contents provided by Syndetics. All Rights Reserved. |