Microsoft SQL Server 7.0 administrator's pocket consultant / William R. Stanek.

By:

Stanek, William R

Material type: Text

TextPublication details: Redmond, Wash. : Microsoft Press, c1999.Description: xxii, 364 p. : ill. ; 21 cmISBN:

0735605963

Subject(s):

DDC classification:

005.7585 STA

Holdings
Item type	Current library	Call number	Copy number	Status	Date due	Barcode
Standard Loan	Moylish Library Main Collection	005.7585 STA (Browse shelf(Opens below))	1	Available		39002000202672

Browsing Moylish Library shelves, Shelving location: Main Collection Close shelf browser (Hides shelf browser)

Previous								Next
Previous	005.7565 VIE Building Microsoft Access applications /	005.758 HOM Distributed data applications with ASP.NET /	005.7585 HER SQL queries for mere mortals : a hands-on guide to data manipulation in SQL /	005.7585 STA Microsoft SQL Server 7.0 administrator's pocket consultant /	005.8 BAR Invitation to cryptology /	005.8 BER Internet security for business Terry Bernstein ... [et al.]	005.8 CAR Windows forensic analysis DVD toolkit 2E /	Next

Enhanced descriptions from Syndetics:

Ideal at the desk or as a portable reference for the office, this book provides database administrators with hands-on reference needed to solve problems with a concise, direct approach, and delivers quick reference support for infrequently used steps and hands-on tasks.

Includes index.

Table of contents provided by Syndetics

Acknowledgments (p. xvii)
Introduction (p. xix)
Part 1 Microsoft SQL Server 7.0 Administration Fundamentals
1 Microsoft SQL Server 7.0 Administration Overview (p. 3)
SQL Server 7.0 and Your Hardware (p. 4)
SQL Server 7.0 and SQL Server Desktop (p. 5)
SQL Server and Windows (p. 7)
Services for SQL Server (p. 7)
Taskbar Extras for SQL Server (p. 8)
Authentication Enhancements (p. 8)
Service Accounts (p. 8)
SQL Server Administration Tools (p. 9)
Graphical Administration Tools (p. 9)
Administration Wizards and the Taskpad (p. 10)
Command-Line Tools (p. 12)
2 Configuring and Tuning Microsoft SQL Server 7.0 (p. 17)
Reconfiguring SQL Server Setup (p. 17)
Changing Character Sets, Sort Order, or Unicode Collation (p. 18)
Restoring the SQL Server Registry (p. 19)
Adding Components (p. 20)
Configuring SQL Server with the Properties Dialog Box (p. 21)
Determining System and Server Information (p. 22)
Configuring Startup (p. 23)
Setting Startup Parameters (p. 23)
Setting the Startup Service Account (p. 25)
Authentication and Auditing (p. 26)
Tuning Memory Usage (p. 27)
Configuring Processors and Parallel Processing (p. 31)
Configuring Threading, Priority, and Fibers (p. 33)
Configuring User and Remote Connections (p. 34)
Server Settings (p. 39)
Database Settings (p. 43)
Configuring SQL Server with Stored Procedures (p. 46)
Starting Query Analyzer (p. 46)
Changing Settings with sp_configure (p. 47)
Configuration Parameters (p. 49)
Recovering from a Bad Configuration (p. 54)
Part II Microsoft SQL Server 7.0 Administration
3 Managing the Enterprise (p. 59)
Starting, Stopping, and Pausing SQL Server (p. 59)
Managing SQL Server Service with Service Manager (p. 59)
Managing SQL Server Service from the Command Line (p. 60)
Managing the SQL Server Command-Line Executable (p. 61)
Using SQL Server Enterprise Manager (p. 61)
Getting Started with Enterprise Manager (p. 61)
Managing SQL Server Groups (p. 62)
Creating a Server Group (p. 62)
Deleting a Server Group (p. 63)
Adding SQL Servers to a Group (p. 63)
Managing Servers (p. 63)
Registering a Server with a Wizard (p. 64)
Registering a Server Manually (p. 65)
Editing Registration Properties (p. 67)
Moving a Server to a New Group (p. 67)
Deleting a Server Registration (p. 67)
Connecting to a Server (p. 67)
Disconnecting from a Server (p. 68)
Starting, Stopping, and Configuring SQLServerAgent (p. 68)
Starting, Stopping, and Configuring the Microsoft Distributed Transaction Coordinator (p. 68)
Installing and Configuring Full-Text Search (p. 69)
Using Full-Text Searches (p. 69)
Starting, Stopping, and Configuring the Microsoft Search Service (p. 70)
Managing Catalogs and Full-Text Searches (p. 70)
Cleaning Up Old Catalogs (p. 71)
Managing SQL Mail and SQLServerAgent Mail (p. 72)
Testing the Mail Installation (p. 73)
Configuring SQL Mail (p. 73)
Configuring SQLServerAgent Mail (p. 74)
Managing Server Activity (p. 74)
Examining Process Information (p. 75)
Locks by Process ID and Object (p. 76)
Troubleshooting Deadlocks and Blocking Connections (p. 78)
Tracking Command Execution in SQL Server (p. 79)
Sending Messages to Users Based on Connections (p. 80)
Killing Server Processes (p. 81)
4 Core Database Administration (p. 83)
Database Files and Logs (p. 83)
Database Administration Basics (p. 84)
Viewing Database Information in Enterprise Manager (p. 85)
Viewing Database Information Using SQL (p. 86)
Checking System and Sample Databases (p. 87)
Examining Database Objects (p. 88)
Creating Databases (p. 88)
Creating Databases in Enterprise Manager (p. 88)
Creating Databases Using SQL (p. 92)
Setting Database Options (p. 93)
Setting Database Options in Enterprise Manager (p. 93)
Database Options for Enterprise Manager and Transact-SQL (p. 94)
Viewing, Changing, and Overriding Database Options (p. 97)
Managing Database and Log Size (p. 98)
Configuring SQL Server to Automatically Manage File Size (p. 98)
Expanding Databases and Logs Manually (p. 98)
Compacting and Shrinking a Database Manually (p. 99)
Manipulating Databases (p. 101)
Renaming a Database (p. 101)
Dropping and Deleting a Database (p. 102)
Attaching and Detaching Databases (p. 103)
Copying Databases with Attach (p. 104)
Moving Databases with Detach and Attach (p. 105)
Moving a Database to Another Server (p. 105)
Altering a Database (p. 106)
Tips and Techniques (p. 108)
Moving and Resizing tempdb (p. 108)
Creating Secondary Data and Log Files (p. 108)
Preventing Trasaction Log Errors (p. 109)
Resolving a Filegroup Is Full Error (p. 109)
Creating a New Database Template (p. 110)
5 Microsoft SQL Server 7.0 Security (p. 111)
SQL Server 7.0 Security (p. 111)
SQL Server 7.0 Authentication Modes (p. 112)
Sever Logins (p. 113)
Permissions (p. 115)
Roles (p. 117)
Managing Server Logins (p. 119)
Viewing and Editing Existing Logins (p. 119)
Creating Logins (p. 121)
Granting or Denying Server Access (p. 123)
Removing Logins (p. 124)
Changing Passwords (p. 124)
Configuring Server Roles (p. 125)
Assigning Roles by Login (p. 125)
Assigning Roles to Multiple Logins (p. 126)
Controlling Database Access and Administration (p. 127)
Assigning Access and Roles by Login (p. 127)
Assigning Roles for Multiple Logins (p. 128)
Creating Standard Database Roles (p. 129)
Creating Application Database Roles (p. 130)
Revoking Access Rights and Roles by Login (p. 131)
Deleting User-Defined Roles (p. 131)
Transact-SQL Commands for Managing Access and Roles (p. 132)
Managing Database Permissions (p. 132)
Assigning Database Permissions for Statements (p. 133)
Object Permissions by Login (p. 135)
Object Permissions for Multiple Logins (p. 136)
Part III Microsoft SQL Server 7.0 Data Administration
6 Database Backup and Recovery (p. 141)
Creating a Backup and Recovery Plan (p. 141)
Selecting Backup Devices and Media (p. 143)
Creating a Backup Device (p. 147)
Performing Backups (p. 148)
Creating Backups in Enterprise Manager (p. 148)
Using Striped Backups with Multiple Devices (p. 152)
Transact-SQL Backup (p. 153)
Performing Transaction Log Backups (p. 156)
Restoring a Database (p. 157)
Database Corruption and Problem Resolution (p. 158)
Restoring a Database from a Normal Backup (p. 159)
Restoring Files and Filegroups (p. 163)
Restoring a Database from a Device (p. 165)
Restoring a Database to a Different Location (p. 167)
Creating a Standby Server (p. 168)
Transact-SQL Restore (p. 169)
Restoring the Master Database (p. 171)
7 Importing and Exporting Data (p. 173)
Understanding DTS (p. 173)
DTS and Database Drivers (p. 174)
DTS Wizards (p. 174)
DTS Packages (p. 174)
Other DTS Tools (p. 175)
Creating Packages with the DTS Wizards (p. 175)
Stage 1 Source and Destination Configuration (p. 176)
Stage 2 Copy, Query, or Transfer (p. 182)
Stage 3 Formatting and Transformation (p. 187)
Stage 4 Save, Schedule, and Replicate (p. 190)
Working with DTS Packages (p. 192)
Examining, Running, and Scheduling Packages (p. 192)
Managing Packages from the Command Line (p. 193)
Understanding BCP (p. 194)
BCP Basics (p. 194)
BCP Syntax (p. 195)
BCP Permissions and Modes (p. 197)
Importing Data with BCP (p. 198)
Exporting Data with BCP (p. 200)
BCP Scripts (p. 200)
Bulk Insert (p. 201)
8 Distributed Data and Remote Servers (p. 203)
Working with Remote Servers (p. 203)
Setting Up Remote Servers in Enterprise Manager (p. 204)
Setting Up Remote Servers Using Stored Procedures (p. 206)
Executing Remote Stored Procedures (p. 208)
Working with Linked Servers and Distributed Data (p. 208)
Using Distributed Queries (p. 208)
Using Distributed Transactions (p. 209)
Permitted Commands (p. 210)
Managing Linked Servers (p. 211)
Adding Linked Servers (p. 211)
Configuring Security for Linked Servers (p. 215)
Deleting Linked Servers (p. 217)
Using MS DTC (p. 218)
Running the MSDTC Service (p. 218)
Administering the Transaction Manager (p. 218)
9 Data Replication (p. 225)
An Overview of Replication (p. 225)
Replication Components (p. 226)
Replication Agents (p. 227)
Replication Variants (p. 227)
Planning for Replication (p. 229)
Replication Models (p. 229)
Preliminary Replication Tasks (p. 230)
Distributor Administration (p. 231)
Setting Up a New Distributor (p. 231)
Creating Distribution Databases (p. 236)
Enabling Publishers, Publication Databases, and Subscribers (p. 237)
Deleting Distribution Databases (p. 238)
Disabling Publishing and Distribution (p. 238)
Creating and Managing Publications (p. 239)
Creating Publications (p. 239)
Updating a Publication (p. 245)
Controlling Subscription Access to a Publication (p. 245)
Deleting a Publication (p. 246)
Subscribing to a Publication (p. 246)
Creating Pull Subscriptions (p. 247)
Managing Pull Subscriptions (p. 248)
Creating Push Subscriptions (p. 249)
Managing Push Subscriptions (p. 250)
Configuring Replication Agents (p. 250)
Setting Agent Profiles (p. 251)
Setting Agent Properties (p. 251)
Part IV Performance, Optimization, and Maintenance
10 Monitoring and Profiling Microsoft SQL Server 7.0 (p. 255)
Monitoring Server Performance and Activity (p. 255)
Why Monitor SQL Server? (p. 255)
Getting Ready to Monitor (p. 256)
Monitoring Tools and Resources (p. 256)
Working with Server Logs (p. 258)
Examining the SQL Server Error Logs (p. 258)
Examining the Windows NT Application Log (p. 259)
Understanding Error Messages (p. 261)
Monitoring SQL Server Performance (p. 261)
Starting Performance Monitor (p. 262)
Choosing Counters to Monitor (p. 262)
Creating and Managing Performance Monitor Logs (p. 264)
Replaying Performance Monitor Logs (p. 266)
Configuring Alerts for Performance Counters (p. 267)
Solving Performance Problems with Profiler (p. 269)
Using Profiler (p. 269)
Creating New Traces (p. 270)
Using the Create Trace Wizard (p. 274)
Working with Traces (p. 275)
Saving a Trace (p. 276)
Replaying Traces (p. 277)
11 Creating Tables and Indexes (p. 281)
Defining Tables (p. 282)
Using Native Data Types (p. 284)
Using Fixed-Length and Variable-Length Fields (p. 286)
Using User-Defined Data Types (p. 287)
Allowing and Disallowing Nulls (p. 289)
Default Values (p. 289)
Using Identities and Globally Unique Identifiers (p. 289)
Working with Tables (p. 292)
Viewing Table Row and Size Information (p. 292)
Displaying Table Properties and Permissions (p. 293)
Copying Tables (p. 293)
Renaming and Deleting Tables (p. 293)
Adding and Removing Columns in a Table (p. 294)
Scripting Tables (p. 294)
Using Views (p. 295)
Creating Views (p. 295)
Using Updateable Views (p. 298)
Managing Views (p. 298)
Creating and Managing Indexes (p. 298)
Understanding Indexes (p. 298)
Clustered and Nonclustered Indexes (p. 299)
What Columns Should Be Indexed? (p. 300)
Viewing Indexes (p. 301)
Creating Indexes (p. 301)
Managing Indexes (p. 303)
Using the Index Tuning Wizard (p. 304)
Column Constraints and Rules (p. 307)
Using Constraints (p. 308)
Creating Rules (p. 310)
12 Database Automation and Maintenance (p. 313)
Using SQL Server Agent (p. 313)
Accessing Alerts, Operators, and Jobs (p. 313)
Configuring the SQL Server Agent Service (p. 314)
Configuring the SQL Server Agent (p. 315)
Viewing SQL Server Agent Logs (p. 316)
Managing Alerts (p. 316)
Default Alerts (p. 316)
Creating Error Message Alerts (p. 317)
Creating Performance Condition Alerts (p. 318)
Handling Alert Responses (p. 319)
Deleting, Enabling, and Disabling Alerts (p. 320)
Managing Operators (p. 321)
Registering Operators (p. 321)
Deleting and Disabling Notification for Operators (p. 322)
Configuring a Fail-Safe Operator (p. 323)
Scheduling Jobs (p. 323)
Creating Jobs (p. 323)
Assigning or Changing Job Definitions (p. 324)
Setting Steps to Execute (p. 325)
Configuring Job Schedules (p. 328)
Handling Notification Messages (p. 330)
Managing Existing Jobs (p. 331)
Managing Job Categories (p. 332)
Multiserver Administration (p. 333)
Event Forwarding (p. 333)
Multiserver Job Scheduling (p. 334)
Database Maintenance (p. 336)
Database Maintenance Checklist (p. 336)
Using Maintenance Plans (p. 337)
Checking and Maintaining Database Integrity (p. 343)
Index (p. 347)

Author notes provided by Syndetics

Author William Stanek was born in Burlington Wisconsin. He enlisted in the U.S. Air Force in 1985, served in the Persian Gulf War, earned 29 decorations during his career and retired in 1996. He received both his bachelor's degree and his master's degree from Hawaii Pacific University. He writes nonfiction books under the name William Stanek and fiction books under the name Robert Stanek.

(Bowker Author Biography)