posted on Monday, August 28, 2006 9:42 AM
by
bknight
My New SQL Server 2005 Administration Book Out
This weekend, I sent the final introduction out to the publisher on my newest book, Professional SQL Server 2005 Administration. It was a stressful but wonderful experience this time writing again for Wrox. This book is a pretty deep administration book. We had three MVPs, two very experienced authors and four Microsoft employees writing this book and I think you'll be happy with the coverage. You can order the book today on Amazon and it should be out within the next few months.
![Professional SQL Server 2005 Administration]()
The first ten chapters of the book are about administering the various areas of SQL Server, including the developer and business intelligence features. Chapter 1 briefly covers the architecture of SQL Server and the changing role of the DBA. Chapters 2 and 3 dives into best practices on installing and upgrading to SQL Server 2005. Managing your SQL Server database instance is talked about in Chapter 4. This chapter goes over also some of the hidden tools you may not even know you have.
Once you know how to manage your SQL Server, you can learn in Chapter 5 how to automate many of the redundant monitoring and maintenance tasks. This chapter also discusses best practices on configuring SQL Server Agent. Chapters 6 and 7 covers how to properly administer and automate many tasks inside of the Microsoft business intelligence products like Integration Services and Analysis Services. Developers will find that Chapter 8 is very useful, as it covers how to administer the development features like SQL CLR. Chapter 9 talks about how to secure your SQL Server from many common threats and how to create logins and users. The last chapter in this part of the book (Chapter 10) covers how to create a SQL Server project and do proper change management in promoting your scripts through the various environments.
Chapters 11 through 15 make up the performance tuning part of the book. Chapter 11 discusses how to choose the right hardware configuration for your SQL Server to perform optimally. After the hardware and operating system is configured, Chapter 12 shows you how to optimize your SQL Server instance the best performance. Chapter 13 shows you how to monitor your SQL Server instance for problematic issues like blocking and locking. Chapters 14 and 15 discuss how to optimize the T-SQL that access your tables and then how to index your tables appropriately.
Chapters 16 through 20 consist of the high availability chapters of the book. Chapter 16 covers how to use the various forms of replication while database mirroring is covered in Chapter 17. Classic issues and best practices with backing up and recovering your database is discussed in Chapter 18. Chapter 19 dives deeply in what the role of log shipping is in your high availability strategy and Chapter 20 presents a step-by-step guide to clustering your SQL Server.
-- Brian Knight