SQL Server 7 Administration

2 avg rating
( 1 ratings by Goodreads )
 
9780072121476: SQL Server 7 Administration

Osborne is committed to providing the highest quality books on SQL Server 7 to the market. SQL Server 7 Administration's outline has gone through a peer review by multiple authors in the Database Professional's Library. Additionally, it was tech reviewed by Lars Klander, MCSD, MCSE, MCT.In addition to ensuring quality content, key features include: Case studies: boxed text elements providing real scenarios based on the authors' consulting experience - but not containing company names. Each case study describes the type of business, number of databases running, number of users, and the situation that was solved with specific steps. On-line scripts: These are downloadable from Osborne's website and include SQL statements that can be used to build stored procedures that apply to all databases and script examples of advanced techniques that must be tweaked for specific scenarios.

"synopsis" may belong to another edition of this title.

Review:

Microsoft SQL Server 7 can provide database services for a large organization, including its Internet presence. But its appearance can be deceiving: behind the friendly user interface lurks a full-featured Structured Query Language (SQL) engine. Getting a grip on its considerable power requires a guide, and Microsoft SQL Server 7.0 Administrator's Guide makes an excellent one. The authors provide lots of background wisdom, plus scores of quick-and-dirty solutions to database-administration challenges (both common and somewhat rare). For example, they explain how to use the Transact-SQL statements TRUNCATE_ONLY and NO_LOG to free up disk space for a database that's growing faster than planned--this procedure often will buy enough time to install more disk space.

Mark Linsenbardt and Shane Stigler take a somewhat unusual approach to presenting their information, neglecting illustrations almost entirely in favor of large quantities of text. Sometimes they annotate Transact-SQL commands, explaining when and why you'd use a command string before presenting the string itself. Other times, they document entire portions of the SQL Server architecture, explaining the potential effects of manipulating various settings. They especially deserve commendation for their in-depth coverage of replication, including pedestrian Publication/Subscription setups and more adaptable script-driven arrangements. --David Wall

Topics covered: Installation, academic background on SQL Server architecture, Transact-SQL, distributed data, backups and restorations, replication, monitoring, performance tuning, and general administration tasks.

From the Back Cover:

Maintain high-performance, mission-critical SQL Server databases Install, manage, and troubleshoot SQL Server 7

From discussions of simple-machine installations to complex replication models able to handle linked machines on multiple continents, this book is filled with real-world examples and expert advice. Written by professional SQL Server administrators for professional SQL Server administrators, the book features the authors' own real-world experience and helps you address the problems you confront most often. No SQL Server DBA should be without this authoritative, hands-on resource.

  • Install SQL Server and handle unattended installations
  • Understand the construction and usage of all the system databases, including the Master, Model, MSDB, Distribution, and TempDB databases
  • Implement security measures--mapping logins, permissions, application roles, stored procedures, and views
  • Handle data storage, manipulation, and backup, including the use of DTS, new stored procedures, and Enterprise Manager wizards
  • Monitor, troubleshoot, and achieve blazing performance with various tools, including event viewer, query analyzer, SQL Profiler, Windows NT Performance Monitor, and more
  • Automate SQL Server to perform simple and complex tasks at regular intervals
  • Implement real-world data replication.

"About this title" may belong to another edition of this title.

Top Search Results from the AbeBooks Marketplace

1.

Linsenbardt, Mark A.; Stigler, M. Shane; Stigler, Shane
Published by Computing Mcgraw-Hill
ISBN 10: 0072121475 ISBN 13: 9780072121476
New PAPERBACK Quantity Available: 1
Seller
Vital Products COM LLC
(southampton, PA, U.S.A.)
Rating
[?]

Book Description Computing Mcgraw-Hill. PAPERBACK. Book Condition: New. 0072121475. Bookseller Inventory # Z0072121475ZN

More Information About This Seller | Ask Bookseller a Question

Buy New
4.79
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

2.

Linsenbardt, Mark A.; Stigler, M. Shane; Stigler, Shane
Published by Computing Mcgraw-Hill 1999-08-24 (1999)
ISBN 10: 0072121475 ISBN 13: 9780072121476
New PAPERBACK Quantity Available: 1
Seller
The Book Cellar, LLC
(Nashua, NH, U.S.A.)
Rating
[?]

Book Description Computing Mcgraw-Hill 1999-08-24, 1999. PAPERBACK. Book Condition: New. 0072121475 BRAND NEW. Over 1,000,000 satisfied customers since 1997! We ship daily M-F. Choose expedited shipping (if available) for much faster delivery. Delivery confirmation on all US orders. Bookseller Inventory # Z0072121475ZN

More Information About This Seller | Ask Bookseller a Question

Buy New
2.72
Convert Currency

Add to Basket

Shipping: 3.08
Within U.S.A.
Destination, Rates & Speeds

3.

Linsenbardt, Mark A.; Stigler, M. Shane; Stigler, Shane
Published by Computing Mcgraw-Hill
ISBN 10: 0072121475 ISBN 13: 9780072121476
New PAPERBACK Quantity Available: 1
Seller
Qwestbooks COM LLC
(Bensalem, PA, U.S.A.)
Rating
[?]

Book Description Computing Mcgraw-Hill. PAPERBACK. Book Condition: New. 0072121475. Bookseller Inventory # Z0072121475ZN

More Information About This Seller | Ask Bookseller a Question

Buy New
7.35
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

4.

Mark A. Linsenbardt, M. Shane Stigler, Shane Stigler
Published by Computing Mcgraw-Hill (1999)
ISBN 10: 0072121475 ISBN 13: 9780072121476
New Paperback Quantity Available: 1
Seller
Ergodebooks
(RICHMOND, TX, U.S.A.)
Rating
[?]

Book Description Computing Mcgraw-Hill, 1999. Paperback. Book Condition: New. Bookseller Inventory # DADAX0072121475

More Information About This Seller | Ask Bookseller a Question

Buy New
7.16
Convert Currency

Add to Basket

Shipping: 3.07
Within U.S.A.
Destination, Rates & Speeds

5.

Shane Stigler
ISBN 10: 0072121475 ISBN 13: 9780072121476
New Quantity Available: 1
Seller
Castle Rock
(Pittsford, NY, U.S.A.)
Rating
[?]

Book Description Book Condition: Brand New. Book Condition: Brand New. Bookseller Inventory # 97800721214761.0

More Information About This Seller | Ask Bookseller a Question

Buy New
10.39
Convert Currency

Add to Basket

Shipping: 3.07
Within U.S.A.
Destination, Rates & Speeds

6.

Mark A. Linsenbardt; M. Shane Stigler; Shane Stigler
Published by Computing Mcgraw-Hill (1999)
ISBN 10: 0072121475 ISBN 13: 9780072121476
New Paperback Quantity Available: 1
Seller
Irish Booksellers
(Rumford, ME, U.S.A.)
Rating
[?]

Book Description Computing Mcgraw-Hill, 1999. Paperback. Book Condition: New. book. Bookseller Inventory # 0072121475

More Information About This Seller | Ask Bookseller a Question

Buy New
19.82
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds

7.

Linsenbardt, Mark A.; Stigler, M. Shane; Stigler, Shane
Published by Computing Mcgraw-Hill 1999-08-24 (1999)
ISBN 10: 0072121475 ISBN 13: 9780072121476
New Paperback Quantity Available: 2
Seller
Ebooksweb COM LLC
(Bensalem, PA, U.S.A.)
Rating
[?]

Book Description Computing Mcgraw-Hill 1999-08-24, 1999. Paperback. Book Condition: New. 0072121475. Bookseller Inventory # Z0072121475ZN

More Information About This Seller | Ask Bookseller a Question

Buy New
25.39
Convert Currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, Rates & Speeds