SQL Server 2000 Administration (Book/CD-ROM)

Overview

Get cutting-edge SQL Server 2000 management techniques for installation,automation,data manipulation,replication,and much more. This expert resource provides full details on system architecture,file storage,security,and troubleshooting and explains how to integrate Windows 2000 components,including the MMC and ActiveDirectory.

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

Read More