William Stanek does it again! William’s latest book, Microsoft SQL Server 2008 Administrator’s Pocket Consultant, Second Edition, is now available. This edition has been completely updated for SQL Server 2008 R2. You can place your orders now!
Here are two excerpts from the book. Enjoy!
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:
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).
SQL Server 2008
Administration Overview (excerpt)
· SQL Server 2008 and Your Hardware 2
· SQL Server 2008 Editions 5
· SQL Server and Windows 8
· Using the Graphical Administration Tools 12
· Using the Command-Line Tools 16
· Using SQL Server PowerShell 21
Microsoft SQL Server 2008 was released in 2008, and SQL Server 2008 Release 2 (R2) followed in 2010. For ease of reference in this book, I refer to both SQL Server 2008 and SQL Server 2008 R2 as SQL Server or SQL Server 2008. When I need to differentiate between the two releases, I’ll indicate that Release 1 (R1) does this but R2 does that. Sometimes, I’ll simply state the additional options or features that R2 provides.
SQL Server 2008 builds on SQL Server 2005 and finally makes Microsoft’s vision of SQL Server as an end-to-end data platform a reality. SQL Server 2008 R2 is an incremental release that includes some additional functionality and performance enhancements. By functioning as a mission-critical data platform, allowing dynamic development, providing extensive business intelligence, and going beyond relational data, SQL Server 2008 provides the bedrock foundation on which small, medium, and large organizations can build their next generation IT infrastructure. At the core of SQL Server 2008 and R2, you will find the following:
As you get started with SQL Server 2008, you should concentrate on these areas:
This book is good.
This book is excellent. I truly appreciate your efforts in putting this together. I will be recommending this book to clients for a powerful reference guide to managing ther SQL Server 2008 environments. Great work Sir!
Won this book in a raffle, a very good prize