Hitchhiker's Guide to Visual Studio and SQL Server: Best Practice Architectures and Examples [With CDROM]

I am very inmpressed with this book! This is one that will be dog earred.

So, you want to program SQL Server 2005 using Visual Basic 2005. Then you should buy this book. No one does things quite as Bill does. In a tour-de-force effort, Bill, with the some help from Peter, shares a treasure trove of valuable information about how to build the best data-enabled applications regardless of your skill level. Bill's a master and his experience with SQL Server is legendary. What's even better is you get Bill's candid view on things. He's not afraid to tell you what works and what doesn't. He takes his job as an author seriously. At over 1000 pages, this is a serious book. The range of topics covered is rich. Bill covers writing code by hand and using drag & drop. He compares new features like CLR stored procedures with more traditional approaches and he backs up his opinion with code and tests. Bill has filled this seventh (yes, he's been doing this a while) edition with annotated screen shots, code listings, and thoughtful commentary--all of which help you, dear reader, to have a safe and happy journey. For the price of this book, you're getting priceless amounts of help and guidance. Buy it now.

Bill Vaughn is a stickler for attention to detail. I wouldn't want to work for him :-) but it is truly priceless to have his knowledge, experience, and expertise handy in book form when you are faced with taming the beast that is SQL Server 2005, and programming against it. No stone is left unturned in this book, in true Bill Vaughn fashoin. He not only nails the fundamentals, but offers countless insights that come from experience, as well as a a never-ending supply of his famously dry and searing humor. I would pay twice the cost of this book for the utility I'm getting out of it.

Bill Vaughn's Hitchhiker's series has been on my bookshelves since the first edition. I've always acknowledged Bill as one of the industry experts in SQL Server and his knowledge of the subject is well illustrated in the latest addition to his book series. The "Hitchhiker's Guide to Visual Studio and SQL Server" can very well become the one "bible" you need on this topic if you insist on having only one book on any particular topic. There are many books on SQL Server out there, each with their strengths and weaknesses, but the Hitchhiker's Guide explains things in plain English while still appealing to the techie in me. Great job - again - as can only be expected from the author. Oh, and if you throw it at somebody, you are likely to kill them.

In sometimes pungent commentaries, Vaughn and Blackburn give a detailed education about properly using SQL Server, where Visual Studio is also used, to make the front end code. There is a tangled history of how Microsoft developed SQL Server, Visual Studio and accompanying languages like Visual Basic .NET and ADO.NET. With perfect hindsight, the development trajectory performed by Microsoft might have been unnecessarily complex. But the book deals with SQL Server and Visual Studio as they now exist in the latest versions, as something you have to deal with. There is a brief chapter going over the basics of relational databases, and how to design a set of tables for your data. Generic stuff. But most of the text deals with many details specific to SQL Server. Out of the book's bulk, perhaps a key focus for you should be how to write and edit stored procedures. Vital in improving the efficiency of your overall system, by eliminating unneeded data flows from the server to the front end machine and back. Chapter 5 discusses these stored procedures. Forget for a moment about all that UI stuff. There is plenty of discussion in the book about that topic. Instead, you should try to clearly understand this chapter and be able to confidently write such stored procedures. Unglamorous backend details, but essential.