Beginning Microsoft SQL Server 2008 Administration

This book teaches both novice and experienced database administrators how to leverage all of the features of SQL Server to deliver solid, reliable performance. All features and techniques are illustrated with real–world examples and step–by–step instructions.
After a quick overview of SQL Server management tools and database components, you′ll walk through system installation and configuration, configuring and managing network communications, and automating administration tasks. You′ll gain insight into business continuity strategies, performance monitoring, and optimization. The authors also cover the complete suite of Business Intelligence tools, including SQL Server Integration Services, Reporting Services, Analysis Services, and Service Broker.
With this book, you′ll develop the skills required to successfully administer a SQL Server 2008 database, regardless of your experience level.
What you will learn from this book
How to install, maintain, and manage a SQL Server 2008 implementation, and automate administrative tasks
How to monitor performance using various tools and techniques
Strategies for optimizing your database
Ways to ensure high availability
How to begin using SQL Server as a BI platform
How to configure and use BI components, including SQL Server Reporting Services
How the Service Broker is used
Who this book is for
This book is for beginning to intermediate SQL Server database administrators who want to learn about managing a SQL Server environment.
Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.

Spis treści:
Introduction.
1. Introducing SQL Server 2008.
2. Installing SQL Server 2008.
3. SQL Server 2008 To ols.
4. SQL Server 2008 Storage Architecture.
5. SQL Server 2008 Databases.
6. SQL Server 2009 Security.
7. Configuring SQL Server Network Communication.
8. Automating Adminstrative Tasks.
9. Disaster Prevention and Recovery.
10. Monitoring SQL Server.
11. Optmizing SQL Server.
12. SQL Server High Availability.
13. Introduction to Replication.
14. Introduction to the Common Language Runtime.
15. An Adminstrator′s Guide to Business Intelligence.
16. Introduction to SQL Server Integration Services.
17. Introduction to SQL Server Analysis Services.
18. Introduction to SQL Server Reporting Services.
19. Introduction to the Service Broker.
Index.

Okładka tylna:

This book teaches both novice and experienced database administrators how to leverage all of the features of SQL Server to deliver solid, reliable performance. All features and techniques are illustrated with real–world examples and step–by–step instructions.
After a quick overview of SQL Server management tools and database components, you′ll walk through system installation and configuration, configuring and managing network communications, and automating administration tasks. You′ll gain insight into business continuity strategies, performance monitoring, and optimization. The authors also cover the complete suite of Business Intelligence tools, including SQL Server Integration Services, Reporting Services, Analysis Services, and Service Broker.
With this book, you′ll develop the skills required to successfully administer a SQL Server 2008 database, regardless of your experience level.
What you will learn from this book
How to install, maintain, and manage a SQL Server 2008 implementation, and automate administrative tasks
How to monitor performance using various tools and techniques
Strategies for optimizing your database
Ways to ensu re high availability
How to begin using SQL Server as a BI platform
How to configure and use BI components, including SQL Server Reporting Services
How the Service Broker is used
Who this book is for
This book is for beginning to intermediate SQL Server database administrators who want to learn about managing a SQL Server environment.
Wrox Beginning guides are crafted to make learning programming languages and technologies easier than you think, providing a structured, tutorial format that will guide you through all the techniques involved.