Professional SQL Server 7 Pro Gramming

by Rob Vieira

SQL Server 7.0 offers a wealth of new features for the database developer and some significant improvements on previous versions. This book provides a comprehensive guide to programming with SQL... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 1861002319
• ISBN13: 9781861002310
• Release Date: January 1999
• Publisher: Wrox Press
• Length: 1176 Pages
• Weight: 3.80 lbs.
• Dimensions: 2.0" x 7.3" x 9.2"

Customer Reviews

Should Be On Every DBA's Shelf!

A truely do-it-all book. Robert Vieira has written the Transact-SQL programmer's dream. Not only is it a good reference for the more advanced DBA, but makes a decent beginner's guide (the book is not a "teach yourself", but rather for a beginner who has completed some SQL Server basics). This is the book for the beginner who wants to move through intermediate to advanced topics. The book covers:I. Particulars and History - Building DB Connected Systems, Data Access Models.II. RDBMS - The components of a SQL Server DBIII. Tools of the Trade - Client/Server Network Utilities, Enterprise Manager, DTS, MS DTC, Performance Monitor, Profiler, Query Analyzer, OSQL, Service ManagerThen The Good Stuff:First the basics:IV. The Foundation Statements of T-SQL - Select, Where, ETC.V. Joining Tables - Inner/Outer, Cross, Full, UnionVI. Creating and Altering TablesThen the Intermediate Stuff:VII. Constraints - Primary Keys, Foreign Keys, Unique, Check, Default, Disabling, Rules, TriggersVIII.Normalization and Basic Design Issues - Relationships, Diagramming, De-Normalizing, ExamplesThen the Advanced Stuff:IX. Speeding Performance: Storage and Index StructuresX. Views - Simple, Complex, Editing, etc.XI. Writing Scripts and Batches - OSQLXII. Code Storage: Stored Procedures - Intermediate to Advanced - This is pretty much exhaustivly covered. Includes error handling, control of flow.XIII.Transactions and Locks - More advanced SProc handling, Checkpoints, Locks and Concurrancy, Handling DeadlocksXIV. Triggers - A truely great chapter, untangling what is usually a badly explained subject.And a lot more... Chapters 15 through 25 cover the really advanced subjects like: Advanced Queries, Distributed Queries/Transactions, SQL Cursors, BCP, DTS, Replication (in detail), Advanced DB Design, OLAP (in detail), English Query and Full Text Search, Security (very well done), Performance Tuning (in detail), Advanced Administration.The appendices cover: Global Variables, Functions, Tools, Error Listing, Access Upsizing. An excellent index rounds out the package. If you are worried about coverage on any of the above topics...don't the book is a real luggable (1.5" thick, a couple of pounds in weight).The only other book I would recommend to round out the SQL Server DBA's library would be MS Press' Administrator's Pocket Guide. You really won't need anything else! This book is a must have.

Fantastic SQL Book

This book is somewhat of a rarity to me. Many of the other SQL books are, as you can well imagine, very boring. Rob Vieira does a great job making this book flow from subject to subject in such a way that it's almost a page turner. If you have any interest in SQL design (or admin), I'm sure you will find yourself reading this book much longer than originally intended. It is an excellent job.Rob Vieira obviously has real world experience with SQL Server, and it shows between the covers of SQL Server 7 Programming. I'd suggest you read the book from cover to cover, all along the way picking up little tips and suggestions, remembering what you may have forgotten, and learning a whole lot of new tips and tricks that you never knew (or at least I didn't know about).The book's title doesn't fairly represent the content in my opinion. This book covers almost everything about SQL 7 Server, from T-SQL basics through OLAP, tuning, replication (a great chapter), etc. If there is a "bible" for SQL 7 Server, this book is it.

THIS BOOK SHOULD GET 8 STARS!

This book is THE book when you want to learn SQL Serever 7 Databases. I passed the SQL Server 7.0 Database Design and Implementation exam 70-029 by studying this book! Its VERY clearly written. Anyone who has a concept of what SQL Server does and is, can master it by using this book. And guess what?, it has enough gun powder regarding SQL Server 7.0 to help you actually pass the 70-028 Admin exam as well! Last but not least, it is THE perfect companion for the DBA. I think many managers around the globe will be able to sleep at night if DBA's start using this wonderful book. I had a few problems with some topics...guess what..i e-mailed Mr. Robert Viera asking him to explain those topics. He replied within half a day!....its amazing! A man of such wisdom actually HAS time for his readers....and not only that he sent me a detailed e-mail of several paragraphs! Which i personally think is very impressive.Anyway....what i had to say, said it....now its up to you the reader of this review to either remain in the dark or excel in the glittery world of SQL Server 7.0.I REALLY Recommend this BOOK!

Clear and indepth book by a programer for programers

Most technical books on advanced subjects leave much to be desired. They are often too academic and are for the most part a repeat of the manufacturers standard literature, (for example Microsoft's literature). Robert Viera has written a book that is easy enough for the beginner to follow and yet aimed at the serious professional dealing with real world technical problems. Professional SQL Server 7.0 Programming tacles the challenges that programmers face in the real world and it does it with in-depth discussion and examples. You hardly need to refere to other sources for more information.What's more, I was pleasantly amazed when the author returned my email cry for help within a half hour. I was faced with a Microsoft bug in SQL 7 and Microsoft tech support was no where to be found. Mr. Vieira's prompt response saved the day. I don't expect the author to substitute for Microsoft technical support, but the incident convinced me that he was a working programmer's writing from the view point of a programmer.I look forwards to buying any other books that he will author. How about one on MS Visual Interdev or ASP?

Excellent Book

If you're looking for a well-organized and well-written approach to SQL7, this is the one. I looked at a few other, supposedly high-ranked books, and trust me, this one blows them all away.The material is very broad, yet you never feel overwhelmed, as you move from one topic to another in an orderly and logical fashion. The author is both very technically knowledgeable and actually able to communicate; often a rare combination. In addition, the author's credentials are quite impressive (MCSD, MCDBA), having even participated in the authoring of exam 70-029 (for those of you pursuing certification). While this is not a certification text, all of the topic material is definitely applicable.In terms of depth, this is probably a 7/8 on scale of 10. There are always going to be issues that aren't covered, but that's what BOL and other forums are for. Having said that, I do find the book to be pretty deep, and it does give a detailed overview of all relevant areas.I can't say enough good about this one.