The Super Fun Kids' Graphic Novel Sale

Special Offers see all

Enter to WIN a $100 Credit

Subscribe to
for a chance to win.
Privacy Policy

Visit our stores

    Recently Viewed clear list

    Original Essays | September 23, 2015

    Bryan Doerries: IMG Using Greek Tragedies to Comfort the Afflicted and Afflict the Comfortable

    In ancient Athens, during the fifth century BC, military service was required of all citizens. To be a citizen meant being a soldier, and vice... Continue »
    1. $18.87 Sale Hardcover add to wish list


On Order

New Trade Paper
Currently out of stock.
Add to Wishlist
available for shipping or prepaid pickup only
Qty Store Section
- Local Warehouse Software Engineering- Programming and Languages

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


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


Synopses & Reviews

Publisher Comments:

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,, where additional examples, online forums, and other supplementary materials are available.

Book News Annotation:

A Microsoft MVP tours the Visual Studio IDE and the tools it offers for building data-centric applications, and explains how Visual Studio interacts with SQL Server. Most of the code examples are provided in Visual Basic .NET. The seventh edition takes a broader view of data access development. The DVD contains examples and sample databases.
Annotation 2007 Book News, Inc., Portland, OR (

Book News Annotation:

A Microsoft MVP tours the Visual Studio IDE and the tools it offers for building data-centric applications, and explains how Visual Studio interacts with SQL Server. Most of the code examples are provided in Visual Basic .NET. The seventh edition takes a broader view of data access development. The DVD contains examples and sample databases. Annotation ©2007 Book News, Inc., Portland, OR (

About the Author

WILLIAM R. VAUGHN has worked in the computer industry since 1972. He holds a Bachelor’s degree in Computer Science from Mary Hardin-Baylor and a Master’s degree in Interdisciplinary Studies from the University of Texas. He’s also been awarded an Honorary PhD. from the University of Advancing Computer Technology in Tempe Arizona. Bill spent his early years working in the mainframe data processing industry and transitioned to the personal computer side in the late 70s. Along the way, he worked for the Texas DPS Narcotics Service, EDS (where he was recruited by and worked for Ross Perot), at Mostek/United Technologies, Challenge Systems, Digital Research, and CPT Corporation. After having surfed the PC industry for many years, he began his Microsoft years in 1986 working for the Windows developer liaison team at Microsoft in 1986. For the next 14 years, he worked in various divisions at Microsoft including Microsoft University, the Visual Basic documentation and Visual Studio marketing and Internal Technical Education teams before retiring in 2000 to form his own company, Beta V Corporation. Bill has written seven editions of the popular Hitchhiker’s Guide (the 4th, 5th and 6th published by Microsoft Press) and books for APress, including the bestseller ADO and ADO.NET Examples and Best Practices. Peter Blackburn and Bill also coauthored the Hitchhiker’s Guide to SQL Server 2000 Reporting Services (Addison- Wesley). His latest work is Hitchhiker’s Guide to SQL Server Everywhere–his first e-Book. He writes lead articles for SQL Server Magazine where he is a contributing editor, MSDN, and others. Bill also writes a bi-weekly editorial for Processor.COM magazine. Bill is a top-rated speaker at conferences worldwide, including keynotes and sessions at TechEd, DevWeek, Dev Connections, SQL Connections, VBUG, and many others. He is a Microsoft MVP and a member of the INETA Speaker’s Bureau.


PETER BLACKBURN has worked in the computer industry since 1981. He studied computer science at Cambridge University, England from where he holds an M.A. degree. Through his consulting company, Boost Data Limited, Peter has designed, built, and implemented small- and large-scale database systems including reporting systems based on SQL Server. He has contributed countless hours to the development and honing of Microsoft Reporting Services and remains directly involved with the development team. He is also a Microsoft MVP. He supports developers through newsgroups and beta programs, and trains teams of developers working with SQL Server and Reporting Services. Having worked closely with .NET since before the launch, Peter and Boost Data have ensured the technical accuracy of many leading .NET books. Peter lives in the United Kingdom and travels all over the world to consult, speak, and provide support for his fellow developers, fellow MVPs, his writing team, and Microsoft itself.


Table of Contents

Foreword                         xxi

Acknowledgments            xxiii

About the Authors            xxv

Introduction                     1

Chapter 1                         Exploring Application Architectures      9

Chapter 2                         How Does SQL Server Work?   87

Chapter 3                         Relational Databases 101  245

Chapter 4                         Getting Started with Visual Studio       273

Chapter 5                         Managing Executables with the Server Explorer      349

Chapter 6                         Building Data Sources, DataSets, and TableAdapters        391

Chapter 7                         Managing Data Tools and Data Binding         461

Chapter 8                         Getting Started with ADO.NET   497

Chapter 9                         Getting Connected            549

Chapter 10                       Managing SqlCommand Objects         627

Chapter 11                       Executing SqlCommand Objects         693

Chapter 12                       Managing Updates            749

Chapter 13                       Managing SQL Server CLR Executables         793

Chapter 14                       Creating and Managing Reports 923

Chapter 15                       Summary and Wintry: Where We Are Now   1011

Appendix I                        Installing the Examples and Test Databases  1015

Appendix II                       Reinstalling the DACW and Other Missing Functionality in Visual Studio                                       1021

Appendix III                      Monitoring SQL Server      1025

Appendix IV                      Creating and Managing Server-Side Cursors 1039

Index                               1051


Product Details

Vaughn, William R.
Addison-Wesley Professional
Blackburn, Peter
Blackburn, Peter
Programming Languages - General
Database Management - General
Application software
Database Management - SQL Server
Miscellaneous Software
Application software -- Development.
Software Engineering - Programming and Languages
Edition Number:
Edition Description:
Trade paper
Microsoft Windows Server System Series
Publication Date:
November 2006
Grade Level:
Professional and scholarly
9.1 x 7 x 2.372 in 1755 gr

Other books you might like

  1. Programming ADO with CDROM Used Trade Paper $12.50

Related Subjects

Computers and Internet » Database » Applications
Computers and Internet » Database » Design
Computers and Internet » Database » SQL
Computers and Internet » Software Engineering » Programming and Languages
Computers and Internet » Software Engineering » Software Management
Hobbies, Crafts, and Leisure » Games » General
Science and Mathematics » Mathematics » Algebra » General
Travel » General

Hitchhiker's Guide to Visual Studio and SQL Server: Best Practice Architectures and Examples New Trade Paper
0 stars - 0 reviews
$58.50 Backorder
Product details 1128 pages Addison-Wesley Professional - English 9780321243621 Reviews:
  • back to top


Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at