Hitchhiker's Guide to Visual Studio and SQL Server: Best Practice Architectures and Examples

  Author:    Peter Blackburn, William R. Vaughn
  ISBN:    0321243625
  Sales Rank:    476524
  Published:    2006-11-06
  Publisher:    Addison-Wesley Professional
  # Pages:    1128
  Binding:    Paperback
  Avg. Rating:    5.0 based on 10 reviews
  Used Offers:    8 from $32.98
  Amazon Price:    $37.79
  (Data above last updated:  2008-10-10 08:20:24 EST)
  
  
Sort customer reviews by:
  
Show All Reviews on Page      Hide All Reviews on Page
   
  
Hitchhiker's Guide to Visual Studio and SQL Server: Best Practice Architectures and Examples
  

Since 1994 when he wrote his first “Hitchhiker’s Guide”, William Vaughn has been providing developers all over the world the intimate details of how SQL Server can be accessed and managed from RAD languages like Visual Basic and Visual Basic .NET. With the 7th Edition, Bill has completely rewritten this encyclopedic work from cover to cover–giving readers his insightful views on how applications should be built to maximize both developer and code performance. Visual Studio and the languages it hosts have never been as sophisticated as they are today–the same can be said for SQL Server. This makes it even more important for developers to understand how to best leverage their features without being held back by their complexity. That’s what this book is all about–making it easier for developers regardless of their know-how.

The 7th edition is unique in that it’s designed to provide not only up-to-date tutorials on the latest development tools provided by Visual Studio and SQL Server, but also a solid platform of architectural advice and rich examples for developers trying to choose between the myriad of platform options. Beginners and experts alike will find comprehensive step-by-step instructions that can make the reader’s introduction to the latest versions of Visual Studio and SQL Server far easier.

Key topic coverage includes:

• Data access architectures and how to choose the best strategy for Windows Forms, ASP.NET, XML Web Services, and SQL Server CLR executables. Where

do these make sense and how much will they cost to build and maintain?

• SQL Server and relational database fundamentals and inner-machinery.

How does SQL Server work and why is it important that developers know?

• Making the development experience more productive through judicious use of the Visual Studio toolset, and how to know when the wizards can help.

• Using the latest ADO.NET data provider efficiently and safely.

• How to protect the security of your database–and your job–by avoiding common mistakes.

• How to build secure, efficient, scalable applications in less time with fewer resources–how to create faster code faster.

• How to leverage the potential of SQL Server CLR executables and knowing

when these features make sense.

• How to work with your DBA to maintain database integrity and security.

• Working with the new Visual Studio report controls to expose your

organization’s data safely and easily with or without leveraging existing

SQL Server Reporting Services technology.

William R. Vaughn is the President of Beta V Corporation and a Microsoft MVP. In 2000 he retired from Microsoft after 14 years to focus on mentoring, speaking, and writing. His specialty is data access application design especially when connecting to SQL Server–over the years he’s written 12 books on the subject. He’s a popular speaker at technical conferences all over the world where his wit and no-holds-barred technical insights win him rave reviews. William is also a member of the prestigious INETA Speaker’s Bureau. His works include articles for SQL Server Magazine and a bi-weekly editorial for Processor Magazine as well as books published by Microsoft Press and Apress.

The book includes a DVD that contains a wealth of examples as well as several sample databases used to illustrate points discussed in the book. Authenticated readers will also have unrestricted access to the book’s supporting web site, www.hitchhikerguides.net, where additional examples, online forums, and other supplementary materials are available.

www.awprofessional.com/msserverseries

www.hitchhikerguides.net

www.betav.com/blogs/billva

www.betav.com

                  Reader Reviews 1 - 13 of 13                 
  
  
Review
Date
Review
Rating(5 High)
Review
Helpful
to:
Customer Review Reviewer
Info
Permanent
Link
Reader Reviews Below Sorted by Newest First
07-04-08 2 (NA)
(Hide Review...)  Verbose
Reviewer Permalink
Simply put: This guy talks too much. I want a book that can show me how to do things and move along. This author likes using acronyms in his writings (LOL, FWIW, AFAIC, etc.) without providing a glossary for them. Some I know, but not all. I'm sure there is good information in it, but I just don't have a year to read this. I need to develop now! Does anyone want to buy my copy of this book? I'll be happy to sell it to you!
(Review Data Last Updated: 2008-10-08 06:47:29 EST)
02-29-08 5 (NA)
(Hide Review...)  Great Book for Understanding SQL Sever and ADO
Reviewer Permalink
I have been programming for years and didn't really realize how much I didn't know.

Mr. Vaughn has been building databases and writing code against them since the beginning. His explanations of DB and ADO evolution is something that every webApp/dba should know.

The book is a fast read, imformative with lots of .Net examples.

Thanks for writing such a great book. I am excited to get the next version.

(Review Data Last Updated: 2008-07-04 19:22:00 EST)
07-03-07 5 (NA)
(Hide Review...)  Great!!
Reviewer Permalink
I am very inmpressed with this book! This is one that will be dog earred.
(Review Data Last Updated: 2008-03-01 21:28:05 EST)
06-11-07 5 (NA)
(Hide Review...)  A must own for DBAs and Developers
Reviewer Permalink
This is truly an outstanding book. Not only is it extremely well written and "readable" (unfortunately many a tech book is not these days), I feel it begins a dialog of sorts between the developer side of the fence and the database side of the fence (were that there were no fences, alas).

I've visited far too many organizations that work in near complete isolation when developing applications. For those types of organizations, no tool like Team System will improve things: if they don't collaborate already, a tool won't get them to do so.

We need more books like this in the market. Today's technology is so complex you simply can not perform your role properly without understanding the larger picture.
(Review Data Last Updated: 2007-07-07 23:00:56 EST)
03-10-07 5 (NA)
(Hide Review...)  Excellent Book
Reviewer Permalink
I'm a C programmer, new to SQL and Windows programming.

Bill's book has gotten me up to speed on SQL Server and Visual Studio in record time.

I looked at a number of books on these subjects and this one definitely stands out as being the most comprehensive. At the same time, it is easy to follow.

I highly recommend the book.
(Review Data Last Updated: 2007-07-07 23:00:56 EST)
03-09-07 5 (NA)
(Hide Review...)  Excellent Book
Reviewer Permalink
I'm a C programmer, new to SQL and Windows programming.

Bill's book has gotten me up to speed on SQL Server and Visual Studio in record time.

I looked at a number of books on these subjects and this one definitely stands out as being the most comprehensive. At the same time, it is easy to follow.

I highly recommend the book.
(Review Data Last Updated: 2007-04-11 12:02:40 EST)
02-02-07 4 1\1
(Hide Review...)  A treasure chest of SQL gems
Reviewer Permalink
Reading the book, it is clear why Bill is a Microsoft MVP. I appreciate how Peter and he precisely describe and assess this complex landscape, including traps and warts. I believe you will also appreciate their deep knowledge.

Depending where you are on your journey to designing and building powerful solutions with SQL Server and Visual Studio, some of the chapters will be more valuable than others. I assure you that there will be sections of the book that are exactly what you need. The knowledge can keep you from making big mistakes, either in your selection of which version of SQL Server to use, in architecture and design, or simply in trying to figure out the myriad of implementation choices you might otherwise try on your own through days and days of trial and error.

As a software program manager, I appreciated gaining an overall appreciation for how the technologies and techniques need to fit together to deliver a successful solution. I especially appreciated the early chapters on architecture, the flowchart showing how to debug a connection on page 142, and other advice scatter through the book.

In subsequent books or articles from these authors, I'd appreciate more architectural graphics, e.g. showing various data access layers, and also a description of how AJAX techniques affect how we should think about building data-centric web applications.

I expect this book to be a valuable reference for many years to come.
(Review Data Last Updated: 2007-07-07 23:00:56 EST)
01-29-07 5 2\2
(Hide Review...)  Thank you Bill for another great journey.
Reviewer Permalink
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.
(Review Data Last Updated: 2007-07-07 23:00:56 EST)
01-13-07 5 5\5
(Hide Review...)  This book is excellent
Reviewer Permalink
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.
(Review Data Last Updated: 2007-07-01 16:42:09 EST)
01-12-07 5 2\2
(Hide Review...)  This book is excellent
Reviewer Permalink
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.
(Review Data Last Updated: 2007-01-29 19:30:32 EST)
11-28-06 5 9\9
(Hide Review...)  In true "Hitchhiker" tradition
Reviewer Permalink
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.
(Review Data Last Updated: 2007-07-01 16:42:09 EST)
11-27-06 5 5\5
(Hide Review...)  In true "Hitchhiker" tradition
Reviewer Permalink
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.
(Review Data Last Updated: 2007-01-12 14:31:35 EST)
11-20-06 5 3\4
(Hide Review...)  try understanding stored procedures
Reviewer Permalink
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.
(Review Data Last Updated: 2006-11-27 16:10:08 EST)
  
                  Reader Reviews 1 - 13 of 13                 
  
  
  
  
  
  

Because the data used to generate this site come from outside sources, VeryWellSaid.com cannot guarantee the completeness or accuracy of the data.
Search VeryWellSaid™
Google
Web VeryWellSaid™
New subjects are added every week.
View Subjects Below by:
* Top Selling
 (click category name, left)
* Top-Rated Top Sellers
 (click 'Top Rated', right)
In the news...  
Dubai\UAE Top Rated
Influenza\Bird Flu Top Rated
Iraq Top Rated
Supreme Court Top Rated
All Books Top Rated
Arts Top Rated
Photography Top Rated
Digital Photography Top Rated
Digital Cameras Top Rated
Biography Top Rated
Business Top Rated
Management Top Rated
Marketing Top Rated
Sales Top Rated
Stocks Top Rated
Bonds Top Rated
Real Estate Top Rated
Trading Top Rated
Commodities Trading Top Rated
Time Management Top Rated
Starting A Business Top Rated
Children's Top Rated
Comics Top Rated
Computers Top Rated
PC Top Rated
Mac Top Rated
Programming Top Rated
Design Patterns Top Rated
.Net Top Rated
C# Top Rated
Vb.Net Top Rated
Asp.Net Top Rated
Java Top Rated
Python Top Rated
PHP Top Rated
Perl Top Rated
Javascript Top Rated
Ajax Top Rated
CSS Top Rated
Open Source Top Rated
SQL Top Rated
Databases Top Rated
Oracle Top Rated
MySql Top Rated
Sql Server Top Rated
IIS Top Rated
Apache Top Rated
Linux Top Rated
Windows Server Top Rated
Project Management Top Rated
HTML Top Rated
UML Top Rated
IT Certifications Top Rated
Cisco Certifications Top Rated
MCSE Top Rated
MCSD Top Rated
Cooking Top Rated
Italian Cooking Top Rated
Vegetarian Cooking Top Rated
Wine Top Rated
Engineering Top Rated
Entertainment Top Rated
Health Top Rated
Nutrition Top Rated
Dieting Top Rated
Sex Top Rated
History Top Rated
Military History Top Rated
British History Top Rated
Middle East History Top Rated
Land Battles Top Rated
Naval Warfare Top Rated
Air Warfare Top Rated
9/11 Top Rated
Terrorism Top Rated
Home Top Rated
Mortgage\Home Equity Loan Top Rated
Cars Top Rated
Car Buying Top Rated
Sports Cars Top Rated
Cat Top Rated
Humor Top Rated
Horror Top Rated
Law Top Rated
IP Law Top Rated
Legal History Top Rated
Fiction Top Rated
Oprah's Book Club Top Rated
Medicine Top Rated
Cancer Top Rated
Stroke Top Rated
Heart Disease Top Rated
Fertility Top Rated
Diabetes Top Rated
Pharmacology Top Rated
Back Problems Top Rated
Menopause Top Rated
Thyroid Top Rated
Pain Top Rated
Organic Chemistry Top Rated
Immune System Top Rated
Mystery Top Rated
Nonfiction Top Rated
Outdoors Top Rated
Running Top Rated
Radio Control Models Top Rated
Guns Top Rated
Parenting Top Rated
Divorce Top Rated
Professional Top Rated
Reference Top Rated
Religion Top Rated
Romance Top Rated
Science Top Rated
Physics Top Rated
Chemistry Top Rated
Astronomy Top Rated
Psychology Top Rated
Science Fiction Top Rated
Sports Top Rated
Teens Top Rated
Travel Top Rated
USA Top Rated
Europe Top Rated
France Top Rated
Italy Top Rated
England Top Rated
China Top Rated
All Books Arts Biography Click Here For An A-Z Index Of All 213 Best-Seller Subjects Business Children's Comics
Computers Cooking Engineering Entertainment Health History Home Horror Humor Law Fiction Medicine Mystery
Nonfiction Outdoors Parenting Professional Reference Religion Romance Science Sci-Fi Sports Teens Travel
In Association with Amazon.com

Cache miss
(not cached)