Beginning SQL Server 2000 for Visual Basic Developers [Paperback]

Thearon Willis (Author)

Book Description

ISBN-10: 1590592735 | ISBN-13: 978-1590592731 | Publication Date: September 2, 2003

This is the only book that provides comprehensive coverage of SQL Server 2000 specifically from a Visual Basic programmer's point of view. SQL Server is now the first choice for the Visual Basic developer wanting a more powerful, reliable and sophisticated database than MS Access can provide. SQL 2000, is tightly integrated with Windows 2000, offering more support for XML and much improved OLAP (Online Analytical Processing) services.

This book is for VB developers who want to integrate SQL Server 2000 into their applications. It covers everything needed to work with SQL Server 2000, including topics such as SQL Server 2000 tools, managing database security, building and deploying English query applications, and more.

The Jet database engine, which has traditionally powered Access, is gradually being replaced by the Microsoft Database Engine (MSDE), a limited-client version of the SQL Server engine (but without the front-end tools such as Enterprise Manager). This means that VB developers traditionally used to using a single-file database now have to cope with the client-server architecture of SQL Server. This is a big conceptual leap, and many VB developers struggle to make it. This book is designed to help developers make that leap as easily as possible, and to show them how to use the full range of SQL Server's powerful tools within their VB applications.

Editorial Reviews

From the Publisher

This book is aimed at intermediate and advanced Visual Basic developers who already have some experience working with some other type of relational database including Microsoft Access. Experience with Microsoft ActiveX Data Objects is also assumed but not required. --This text refers to an out of print or unavailable edition of this title.

About the Author

Thearon Willis is a senior consultant with 19 years of IT experience. He is a consultant for an international insurance company that provides web programming services. His web development tools of choice are ASP, dynamic HTML, Visual Basic, and SQL Server.

Product Details

• Paperback: 861 pages
• Publisher: A-Press (September 2, 2003)
• Language: English
• ISBN-10: 1590592735
• ISBN-13: 978-1590592731
• Product Dimensions: 9 x 7.3 x 1.8 inches
• Shipping Weight: 3 pounds
• Average Customer Review: 4.8 out of 5 stars  See all reviews (14 customer reviews)
• Amazon Best Sellers Rank: #3,072,692 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

11 of 11 people found the following review helpful:

5.0 out of 5 stars This book is great, July 30, 2001

By A Customer

This review is from: Beginning SQL Server 2000 for Visual Basic Developers (Paperback)

After working on mainframe applications for the last 17 years, I was put into a new group and expected to write an application in VB and SQL Server. I was completely lost! With this book, I felt like the author was sitting next to me answering all the questions I had about how to make my stuff work. In just a week, I went from knowing virtually nothing to being able to finish the first part of the project I'm working on. The other books I had looked at either were too advanced (come on - I've been working in '70's technology!) or were for beginning programmers. It was well-written, easy to follow, and answered all my questions. I would recommend this book for programmers new to SQL Server.

7 of 7 people found the following review helpful:

5.0 out of 5 stars Information Promise - Information delivered, April 12, 2002

By 

Active Trader "prchrist3" (Kaysville, UT United States) - See all my reviews

This review is from: Beginning SQL Server 2000 for Visual Basic Developers (Paperback)

I have just finished Thearon Willis's book and I feel that my money was well spent. I am a Visual Basic programmer that has been working with Oracle for the last 5 years and I felt the need to get up to speed with SQL Server 2000. Per the title of the book I am a BEGINNER with SQL Server and this book met my needs exactly.

I actually read the book and manually coded all the examples to build the test projects. Kudos to Mr. Willis for actually testing the code that he put in the book. All examples except one (for the stored procedure for temporary tables, you have to add SET NOCOUNT ON to the script), worked as they were supposed to.

The book went into great detail on the logic and function of code used. Every line of code was explained clearly and concisely. I believe the section on XML was superb. I have struggled through a couple of short courses on XML and was left confused and discouraged. This book helped all the pieces fall into place and gave me the confidence and knowledge to actually create XML projects for the real world.

Sample code is available for download from Wrox and they do respond to requests for help (the SET NOCOUNT ON issue) in a few days.

7 of 7 people found the following review helpful:

5.0 out of 5 stars Perfect for beginners, December 19, 2000

By 

Jerry D Sevier Jr (Tucson, Arizona) - See all my reviews

This review is from: Beginning SQL Server 2000 for Visual Basic Developers (Paperback)

I had never touched SQL Server, nor was my programming up to par. However, Thearon Willis' style is easy to follow and fills in the learning curve nicely. After reading this book, I had a strong foundation needed to tackle most of the database requirments of my company.