Beginning SQL Server 2005 Administration

Product Description:
For the first time, SQL Server 2005 provides features that can support large-scale enterprise databases. With this powerful new release, you may find yourself being called upon to perform duties that are no longer strictly "administrative," duties that have become much more complicated and difficult. With that in mind, a team of experienced Microsoft Certified Professionals provides you with the necessary information to be a more competent and successful database developer or administrator.

Beginning with a foundation that features detailed coverage of typical administrative duties, the authors proceed to explain how to build complex data transformations for data import, build distributed data solutions, and maintain the security and integrity of the database. You will be able to apply what you learn to real-world scenarios, and smoothly navigate the vastly changed landscape of SQL Server 2005 administration.

What you will learn from this book

• How to install, maintain, and manage an SQL Server 2005 installation, including high availability and security considerations
• Various features such as the Common Language Runtime, SQL Server Integration Services, Notification Service, and the Service Broker
• How to use the tools that are necessary to manage configuration, backups, restores, security, availability, performance, and monitoring
• A sampling of some of the more advanced areas and complex jobs of the broadening role of a database administrator in the enterprise

Who this book is for

This book is for both developers and administrators who are responsible for the management and maintenance of an SQL Server 2005 database. Familiarity with relational database concepts and SQL is assumed.

Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.

Enhance Your Knowledge Advance Your Career

Browse for similar items by category:

• Books » Specialty Stores » Custom Stores » Amazon Upgrade » All Amazon Upgrade
• Books » Specialty Stores » Custom Stores » Amazon Upgrade » Computers & Internet
• Books » Specialty Stores » Custom Stores » Qualifying Textbooks » General AAS
• Books » Subjects » Computers & Internet » Databases » Database Management Systems
• Books » Subjects » Computers & Internet » Databases » Beginning & Introductory

Customer Reviews

Rating: - SQL Server 2005 Administration
Very good primer for Microsoft SQL admins. Not too detailed but complete enough not let the reader into complacency. Authors recommended detail topics books are very helpful. Also the technical support from their WROX.com site was welcomed instead of working a accompanying CD.
Rating: - Good book, could be better
I have been in IT for almost 10 years and recently read several books on SQL Server, including this one.
The book is well-written, has no spelling mistakes, etc., but it has too much "fluff" in the text while not providing enough information on many topics. The author starts talking about a specific topic, then says "this is beyond the scope of this book" and this pattern occurs countless times throughout the book. At the same time, the author discusses a lot of unrelated topics and philosophical ... Read More
Rating: - Pretty good SQL Server 2005 BEGINNER book
This book is for beginners. I'm a seasoned system engineer and have worked with SQL 2005 before. However not having any formal training I decided to get a book. I don't want to be a developer so I needed something that demonstrates SQL server 2005 from the admin side. This is book is perfect for that. It explains the major features a sys admin would want to know. Anything above what this book teaches, can be found on technet or doing a google search. So in conclusion, for a sys admin wanting to know SQL ... Read More
Rating: - VERY good basic book.
Having taken several classes from Dan Wood I appreciate the years of practical experience these guys bring to the table.It is a very good, readable, and thorough introduction to MS SQL Server 2005.SQL 2005 is a big product with lots of intricacies.This is one of the best introductions to to it that I've read.
Rating: - Great Book for Beginnners
This is an awesome book for someone that is new to SQL Server and needs to learn basic administration.The authors dida really good job of explaining the fundamentals in clear simple language.

I especially enjoyed the explanation of the storage engine.It made things clear to me that I didn't understand previously.