Beginning SQL Server 2005 Administration (Paperback)

by Dan Wood (Author), Chris Leiter (Author), Paul Turley (Author)
Key Phrases: database engine, table designer, tail log, Service Broker, Server Agent, Server Management Studio (more...)

Editorial Reviews

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

From the Back Cover
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

See all Editorial Reviews

Product Details

• Paperback: 600 pages
• Publisher: Wrox (November 29, 2006)
• Language: English
• ISBN-10: 0470047046
• ISBN-13: 978-0470047040
• Product Dimensions: 9.1 x 7.3 x 1.3 inches
• Shipping Weight: 1.9 pounds (View shipping rates and policies)
• Average Customer Review: 4.4 out of 5 stars See all reviews (7 customer reviews)
• Amazon.com Sales Rank: #61,161 in Books (See Bestsellers in Books)

  Popular in this category: (What's this?)

  #23 in

  Books > Computers & Internet > Databases > Beginning & Introductory

Customer Reviews

Most Helpful Customer Reviews

14 of 14 people found the following review helpful:

5.0 out of 5 stars Just what I needed, January 22, 2007

By	Hard Drive (Seattle, WA) - See all my reviews

I had not touched a DB box in quite a while, and I was recently handed a SQL 2005 box to manage. This book pretty much covered everything I needed. The writing style is laid back and readable, and they get right to the point, without going off on all sorts tangents. The chapter on Automating Administrative Tasks (Chapter 8) was pure gold.

Good stuff.

13 of 13 people found the following review helpful:

5.0 out of 5 stars Great Book!!!, January 18, 2007

By	J. Roach - See all my reviews (REAL NAME)

I found this book offers exactly what I needed. I learned how to best manage my SQL 2005 Database Server. I found the information to be accurate and well written, an excellent reference that I've used many times. I really appreciated how the authors used real world experience to relay hard to understand concepts.

14 of 15 people found the following review helpful:

5.0 out of 5 stars Great Book for Beginnners, June 19, 2007

By	Todd Bryant "tabryant" - See all my reviews (REAL NAME)

This is an awesome book for someone that is new to SQL Server and needs to learn basic administration. The authors did a 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.