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[md]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. While carrying forward the industry-accepted concepts introduced in earlier editions, the 7th edition is greatly expanded to include in-depth discussions of new technologies such as SQL Server CLR executables and new reporting paradigms. 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 topics include
- Application Architectures and how to choose between 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?
- 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 ADO.NET 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 while 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. He got his start in the industry 35 years ago and has worked in the mainframe, process-control, and personal-computer industries as a developer, architect, manager, writer, product manager, trainer, and speaker. His specialty is data access interfaces especially when connecting to SQL Server--over the years he's written 11 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.
