SQL Server 2000 Administration (Database Professional's Library) - Softcover

Linsenbardt, Mark A.; Stigler, M.Shane

Softcover

ISBN 10: 0072126183 ISBN 13: 9780072126181

Publisher: McGraw-Hill Inc.,US, 2000

Synopsis

This title covers general and unattended/remote installations and provides real-world information on system architectures, files, and advanced security measures. It explains efficient backup techniques, data manipulation, and replication procedures and offers day-to-day troubleshooting techniques and optimization methods. It also contains a CD-ROM with 120-day trial version of SQL Server 2000.

About this title

About the Author

Mark Linsenbardt (Las Vegas, NV) MCSE, MCT is an independent consultant, trainer, speaker, and author. Shane Stigler (Las Vegas, NV) MCSE, MCT is president of Stigler Consulting, an international consulting firm for medium and large companies on corporate MIS management and network design.

From the Back Cover

Get cutting-edge techniques for managing SQL Server 2000.

Provide a scalable, replicated, and reliable foundation for your database-driven e-commerce applications. Packed with up-to-date information, real-world examples, and hands-on solutions, SQL Server 2000 Administration covers installation, configuration, system architecture, security, file management, data manipulation and replication, automation, and restoration. Plus, the "From the Field" sections highlight little-known tips and tricks from the authors' vast SQL Server management experience. This is an indispensable resource for all SQL Server DBAs.

-Set up, configure, and maintain SQL Server 2000
-Perform unattended installations from inside the Windows 2000 directory model
-Manage user databases, file storage, and data queries using the Microsoft Management Console (MMC)
-Handle database security using authentication, Roles, permissions management, stored procedures, and views
-Transfer and transform data using DTS, field mapping, and parsing
-Back up and restore data with minimal impact on users
-Master Analysis Services, data replication, warehousing, and SQL server automation
-Institute and govern data replication
-Prevent downtime, crashes, and data losses

Edition details

• Publisher: McGraw-Hill Inc.,US
• Publication date: 2000
• Language: English
• ISBN 10: 0072126183
• ISBN 13: 9780072126181
• Binding: Paperback
• Edition number: 2
• Number of pages: 608