SQL Server 2005 is the largest leap forward for SQL Server sinceits inception. With this update comes new features that willchallenge even the most experienced SQL Server DBAs. Written by ateam of some of the best SQL Server experts in the industry, thiscomprehensive tutorial shows you how to navigate the vastly changedlandscape of the SQL Server administration.
Drawing on their own first-hand experiences to offer you bestpractices, unique tips and tricks, and useful workarounds, theauthors help you handle even the most difficult SQL Server 2005administration issues, including blocking and locking. You'll learnhow to fine-tune queries you've already written, automate redundantmonitoring and maintenance tasks, and use hidden tools so that youcan quickly get over the learning curve of how to configure andadminister SQL Server 2005.
What you will learn from this book
- How to use some of the more advanced concepts ofinstallation
- Techniques for properly administering development features suchas SQL CLR
- Ways to secure your SQL Server from common threats
- How to choose the right hardware configuration
- Best practices for backing up and recovering your database
- Step-by-step guidelines for clustering your SQL Server
Who this book is for
This book is for experienced developers and databaseadministrators who plan to administer or are already administeringan SQL Server 2005 system and its business intelligencefeatures.
Wrox Professional guides are planned and written byworking technologists to meet the real-world needs of programmers,developers, and IT professionals. Focused and relevant, theyaddress the issues technology professionals face every day. Theyprovide examples, practical solutions, and expert education in newtechnologies, all designed to help programmers do a better job.