 | | |
| SQL Server 2005 Bible | 
| Author: Paul Nielsen
Publisher: Wiley
Category: Book
List Price: $49.99
Buy New: $19.69
You Save: $30.30 (61%)
Buy New/Used from $19.69
Avg. Customer Rating:  (9 reviews)
Sales Rank: 305754
Languages: English (Original Language), English (Unknown), English (Published)
Media: Paperback
Number Of Items: 1
Pages: 1344
Shipping Weight (lbs): 3.8
Dimensions (in): 9.2 x 7.3 x 2.6
ISBN: 0764542567
Dewey Decimal Number: 005.2768
EAN: 9780764542565
ASIN: 0764542567
Publication Date: November 6, 2006
Availability: Usually ships in 1-2 business days
|
| Similar Items:
|
| Editorial Reviews:
Product Description
Use this comprehensive tutorial and reference to increase productivity and write stored procedures using the language with which you're most familiar. The revised content covers new features such as XML integration, Web services, the .NET Common Language Runtime (CLR), and security updates, making this book a must for any developer or database administrator transitioning to the new version of SQL Server. You'll learn to develop SQL Server database and data connections, administer SQL Server, and keep databases performing at their peak. In addition, you'll find dozens of specific examples in both a graphical format and as SQL code as well as numerous best practices describing the most effective way to accomplish a given task. A companion Web site provides all of the code examples found in the book.
|
| Customer Reviews: Read 4 more reviews...
 Can someone please send me the rest of the text! December 28, 2008
First off, my biggest complaint is the discrepancies between code listed in the text book, and the sample databases downloaded from the author's web site. If you are providing sample databases for download, please make sure the column names referenced in your SQL statements actually exist in the tables!
I found it very difficult to follow the logical flow of the book. It always seemed like I was getting to a lecture half way thru, wondering if what I missed in the first 10 minutes would help my understanding of what the author is talking about. Tools are often explained, but the author never shows you how to open the tools, or set them as defaults. There is no logical flow from one topic to the next, again, you feel like you're ten minutes late to the lecture.
I would wager that half of my time reading this book is spent on trying to follow the author's train of thought, then applying it to SQL. Perhaps the most common expression I make reading this text is, "WTF?!" I'll definitely be purchasing some other text.
Definitely not for SQL beginners, and if you are advanced, this probably won't help you.
On a side note: This lack of attention to detail and inability to connect to the reader seems to be a "Bible" book theme. I also have a Red Had Linux Bible book that suffers the exact same complaints. At first I thought it was the author, but now that I've got my hands on a second "Bible" publication with the exact same problems, I'll be steering clear of these!
 The best book available for the strict DBA September 7, 2007
33 out of 34 found this review helpful
There are really three kinds of database professionals:
-Administrators
-Architects/Designers
-Developers
Now, some people play all three roles or two of the three roles. This book is definitely not the best book for people who are strictly developers as is reflected by some of the reviews at this site. Of course, the book is not intended for that class of database professional (in fact, they are really not database professionals if they are strictly developers, but are more developers who have to have a database for their application).
For those who play the role of the Administrator only - and there are thousands of you out there because I teach many of you in my classes - or a combination of administrator/designer this is the best single book you will find. (That's right, the author of another book on SQL Server is suggesting that his book is not the best single book... my book helps you specifically in preparing for the 70-431 exam and is not intended to have the breadth of coverage of this book.) Some developers just don't realize that most small businesses with an IT staff of less than twenty do not have dedicated database people and this book is for those people in those businesses. They are not going to write a lot of applications, if any, from the ground up, but they must support SQL Server databases that have been developed by others.
They need to understand backups and restorations, data export, data import, data tranformation (ETL), security, performance issues and other administrative tasks. All if this is covered sufficiently in the SQL Server 2005 Bible.
I must say that I have not always been a fan of the "Bible" series, but this book has been great since the SQL Server 2000 level when I started recommending it.
I hope this helps you make your decision.
This is a great book August 30, 2007
4 out of 4 found this review helpful
I guess I didn't buy this book from the perspective of a programmer, but rather a strict DBA. That is, I don't do much programming... I only manage the database server and help programmers when they need something done on the server. For this reason, I don't have some of the complaints of those who were concerned about lacking information from a developer's perspective.
As a DBA, I feel this is one of the best two books written on SQL Server 2005. I also used Tom Carpenter's 70-431 study guide to prepare for that exam and, while it's not as lengthy as this book, it is my other in that pool of two.
Certainly, if I could only get one book, it would be this one. There are things in Tom Carpenter's book that are not in this book, but since Mr. Carpenter's book is intended to prepare for an exam, there are also things in Mr. Nielsen's book that are not in the other. Overall, there is more detailed information and lengthy explanations in teh SQL Server 2005 Bible. It and Mr. Carpenter's book sit on my shelf alone in the SQL Server 2005 category. I highly recommend the SQL Server 2005 Bible and hope you wear yours out like I am beginning to do with mine.
Good Reference For SQL 2005 DBA's February 13, 2007
3 out of 9 found this review helpful
Just finished reading the book , I do recommend it , either for professionals or beginners ! , for professionals , it does have any in depth knowledge we can gain from , all topics are not very basic and shallow, describing distributed transactions in 2 pages for example, very good indexing and performance chapter 50, For beginners there are no books compare in value , the book is written for SQL Server 2005. it is a SQL Server 2005 bible.. that it's true...
New features; new chapters January 20, 2007
9 out of 9 found this review helpful
I have the author's SQL Server 2000 book and this book, and it is definitely a major upgrade: 350 more pages, 23 more chapters.
OBXKites is still in here, and David still gets his drivers license on 11/30/2005, but there are as many new topics as there are new features in 2005.
I can imagine that a bible series book is responsible for taking the reader from their "genesis" of being a novice to their "revelation" of advanced topics.
This can be a daunting task for one volume, especially when the subject is as vast as SQL Server! To accomplish this, the book has 10 chapters dedicated to variations of the Select Command. [...]
Nielsen's chapter introductions give you the feel that you're sitting down with a real person, so you know he's going to explain things instead of listing the syntax.
And experienced insight is what I crave when learning a new language. For instance, instead of slogging through all the features of cursors and finding out for myself that they're inefficient, Nielsen explains that while MSDN says "[SQL Server] implements a performance optimization called a fast forward-only cursor", the reality is that SQL Server is a set-based language and cursors should be used as a last-resort. He then shows how to convert a complex cursor to set-based code.
The chapter on indexing explains how indexes work and offers sound advice on how to plan effective indexes - probably the most effective way to optimize an application before having to start changing table structures.
Business Intelligence is the latest requirement for potential employers, so any book that has a chapter on how to use the BI Suite in 2005 is a must-read. There are 3 chapters on Analysis services (including Data Mining and MDX), 2 on RS, 1 on IS, and even one on BI using Excel.
|
|
|
Powered by: Dknc, inc. and Amazon.com | | 
For your safety and security, orders are processed through amazon.com
|
|
|
|
