See larger picture | Professional SQL Server 2005 Administration (Wrox Professional Guides)
by
Brian Knight, Ketan Patel, Wayne Snyder, Jean-Claude Armand, Ross LoForte, Brad McGehee, Steven Wort, Joe Salvatore, and Haidong Ji
- WroxList Price: $49.99 Price at Amazon.com: $31.49
(Save
37%)
Availability: Usually ships in 24 hours Shipping rates and policies |
- Average Customer Review:
Based on
5
reviews.
- Amazon.com Sales Rank: 160123
|
Product Description SQL Server 2005 is the largest leap forward for SQL Server since its inception. With this update comes new features that will challenge even the most experienced SQL Server DBAs. Written by a team of some of the best SQL Server experts in the industry, this comprehensive tutorial shows you how to navigate the vastly changed landscape of the SQL Server administration. Drawing on their own first-hand experiences to offer you best practices, unique tips and tricks, and useful workarounds, the authors help you handle even the most difficult SQL Server 2005 administration issues, including blocking and locking. You'll learn how to fine-tune queries you've already written, automate redundant monitoring and maintenance tasks, and use hidden tools so that you can quickly get over the learning curve of how to configure and administer SQL Server 2005. What you will learn from this book - How to use some of the more advanced concepts of installation
- Techniques for properly administering development features such as SQL CLR
- Ways to secure your SQL Server from common threats
- How to choose the right hardware configuration
- Best practices for backing up and recovering your database
- Step-by-step guidelines for clustering your SQL Server
Who this book is for This book is for experienced developers and database administrators who plan to administer or are already administering an SQL Server 2005 system and its business intelligence features. Wrox Professional guides are planned and written by working technologists 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.
Featured Customer Reviews A handbook for DBAs,
October 31, 2008 This book is a good reference for DBAs and IT professionals who wants to know everything about SQL Server 2005. I like the structure of contents, the examples and the way it exposes the subjects. Good primer for a SQL 2000 Admin,
April 11, 2008 I had been out of SQL 2K for several years and had a project that came up that fit best with a lot of the features of 2005. This book was a good read, lots of good examples, and got me back into the swing of things. The project went well and this book gave me the foundation I needed. Great Book,
September 14, 2007 You get a lot for your money with this book. I'm surprised that there are not more reviews.
Great job guys! Not even close to covering the material.,
August 22, 2007 I am an experienced Sql Server 2000 DBA, and as I get more involved with 2005 the more this book falls short. This is because 2005 is so much more complex than 2000 that a single 700 page book simply does not cover the material. Simple things like schema ownership and management is glossed-over in the book when in fact it is a huge subject. Buy this book as it is useful, but plan on buying the Microsoft books and reading them soon. 2005 marks a major change and you can not afford to be left behind. An Advanced Book written for Administrators,
December 08, 2006 SQL Server is a major big-time database. It has numerous features with settings that can dramatically alter its performance. It can also be expanded to handle exceedly large databases with multiple servers handling a great many dips into the database updating, adding, selecting out data. There are also multiple editions of SQL Server to handle clustering, high availability and so on.
This book covers all of these and more. It begins with the architecture, goes on to installation, performance tuning, security, performance tuning, monitoring, indexing, replication, mirroring, backup, logging, and clustering.
The book is intended for people who have some experience with SQL Server, at least to the point of being able to understand what SQL is and how to get data into and out of the database. It will then cover how to tune the queries you're already written to get the maximum performance.
This is a Wrox Professional level book, it is written by professionals for the use of professionals.
You might also be interested in these items...
|
|