Professional SQL Server 2005 Administration

  Author:    Brian Knight, Brian Knight, Haidong Ji, Brad McGehee, Ketan Patel, Wayne Snyder, Jean-Claude Armand, Ross LoForte, Brad McGehee, Steven Wort, Ketan Patel, Wayne Snyder, Jean-Claude Armand, Ross LoForte, Steven Wort, Joe Salvatore, Jean-Claude
  ISBN:    0470055200
  Sales Rank:    106836
  Published:    2006-12-11
  Publisher:    Wrox
  # Pages:    650
  Binding:    Paperback
  Avg. Rating:    5.0 based on 4 reviews
  Used Offers:    11 from $19.27
  Amazon Price:    $31.49
  (Data above last updated:  2008-10-06 08:54:18 EST)
  
  
Sort customer reviews by:
  
Show All Reviews on Page      Hide All Reviews on Page
   
  
Professional SQL Server 2005 Administration
  
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.

                  Reader Reviews 1 - 5 of 5                 
  
  
Review
Date
Review
Rating(5 High)
Review
Helpful
to:
Customer Review Reviewer
Info
Permanent
Link
Reader Reviews Below Sorted by Newest First
04-11-08 4 1\1
(Hide Review...)  Good primer for a SQL 2000 Admin
Reviewer Permalink
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.
(Review Data Last Updated: 2008-10-04 05:00:26 EST)
09-14-07 5 1\1
(Hide Review...)  Great Book
Reviewer Permalink
You get a lot for your money with this book. I'm surprised that there are not more reviews.

Great job guys!
(Review Data Last Updated: 2008-04-12 10:44:31 EST)
08-22-07 4 1\1
(Hide Review...)  Not even close to covering the material.
Reviewer Permalink
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.
(Review Data Last Updated: 2007-09-15 08:58:02 EST)
12-09-06 5 15\27
(Hide Review...)  An Advanced Book written for Administrators
Reviewer Permalink
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.
(Review Data Last Updated: 2007-08-22 19:53:47 EST)
12-08-06 5 13\20
(Hide Review...)  An Advanced Book written for Administrators
Reviewer Permalink
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.
(Review Data Last Updated: 2007-04-11 12:01:52 EST)
  
                  Reader Reviews 1 - 5 of 5                 
  
  
  
  
  
  

Because the data used to generate this site come from outside sources, VeryWellSaid.com cannot guarantee the completeness or accuracy of the data.
Search VeryWellSaid™
Google
Web VeryWellSaid™
New subjects are added every week.
View Subjects Below by:
* Top Selling
 (click category name, left)
* Top-Rated Top Sellers
 (click 'Top Rated', right)
In the news...  
Dubai\UAE Top Rated
Influenza\Bird Flu Top Rated
Iraq Top Rated
Supreme Court Top Rated
All Books Top Rated
Arts Top Rated
Photography Top Rated
Digital Photography Top Rated
Digital Cameras Top Rated
Biography Top Rated
Business Top Rated
Management Top Rated
Marketing Top Rated
Sales Top Rated
Stocks Top Rated
Bonds Top Rated
Real Estate Top Rated
Trading Top Rated
Commodities Trading Top Rated
Time Management Top Rated
Starting A Business Top Rated
Children's Top Rated
Comics Top Rated
Computers Top Rated
PC Top Rated
Mac Top Rated
Programming Top Rated
Design Patterns Top Rated
.Net Top Rated
C# Top Rated
Vb.Net Top Rated
Asp.Net Top Rated
Java Top Rated
Python Top Rated
PHP Top Rated
Perl Top Rated
Javascript Top Rated
Ajax Top Rated
CSS Top Rated
Open Source Top Rated
SQL Top Rated
Databases Top Rated
Oracle Top Rated
MySql Top Rated
Sql Server Top Rated
IIS Top Rated
Apache Top Rated
Linux Top Rated
Windows Server Top Rated
Project Management Top Rated
HTML Top Rated
UML Top Rated
IT Certifications Top Rated
Cisco Certifications Top Rated
MCSE Top Rated
MCSD Top Rated
Cooking Top Rated
Italian Cooking Top Rated
Vegetarian Cooking Top Rated
Wine Top Rated
Engineering Top Rated
Entertainment Top Rated
Health Top Rated
Nutrition Top Rated
Dieting Top Rated
Sex Top Rated
History Top Rated
Military History Top Rated
British History Top Rated
Middle East History Top Rated
Land Battles Top Rated
Naval Warfare Top Rated
Air Warfare Top Rated
9/11 Top Rated
Terrorism Top Rated
Home Top Rated
Mortgage\Home Equity Loan Top Rated
Cars Top Rated
Car Buying Top Rated
Sports Cars Top Rated
Cat Top Rated
Humor Top Rated
Horror Top Rated
Law Top Rated
IP Law Top Rated
Legal History Top Rated
Fiction Top Rated
Oprah's Book Club Top Rated
Medicine Top Rated
Cancer Top Rated
Stroke Top Rated
Heart Disease Top Rated
Fertility Top Rated
Diabetes Top Rated
Pharmacology Top Rated
Back Problems Top Rated
Menopause Top Rated
Thyroid Top Rated
Pain Top Rated
Organic Chemistry Top Rated
Immune System Top Rated
Mystery Top Rated
Nonfiction Top Rated
Outdoors Top Rated
Running Top Rated
Radio Control Models Top Rated
Guns Top Rated
Parenting Top Rated
Divorce Top Rated
Professional Top Rated
Reference Top Rated
Religion Top Rated
Romance Top Rated
Science Top Rated
Physics Top Rated
Chemistry Top Rated
Astronomy Top Rated
Psychology Top Rated
Science Fiction Top Rated
Sports Top Rated
Teens Top Rated
Travel Top Rated
USA Top Rated
Europe Top Rated
France Top Rated
Italy Top Rated
England Top Rated
China Top Rated
All Books Arts Biography Click Here For An A-Z Index Of All 213 Best-Seller Subjects Business Children's Comics
Computers Cooking Engineering Entertainment Health History Home Horror Humor Law Fiction Medicine Mystery
Nonfiction Outdoors Parenting Professional Reference Religion Romance Science Sci-Fi Sports Teens Travel
In Association with Amazon.com

Cache miss
(not cached)