Step-by-step checklists for everything involved in running a SQL Server database, real-life tips and notes to complement your learning experience, installation and upgrade techniques, guidelines for backing up and restoring data, steps to optimizing and automating routine procedures, ways to correct common database problems as they arise, and procedures for creating Web pages with the Web Assistant.
This book will turn a mediocre administrator into an effective, skilled leader in charge of a well-tuned RDBMS. Time-saving techniques show how to maximize the Microsoft SQL Server. - Teaches how to implement day-to-day preventive maintenance tasks
- Updated to cover new features-including the new transaction wizard
- CD-ROM contains scripts and the time-saving programs from the book