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. |