Rating: 
Summary: Great beginners book!
Review: Just moving across from Access to SQL Server and I found this a brilliant book. Starting from the installation, through creating a database onwards it covers every aspect.The best part is that the book covers the same area from every angle so I could choose which method from the choices SQL Server 2000 gives me, suits me best. I didnt know which book to buy on the shelves in the book store, but from just opening the book at random pages the author had a great style of writing.
Rating: 
Summary: Not so great
Review: Not a great book. I would rather go for Professional SQL Server 200 Programming by Robert Vieira.
Rating:
Summary: Not so great
Review: Not a great book. I would rather go for Professional SQL Server 200 Programming by Robert Vieira.
Rating: 
Summary: Good coverage of the GUI tools
Review: This book is a good starting point programmers who are familiar with other databases but want to learn about SQL Server 2000. This book includes a 120-day evaluation copy of SQL Server 2000, and the author guides us through, installation and configuration of our first database. In the process, we learn how to use the Enterprise Manager and Query Analyzer programs for database development.Unfortuantely, the section on primary keys and unique constraints is weak. And, the author's coverage of triggers
is confusing. You'll have to find another book to supplement these sections if you have not yet mastered these concepts.
Rating:
Summary: Good coverage of the GUI tools
Review: This book is a good starting point programmers who are familiar with other databases but want to learn about SQL Server 2000. This book includes a 120-day evaluation copy of SQL Server 2000, and the author guides us through, installation and configuration of our first database. In the process, we learn how to use the Enterprise Manager and Query Analyzer programs for database development. Unfortuantely, the section on primary keys and unique constraints is weak. And, the author's coverage of triggers
is confusing. You'll have to find another book to supplement these sections if you have not yet mastered these concepts.
Rating: 
Summary: Incomprehensible Writing -- Get another book
Review: This book is extremely difficult to understand because of its poor writing and editing. You should buy another book. I am suprised to find how bad this book is, because I have normally had very good experiences with Wrox books. This one, however, was lightly edited, if at all. Poor editing makes the reader work much harder to understand the message behind the words. If you buy this book, you'll either have to work extra hard to understand the message, or you'll not understand as much about SQL Server as you should have. Examples of the book's nonsense: "An index defined as being clustered, defines the physical order that the data in the table is stored," p 231, paragraph 2. "Therefore, providing the SELECT statement is not setting a variable, a recordset is returned," p 525, paragraph 4. Regards, Bill -- My translations of the above sentences: "An clustered index specifies the physical order in which a table's data is stored." "Therefore, providing the SELECT statement returns a recordset--it does not set a variable."
Rating:
Summary: Good book. Detailed review below...
Review: This is an excellent beginners book. From installation through to triggers all you need to know to get up and running. Shame it is missing about User Defined Functions but I thought this was a really good book. Chapter 1 - Good coverage of the versions, whats what. Also liked the installation of SQL Server.
Chapter 2 Covered areas such as Enterprise Manager well and like the Configuring section. Found out how to set some very useful propreties
Chapter 3 - Query Analyzer. Went through every item that a beginner should need as well as an intermediate. Helped me figure out and set up as I wanted
Chapter 4 - This chapter for DB design etc is very clear and concise. I liked the Normalization section as well as relationships as to how these work
Chapter 5/6/7 - Enough coverage and good warnings about the system databases and building the sample db. Also loved the defining tables and the different data types and finally all about the different indexes you can have. Very useful. Chapter 8 - This was my favourite chapter as it showed how to build relationships between tables.
Chapter 9 - didnt think this was really necessary
Chapter 10 - Good basics of backups. Not much on network backups.
Chapter 11 - Good basics again of maintenance
Chapter 12 - Images!! Yes!! No-one else I know touches this.
chapter 13-15 - Loved transactions in the Insert chapter. all the others cover good basics of T-SQL
Chapter 16 - Could have done a bit more on indexing a view but apart from that shows how to create a view well. Also how to use it
Chapter 17/18 - Would have liked to see more about nested stored procedures but again good coverage. Dealing with errors was my favourite part
Chapter 19 - XML - The way so much is going. Maybe book needs updating for SQLXML 3.0?
chapter 20 - A bit advanced for beginners but triggers are a great plus. As I say, this is the best beginning SQL Server book I bought (this was my third!) and I loved the authors style and content. Wasnt confused at any point and found all that was being said to be clear. Wish I had bought it first Its downfalls? Well images it does say you need a binary stream to input an image but doesnt show any VB code to pass it in. No UDF's or UDT's and no coverage of SQL XML 3. Dedication was interesting but a bit long....
Excellent coverage on how to complete each action in any method you wish so this does lead to excellent T-SQL coverage. Loved it
Rating:
Summary: Great way to learn enuff to pass MS 70-229!!!
Review: This is an excellent book for learning to install, configure and manage SQL Server. However, the the title is a little misleading. The empasis not programming but admin. The few programming examples included are so intermingled with the admin stuff that they are hard to follow. This book will quickly get you to the point that you can start programming, but you need another book to go beyond that point.
Rating:
Summary: Programming?
Review: This is an excellent book for learning to install, configure and manage SQL Server. However, the the title is a little misleading. The empasis not programming but admin. The few programming examples included are so intermingled with the admin stuff that they are hard to follow. This book will quickly get you to the point that you can start programming, but you need another book to go beyond that point.
Rating:
Summary: Great way to learn enuff to pass MS 70-229!!!
Review: Wow...after learning SQL7 onthejob, I thought the move to SQL2000 would be a snap...and was I wrong. But bought this book, read it -- devoured it, got the client up and running fine and used it as my major learning tool to pass 70-229, the MS exam that I needed for my MCSD certification...and I passed! Great book Robin, now how about I send you what I'm sitting for next and you crank out the book? It'd be nice, but I guess not!Seriously, if you wanna learn SQL2000, then get this book! Jim
| 
