| ||||||||||||||||||||||||
 Trade In this Item for up to £7.65
Get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade in Professional Microsoft SQL Server 2008 Administration (Wrox Programmer to Programmer) for an Amazon.co.uk gift card of up to £7.65, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
Frequently Bought Together
Product details
|
More About the Authors
Discover books, learn about writers, and more.
Product Description
Product Description
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.
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 dive into best practices on installing and upgrading to SQL Server 2008. Managing your SQL Server database instance is talked about in Chapter 4. This chapter also describes 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 cover how to properly administer and automate many tasks inside of the Microsoft business intelligence products, such as Integration Services and Analysis Services. Developers will find that Chapter 8 is very useful, as it covers how to administer the development features, such as SQL CLR. Chapter 9 explains how to secure your SQL Server from many common threats and how to create logins and users. Chapter 10 covers how to create a SQL Server project and do proper change management in promoting your scripts through the various environments. It also covers the Policy–Based Management framework in SQL Server.
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 in order to achieve optimal performance. After the hardware and operating system is configured, Chapter 12 shows you how to optimize your SQL Server instance for the best performance. Chapter 13 describes how to monitor your SQL Server instance for problematic issues such as blocking and locking. Chapters 14 and 15 discuss how to optimize the T–SQL that accesses 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 are discussed in Chapter 18. Chapter 19 dives deeply into the role of log shipping in your high–availability strategy, and Chapter 20 presents a step–by–step guide to clustering your SQL Server and Windows 2008 server.
This edition of the book covers all the same great information we covered in the last book, and we’ve added loads of new content for SQL Server 2008, which adds numerous new features to improve the DBA’s life. In short, the new version of SQL Server focuses on improving your efficiency, the scale of your server, and the performance of your environment, so you can do more in much less time, and with fewer resources and people. This means you can manage many servers at one time using Policy–Based Management, scale your I/O load using compression, and collect valuable information about your environment using data collectors, to name just a few key new features.
To follow the examples in this book, you will need to have SQL Server 2008 installed. If you wish to learn how to administer the business intelligence features, you need to have Analysis Services and the Integration Services components installed. You need a machine that can support the minimum hardware requirements to run SQL Server 2008; and you also need the AdventureWorks2008 and AdventureWorksDW2008 databases installed. Instructions for accessing these databases can be found in the ReadMe file on this book′s Web site.
Some features in this book (especially in the high–availability part) require the Enterprise or Developer Edition of SQL Server. If you do not have this edition, you will still be able to follow through some of the examples in the chapter with Standard Edition.
From the Back Cover
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.
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
My only complaints were with regards to the performance chapter where statements were made with no evidence or explanation to support them (e.g. having a tempdb for each core) and not evnough material around monitoring query plans and using hints.
Overall this is an ideal book to give to someone new to SQL Server Administration but is not the concise reference guide I was hoping it would be.
It has been a very useful addition to a department's book shelf and has been referred to multiple times and we'll be looking for another book to supplement it.
I do tend to think this sometimes gives a slightly disjointed feel to Wrox books. To be fair though I imagine that this approach is probably necessary in order to get the book written and published to the market in a timely enough fashion to capitalise on the release of the latest version of the product.
That said this is a reasonable attempt at trying to write a fairly comprehensive volume to cover what is a massive subject. Not an easy undertaking.
Some of the chapters are definitely better than others. All the chapters on high availability (Log Shipping, Mirroring and Clustering) are well written and informative.
Unfortunately after downloading the sample code from the Wrox website, I found that some of this doesn't actually work. In some cases the problem is just something silly (for example the wrong database name is given) which is easy to spot and correct.
However in the case of the chapter on table-partitioning, the sample code just does not work, which is very disappointing and leaves the reader feeling quite frustrated.
These gripes aside I think this is a decent book and a worthwhile addition to the library of anyone interested in SQL Server.
This collaboration gives a thorough introduction to the new features of SQL Server 2008. It blends clear explanations of the thought process behind new developments with pragmatic tips from professional DBAs. Effort has been put into describing complex systems coherently. The contributers come across as enthusiastic but never pompous.
Listmania!
|
|
Look for similar items by category
- Books > Computing & Internet > Databases > Applications > Microsoft SQL Server > Advanced & Intermediate
- Books > Computing & Internet > Databases > Applications > SQL > Microsoft SQL Server
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Programming > Microsoft Windows > SQL Server
- Books > Computing & Internet > Software & Graphics
- Books > Computing & Internet > Web Development > Web-server Software > Microsoft
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
