Microsoft SQL Server: What Database Administrators Need to Know

Be the first to write a review

Overview

Now, in Microsoft SQL Server: What Database Administrators Need to Know, software consultant Jeffry L. Byrne cuts through the fog surrounding database administration and shows you - with clear, step-by-step examples - how to use logical structures effectively, retain data integrity, maintain data consistency and concurrency, manage your available storage space, optimize your performance, keep your database secure, backup and restore your database, and publish database information on the World Wide Web. By ...
See more details below
Available through our Marketplace sellers.
See All Options
Other sellers (Paperback)
  • All (9) from $1.99   
  • New (1) from $39.49   
  • Used (8) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$39.49
Books Revisited
Seller since Tue Oct 07 09:35:53 EDT 2014

Feedback rating:

(294)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

New
Brand New Item.

Ships from: Chatham, NJ

Usually ships in 1-2 business days

  • •Canadian
  • •International
  • •Standard, 48 States
  • •Standard (AK, HI)
  • •Express, 48 States
  • •Express (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

More About This Book

Overview

Now, in Microsoft SQL Server: What Database Administrators Need to Know, software consultant Jeffry L. Byrne cuts through the fog surrounding database administration and shows you - with clear, step-by-step examples - how to use logical structures effectively, retain data integrity, maintain data consistency and concurrency, manage your available storage space, optimize your performance, keep your database secure, backup and restore your database, and publish database information on the World Wide Web. By following the clear, concise methods and procedures outlined in this book, you will learn how to set up and administer your own Microsoft SQL Server 6.5 database. But - even better - you'll learn how to optimize your database for speed and efficiency and how to keep your database safe. Microsoft SQL Server: What Database Administrators Need to Know also includes hints and techniques to use with the latest release of Microsoft SQL Server - all in an easy-to-follow illustrated format.
Read More Show Less

Product Details

  • ISBN-13: 9780134954097
  • Publisher: Prentice Hall Professional Technical Reference
  • Publication date: 12/28/1996
  • Pages: 341
  • Product dimensions: 7.06 (w) x 9.27 (h) x 1.03 (d)

Table of Contents



1. An Overview of Microsoft SQL Server.

Client/Server and Microsoft SQL Server. Why use SQL Applications? Multiprocessing versus Multithreaded. Networking. Summary.

2. What is SQL?

The Relational Database. SQL Commands. Commonly Used Commands. Transactions and SQL. Summary.

3. Logical Structures.

Devices. Database Objects. Database Sizing. System Catalog. Summary.

4. Microsoft SQL Server Structures.

Server Architecture. Processes. Files. Summary.

5. What Is Data Integrity?

Entity Integrity. Domain Integrity. Referential Integrity. User- defined Integrity. Summary.

6. Data Consistency and Concurrency. Statements and Transactions. Using Locks for Consistency. Summary.

7. Startup and Shutdown.

Starting Microsoft SQL Server. Options for Startup. Shutting Down Microsoft SQL Server. Summary.

8. Managing Database Space.

Planning Database Space Requirements. Expanding a Database. Shrinking a Database. Dropping Database Devices. Summary.

9. Optimizing Performance.

Optimizing Memory Usage. Optimizing Disk Performance. Using Segments. The Multithreaded Server. Optimizing Queries. Dropping Databases. Summary.

10. Security.

Identification and Authentication. The Role of the System. Administrator. Summary.

11. Backups and Disaster Recovery.

Types of Failures. Backup and Recovery. Restoring a Database. Rebuilding a Lost Device. Heavy Duty Protection--Mirrors and RAID. Using Removable Media. Summary.

12. Distributed Transactions, Replication, Publishing, and Subscribing Distributed Databases.

Two-phase Commit. Summary.

Index.

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)
    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)