Professional SQL Server 7.0 Programming

Rating:
Summary: Professional SQL Server 7.0 Programming
Review: I have read both books that Rob Vieira has written on SQL Server (Professional SQL Server 7.0 Programming and Professional SQL Server 2000 Programming) and have found that both books are great for mastering SQL Server. There is still a lot of SQL Server 7.0 applications and databases out there in the real world. If you are assigned to develop or maintain such a database, you need to read this book. You could combine this with Thearon Willis' book "Beginning Visual Basic SQL Server 7.0" to get a better understanding of using SQL Server 7.0 and Visual Basic 5.0/6.0 together (and also ADO/RDO/DAO).

Rating:
Summary: Out of date
Review: I really did not know SQL but after reading this book i passed the SQL MCDBA exams and got certified.

Rating:
Summary: Very good overall
Review: I used this book to prepare for exam 70-029 and have passed with a score of 857. It covers all the topics required for this exam. It is not exactly exam oriented, but makes your foundation of SQL server very strong. I also used transcender to prepare for this exam.

I like Mr Vieira's sense of humor (the key, the whole key and nothing but the key so help you Codd) :-) I didn't have any experience in sql server and found this book very helpful as my first book of sql server.

Rating:
Summary: One of the great book about the subject
Review: Robert did the great job. This is a must have book for people working with MS SQL 7 and later. As IT proffessional, I must say, that this book sets standards how the book for IT professionals (and for MS-SQL server beginners too) should be written.

The book covers in detail not only relational database design and programming issues, but security and administrative issues, data replication and distributed data are cowered in detail as well and in my opinion, is one of the best books ever written about the MS SQL 7 server.

Rating:
Summary: Good SQL Server Book
Review: The book has a great summarization of database concepts in the first few chapters. It discusses thoroughly many concepts surrounding the GUI of SQL Server. Where it lacks though is the discussion of transact-sql. I do not know if I am being overly harsh on this issue, but overall the book was excellent.

I went and purchased The Guru's Guide to Transact-SQL and looked at the Microsoft Press SQL Server book to get additional information. All these books I have mentioned are excellent resources to get a firm handle on SQL Server, not to mention a nice DB Design book for reference.

Rating:
Summary: Damn Good
Review: This book is highly recommended for all DBAs and database developers and mostly for certification aspirants

Rating:
Summary: Becoming a SQL7 master
Review: This book is really invaluable, it has lots of information, on every aspect of SQL7, it covers from the basic things to OLAP, English query and replication, also has an entire chapter on relational tables design (normalization, etc).

The book is very helpfull if you are a SQL7 developer, let's say for a beginner or intermediate user. It wil give you very detailed and technical info, but be carefull, this book isn't a reference of commands, of course it shows how to use the most common commands, but doesn't have a T-SQL reference section (why not Rob?), so you'll need to have at hand the SQL "Books Online" for this job. Also doesn't covers things to make it for advanced programmers (extended stored procedures for example), but it is plenty of tips and tricks and the explanations are very good. For a beginner is excellent, because it will show you how SQL7 works from the back, you'll learn how SQL7 structures the data an such things to make you a great SQL7 programmer.

Rating:
Summary: Best book on SQL Server Ever!
Review: This is a fantastic book. Robert Vieria is a hero. The book has helped me in my work, helped me pass my MCP and very often also made me laugh out loud..... A programming book with a sense of humor.....

Rating:
Summary: The best SQL Server 7.0 Development Book on the Market
Review: This is absolutely the best SQL Server 7.0 development book on the market. I had done a reasonable amount of SQL Server 6.x development in the past, but then spent almost two years working on other things. When a client asked me to do a 7.0 project I went rushing out for a book to get me back up to speed. I bought this one based on the previous reviews and it was some of the best money I've ever spent on a programming book.

Robert is obviously a professional SQL Server programmer who clearly understands exactly what's important and what's not. He's also an excellent writer, which makes the book a very enjoyable read. This book is not for beginners or academics, but for working programmers. Robert wastes no time on unnecessary introductory-level material or obscure technical details that you're unlikely to ever need. He gets right to the point and stays there.

I'd usually indicate which parts of a book I thought were particularly noteworthy, but after flipping back through the chapters I have to say this book is just uniformly excellent. My only complaint, which unfortunately applies to almost every programming book I've bought over the past few years, is that the book contained numerous minor typographical errors. This was a failure on the part of the editors, however, and none of the typos interfered with the technical quality of the material.