Introduction

You don’t have to read this introduction, but it will save you some browsing time because it provides a road map for this book, which allows you to best determine the parts to tackle according to your needs or discipline, your experience level, and your knowledge of SQL Server 2000.

I wrote this book when I became starved for more advanced SQL Server information. It seemed that every book I picked up was 1,500 pages yet contained only a few paragraphs in each chapter that I could use. When writing this book, I made the assumption that you already know the basics. I try not to bore you with details on how to create a database or a login. Instead, I focus on troubleshooting what could go wrong when you create a database and best practices. I aimed to do this in a quick and precise way, without the fluff that adds pages but not value.

What’s Inside

The book is divided into three parts, each consisting of several chapters. I’ve also included two reference appendixes on system tables and undocumented DBCC commands, and documented and undocumented extended stored procedures.

Part I: Managing a SQL Server Environment

Part I opens with an introduction to SQL Server’s architecture. In Chapter 1, you’ll also be walked through what can go wrong with a SQL Server installation and how to fix it. Chapter 2 covers managing the SQL Server. It shows you how to tweak the SQL Server and database configuration. You’ll also see in this chapter what the role of a DBA should be in your environment (what you should do to a SQL Server daily, weekly, and monthly). Finally, in Chapter 3, I’ll show you how to ensure that your SQL Server is secured from internal and external forces.

Part II: Tuning SQL Server

True to its name, this part covers all the aspects of tuning SQL Server and optimizing your own time through automation to make you a more efficient DBA. Chapter 4 covers automating SQL Server administration through jobs and alerts. I also cover how to centralize your administration through SQL Server Agent. Chapter 5 explains how to monitor SQL Server through the built-in tools that are available to a DBA. Chapters 6 and 7 show you how to tune SQL Server and T-SQL from the DBA perspective.

Part III: Managing SQL Server in the Enterprise Environment

My favorite topic to discuss is how to deploy SQL Server in the Enterprise. In Part III, I cover how to scale SQL Server and ensure the minimal amount of downtime. Chapter 8 covers minimizing downtime with a solid disaster recovery plan and how to backup and restore SQL Server. Chapter 9 shows you how to scale SQL Server both up and out. The remaining Chapters 10, 11, and 12 show you how to increase your SQL Server’s availability through log shipping, clustering, and replication.

Feedback

I’d love to hear what you think, whether you have a positive or negative comment. Please e-mail me personally at bknight@sqlservercentral.com or see my column at http://www.sqlservercentral.com/columnists/bknight.




SQL Server 2000 for Experienced DBAs
ppk on JavaScript, 1/e
ISBN: 72227885
EAN: 2147483647
Year: 2005
Pages: 126

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net