Microsoft SQL Server 7.0 Unleashed
Published on 17. June 1999
Book
Mixed media product
936 pages
978-0-672-31227-4 (ISBN)
Description
Microsoft SQL Server 7 Unleashed offers a variety of topics for system and database administrators and programmers to help you learn new features and objects of the product and solve problems you face on a daily basis. Building upon your working knowledge of the product, it takes your experience and knowledge to a more expert level. This title includes topics such as SQL Server architecture and Transact-SQL programming, performance tuning and system administration, Web and Scalability issues, integration with BackOffice, and much more.
More details
Language
English
Place of publication
Indianapolis
United States
Publishing group
Pearson Education (US)
Target group
College/higher education
Dimensions
Height: 232 mm
Width: 187 mm
Thickness: 34 mm
Weight
1540 gr
ISBN-13
978-0-672-31227-4 (9780672312274)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Persons
David Solomon, President of Metis Technologies in Troy NY, writes, speaks, teaches, and consults on SQL Server design application and implementation. With more than five years of experience with SQL Server, he is an expert on query analysis and troubleshooting, logical database design, and application design and implementation.
Content
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 AND TUNING.
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.
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 AND TUNING.
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.