Professional Microsoft SQL Server 2008 Administration

ISBN-13: 9780470247969 / Angielski / Miękka / 2008 / 912 str.

Brian Knight; Ketan Patel; Wayne Snyder

Opis

SQL Server 2008 represents a sizable jump forward in scalability, performance, and usability for the DBA, developer, and business intelligence (BI) developer. It is no longer unheard of to have 20-terabyte databases running on a SQL Server. SQL Server administration used to just be the job of a database administrator (DBA), but as SQL Server proliferates throughout smaller companies, many developers have begun to act as administrators as well. Additionally, some of the new features in SQL Server are more developer-centric, and poor configuration of these features can result in poor performance. SQL Server now enables you to manage the policies on hundreds of SQL Servers in your environment as if you were managing a single instance. We've provided a comprehensive, tutorial-based book to get you over the learning curve of how to configure and administer SQL Server 2008. Whether you're an administrator or developer using SQL Server, you can't avoid wearing a DBA hat at some point. Developers often have SQL Server on their own workstations and must provide guidance to the administrator about how they'd like the production configured. Oftentimes, they're responsible for creating the database tables and indexes. Administrators or DBAs support the production servers and often inherit the database from the developer. This book is intended for developers, DBAs, and casual users who hope to administer or may already be administering a SQL Server 2008 system and its business intelligence features, such as Integration Services. This book is a professional book, meaning the authors assume that you know the basics about how to query a SQL Server and have some rudimentary concepts of SQL Server already. For example, this book does not show you how to create a database or walk you through the installation of SQL Server using the wizard. Instead, the author of the installation chapter may provide insight into how to use some of the more advanced concepts of the installation. Although this book does not cover how to query a SQL Server database, it does cover how to tune the queries you've already written.

Spis treści

Forward.

Chapter 1. SQL Server 2005 Architecture.

Chapter 2. SQL Server 2005 Installation Best Practices.

Chapter 3. Upgrading SQL Server 2008 Best Practices.

Chapter 4. Managing and Troubleshooting the Database Engine.

Chapter 5. Automating SQL Server.

Chapter 6. Integration Services Administration and Performance Tuning.

Chapter 7. Analysis Services Administration and Performance Tuning.

Chapter 8. Administering the Development Features.

Chapter 9. Securing the Database Engine.

Chapter 10. Change Management.

Chapter 11. Configuring the Server for Optimal Performance.

Chapter 12. Optimizing SQL Server 2005.

Chapter 13. Monitoring Your SQL Server.

Chapter 14. Performance Tuning T–SQL.

Chapter 15. Indexing Your Database.

Chapter 16. Replication.

Chapter 17. Database Mirroring.

Chapter 18. Backup and Recovery.

Chapter 19. SQL Server 2005 Log Shipping.

Chapter 20. Clustering SQL Server 2005.

O autorze

Brian Knight (MCSE, MCDBA) is a Senior Database Administrator at Alltel in Jacksonville, Florida, where he manages the mortgage enterprise database system. Brian focuses his developmental time on merging database technologies such as Oracle and DB2 into SQL Server, using DTS and OLAP. He also writes several weekly columns and co-runs the SQL Server area of Swynk.com (a BackOffice-focused Internet site) and writes columns for SQL Magazine.

Blurb

Professional Microsoft® SQL Server® 2008 Administration

SQL Server 2008 represents a significant jump forward in scalability and performance. Database administrators and developers as well will need to master new methods for effectively managing increasingly large and complex SQL Server environments.

This author team of SQL Server experts arms you with unique tips, tricks, and workarounds, including managing and monitoring SQL Server, automating administration, clustering, performance tuning, handling backup and recovery, and more. You′ll learn the various tools that are available to you with the 2008 release, as well as new features such as Performance Studio, Change Data Capture, Policy–based Management, and Query Governor. With a solid understanding of SQL Server 2008, you′ll be able to confidently handle even the most difficult SQL Server admin issues.

What you will learn from this book

• Best practices for SQL Server 2008 installation

• Tips for troubleshooting and securing the database engine

• How to automate SQL Server

• Ways to index your database

• Methods for monitoring your SQL Server instance

• How to performance tune your SQL Server instance

Who this book is for

This book is for experienced database administrators who are interested in learning best pratices for administering SQL Server 2008.

Wrox Professional guides are planned and written by working programmers to meet the real–world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.