627383.indd We’re happy to announce that Microsoft SQL Server 2008 Administrator's Pocket Consultant, Second Edition, by William Stanek, has shipped to the printer. The book’s ISBN is 9780735627383, the book includes 17 chapters and 736 pages, and it will be available after April 21. The book’s first edition has been updated for the R2 of SQL Server 2008.

Below is more info about the book. Check back later for excerpts from the book’s chapters.

Introduction

Microsoft SQL Server 2008 Administrator’s Pocket Consultant, Second Edition,
is designed to be a concise and compulsively usable resource for SQL Server
2008 and SQL Server 2008 Release 2 (R2) administrators. It covers everything you
need to know to perform the core administrative tasks for SQL Server and is the
readable resource guide that you’ll want on your desk at all times. Because the focus
is on giving you maximum value in a pocket-sized guide, you don’t have to wade
through hundreds of pages of extraneous information to find what you’re looking
for. Instead, you’ll find exactly what you need to get the job done.

This book is designed to be the one resource you turn to whenever you have
questions about SQL Server administration. To this end, the book zeroes in on
daily administration procedures, frequently used tasks, documented examples, and
options that are representative while not necessarily inclusive. One of the key goals
is to keep content concise enough that the book is compact and easy to navigate
while also ensuring that the book contains as much information as possible. Instead
of a 1,000-page tome or a 100-page quick reference, you get a valuable resource
guide that can help you quickly and easily perform common tasks, solve problems,
and implement advanced SQL Server technologies such as replication, distributed
queries, and multiserver administration.

Who Is This Book For?

Microsoft SQL Server 2008 Administrator’s Pocket Consultant, Second Edition, covers
the Standard, Enterprise, Developer, Web, and Workgroup editions of SQL Server.
The book is designed for:

  • Current SQL Server database administrators
  • Accomplished users who have some administrator responsibilities
  • Administrators migrating to SQL Server 2008 and SQL Server 2008 R2 from
    previous versions
  • Administrators transitioning from other database architectures

To include as much information as possible, I had to assume that you have basic
networking skills and a basic understanding of SQL Server. With this in mind, I don’t
devote entire chapters to understanding SQL Server architecture or running simple
SQL queries. But I do cover SQL Server installation, configuration, enterprise-wide
server management, performance tuning, optimization, maintenance, and much
more.

I also assume that you’re fairly familiar with SQL commands and stored procedures
as well as the standard Windows user interface. If you need help learning SQL
basics, you should read other resources (many of which are available from Microsoft
Press).

How Is This Book Organized?

Microsoft SQL Server 2008 Administrator’s Pocket Consultant, Second Edition, is
designed to be used in the daily administration of SQL Server, and as such the book
is organized according to job-related tasks rather than SQL Server features. Before
you use this book, you should be aware of the difference between the Administrator’s
Pocket Consultant titles and the Administrator’s Companion titles. Both types
of books are designed to be a part of an overall administrator’s library, but books in
the Administrator’s Pocket Consultant series are the down-and-dirty, in-the-trenches
books, and Administrator’s Companion titles are the comprehensive tutorials and
references that cover every aspect of deploying a product or technology in the
enterprise.

Continue reading at the Microsoft Press blog.