Cover image for The SQL Server 7.0 handbook : a guide to Microsoft database computing
Title:
The SQL Server 7.0 handbook : a guide to Microsoft database computing
Author:
England, Ken, 1955-
Personal Author:
Publication Information:
Boston : Digital Press, [1999]

©1999
Physical Description:
xi, 451 pages : illustrations ; 24 cm
General Note:
Includes index.
Language:
English
Contents:
SQL server architecture -- Installing and upgrading to SQL server 7.0 -- Creating and managing databases -- Defining database objects -- Manipulating database data -- Advanced database manipulation -- Data integrity -- Database administration -- Security -- Indexing, the query optimizer, and locking -- Distributing data -- Transaction server and COM -- Data warehousing with Microsoft SQL server -- Developing applications with Microsoft SQL server 7.0.
Title Subject:
Subject Term:
Added Author:
ISBN:
9781555582012
Format :
Book

Available:*

Library
Call Number
Material Type
Home Location
Status
Central Library QA76.9.D3 E64 1999 Adult Non-Fiction Central Closed Stacks
Searching...

On Order

Summary

Summary

Let the experts help you work smarter with the new SQL Server.

The SQL Server 7.0 Handbook concisely and authoritatively explains how to design, implement, administer, and tune Microsoft's powerful new database management system for Windows NT. Readers will learn all major SQL Server 7.0 capabilities, especially its new scalability, decision support, performance, and replication features. The authors, recognized SQL Server authorities, including a former SQL Server product manager, explain how to use the database with other critical Microsoft data management technologies and products, including Microsoft Transaction Server and Active Data Objects (ADO).

No other book will enable database administrators, designers, programmers, and IT managers to master SQL Server 7.0 more thoroughly or quickly. Computer professionals studying for Microsoft Certified Professional (MCSE) qualifications will find this book essential reading.


Learn major new SQL Server 7.0 scalability and replication features
Optimize and secure SQL Server 7.0
Develop data warehouses with SQL Server 7.0 decision support capabilities and OLAP Services


Author Notes

Ken England is President and Founder of Database Technologies, a database consultancy, product evaluation, and training firm. He is also a Microsoft Certified Systems Engineer and a Microsoft Certified Trainer. Ken England has written numerous successful books on database technologies, including the best-selling SQL Server Handbook and SQL Server 6.5 Performance Optimization and Tuning Handbook (both from Digital Press).
Nigel Stanley is Technical Director of ICS Solutions, LTD (www.ics-solutions.co.uk), a consulting and development firm specializing in Microsoft database products. Nigel Stanley was formerly European database product manager for Microsoft and co-authored the SQL Server Handbook (Digital Press).


Table of Contents

Prefacep. ix
1 SQL Server Architecturep. 1
1.1 Introductionp. 1
1.2 Major Changes to SQL Server Version 7.xp. 1
1.3 Overview of Windows NTp. 3
1.4 SQL Server Architecturep. 5
1.5 SQL Server System Databasesp. 7
1.6 SQL Server Filesp. 9
1.7 Pages and Extentsp. 10
1.8 Space Managementp. 10
1.9 Text and Image Datap. 11
2 Installing and Upgrading to SQL Server 7.0p. 13
2.1 Unattended Installationp. 15
2.2 Pre-Upgrade Considerationsp. 15
2.3 How to Run the Database Estimation Utilityp. 16
2.4 Summary of Pre-Upgrade Actionsp. 16
2.5 Hardware and Software Needed for the Upgradep. 17
2.6 Upgrade Choicesp. 17
2.7 Upgrade Verificationp. 19
2.8 SQL Server 7.0 Database Configurationp. 19
2.9 Side-by-Side Upgradesp. 21
2.10 Computer-to-Computer Upgradesp. 21
2.12 Log Files Created during Upgradep. 22
2.11 SQL Server Compatibilityp. 22
2.13 Switching between SQL Server Versionsp. 27
2.14 Deinstalling Version 6.xp. 28
3 Creating and Managing Databasesp. 29
3.1 Introductionp. 29
3.2 The Structure of a Databasep. 29
3.3 Creating Databasesp. 32
3.4 Increasing the Size of a Databasep. 37
3.5 Decreasing the Size of a Databasep. 39
3.6 Modifying Filegroup Propertiesp. 44
3.7 Setting Database Optionsp. 44
3.8 Displaying Information about Databasesp. 47
3.9 Renaming and Dropping a Databasep. 49
4 Defining Database Objectsp. 51
4.1 Introductionp. 51
4.2 Methods for Creating SQL Server Objectsp. 51
4.3 Creating Tables, User-Defined Data Types and Viewsp. 56
4.4 User-Defined Data Typesp. 91
4.5 The Pubs Example Databasep. 94
5 Manipulating Database Datap. 97
5.1 Introductionp. 97
5.2 Basic Relational Termsp. 98
5.3 The Query Analyzerp. 99
5.4 Querying and Sorting Datap. 102
5.5 Adding Data to a Tablep. 141
6 Advanced Database Manipulationp. 151
6.1 Introductionp. 151
6.2 Control-of-Flowp. 151
6.3 Cursorsp. 161
6.4 Stored Proceduresp. 167
6.5 System-Stored Proceduresp. 178
6.6 Extended Stored Proceduresp. 180
7 Data Integrityp. 183
7.1 Introductionp. 183
7.2 Primary Key Constraintsp. 185
7.3 Foreign Key Constraintsp. 189
7.4 Unique Key Constraintsp. 193
7.5 Check Constraintsp. 196
7.6 Default Definitionsp. 199
7.7 Triggersp. 201
7.8 Transactionsp. 215
8 Database Administrationp. 221
8.1 Introductionp. 221
8.2 Database Backupsp. 221
8.3 Management of Alerts, Jobs, and Operatorsp. 232
8.4 SQL Server Web Assistantp. 239
8.5 The SQL Server Profilerp. 242
8.6 The SQL Server Profiler Architecturep. 242
8.7 Tracing Event Classesp. 243
9 Securityp. 249
9.1 Introductionp. 249
9.2 Architecturep. 250
9.3 Gaining Access to SQL Serverp. 252
9.4 Allowing Access to Databasesp. 261
9.5 Disallowing Access to Databasesp. 263
9.6 Database and Object Ownershipp. 264
9.7 User-Defined Database Rolesp. 265
9.8 Fixed-Database Rolesp. 271
9.9 Fixed-Server Rolesp. 273
9.10 Application Rolesp. 276
9.11 Permissionsp. 280
10 Indexing, the Query Optimizer, and Lockingp. 287
10.1 Introductionp. 287
10.2 Indexed Accessp. 287
10.3 The Query Optimizerp. 301
10.4 SQL Server Lockingp. 314
11 Distributing Datap. 327
11.1 Introductionp. 327
11.2 Why Distribute Data?p. 327
11.3 Heterogeneous Distributed Queriesp. 329
11.4 Data Replication with SQL Server 7.0p. 337
12 Transaction Server and COMp. 349
12.1 Introductionp. 349
12.2 The Object-Oriented Paradigmp. 349
12.3 Componentsp. 351
12.4 Key COM Elementsp. 354
12.5 COM+p. 356
12.6 Microsoft Transaction Serverp. 357
12.7 Microsoft Message Queue (MSMQ)p. 363
12.8 Distributed Transaction Coordinatorp. 364
13 Data Warehousing with Microsoft SQL Serverp. 367
13.1 Introductionp. 367
13.2 Microsoft SQL Server and the Data Warehousep. 367
13.3 Microsoft OLAP Servicesp. 377
13.4 Cube Partitionsp. 384
14 Developing Applications with Microsoft SQL Server 7.0p. 391
14.1 Introductionp. 391
14.2 Distributed interNet Architecture (DNA)p. 391
14.3 ODBC, OLEDB, DAO, RDO or ADO?p. 392
14.4 ADO Object Modelp. 396
14.5 Visual Interdevp. 398
14.6 Visual Basicp. 399
14.7 VBA Architecturep. 399
14.8 Objects in Visual Basic for Applicationsp. 403
14.9 SQL Server Distributed Management Objects (SQL-DMO)p. 404
14.10 Migrating from Microsoft Access to SQL Server--"Upsizing"p. 406
14.11 Optimizing an Access and SQL Server Solutionp. 413
Glossaryp. 417
Indexp. 435

Google Preview