MS SQL Server 7 Unleashed

MS SQL Server 7 Unleashed

Other Format(Book & CD-ROM)

$49.99

Product Details

ISBN-13: 9780672312274
Publisher: Sams
Publication date: 05/21/1999
Series: Unleashed Series
Edition description: Book & CD-ROM
Pages: 1100
Product dimensions: 7.46(w) x 9.13(h) x 2.17(d)

Table of Contents

I.

1. Evolution of the Client/Server Environment.
2. Microsoft SQL Server and the Windows NT Enterprise.

II. INSTALLATION AND UPGRADE.

3. SQL Server Installation/Repository/06723/0672312271/conversion/html/0672312271/element_004.html/Repository/06723/0672312271/conversion/html/0672312271/element_004.html
4. Client Istallation.
5. Upgrading from Previous Versions.
6. Maintaining Backward Compatibility.

III. SQL SERVER DATABASE ARCHITECTURE.

7. Physical Database Architecture.
8. Logical Database Architecture.

IV. SQL SERVER ADMINISTRATION TASKS AND TOOLS.

9. The SQL Server Enterprise Manager.
10. Security and User Administration.
11. The SQL Server Agent.
12. SQL Server Backup, Restore, and Recovery.
13. Database Maintenance.
14. Multiserver Administrative Support.
15. Linked and Remote Server Management.
16. Using BCP to Import and Export Data.
17. Running the SQL Server Service Manager.
18. SQL Server Command-Line Utilities.
19. Administering Very Large SQL Server Databases.
20. Replication.

V. TRANSACT-SQL.

21. Using Transact-SQL in SQL Server 7.0.
22. Transaction Management and Distributed Transactions.

VI. PERFORMANCE ANDTUNING.

23. Database Design and Performance.
24. Query Analysis.
25. Optimization.
26. Advanced Query Processing.
27. Using the SQL Server Profiler.
28. Monitoring SQL Server Performance.
29. Configuring, Tuning, And Optimizing SQL Server Options.
30. Locking and Performance.

VII. BACKOFFICE INTEGRATION.

31. SQL Mail.
32. Internet Information Server and Index Server.
33. Microsoft Transaction Server.
34. Using the OLAP Server.

VIII. APPENDIXES.

APPENDIX A: Technical Specifications.
APPENDIX C: Defining System Administration and Naming Standards.

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews