SQL Server 7 Administration
by Shane Stigler, Mark Linsenbardt, Shane Stigler, M. Shane StiglerMaintain 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
Overview
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.
Product Details
- ISBN-13:
- 9780072121476
- Publisher:
- McGraw-Hill Professional
- Publication date:
- 08/28/1999
- Series:
- Database Professional's Library
- Pages:
- 680
- Product dimensions:
- 7.36(w) x 9.12(h) x 1.87(d)
Meet the Author
Customer Reviews
Average Review: