The Guru's Guide to Transact-SQL

• Includes extensive real-world Transact-SQL sample code and practical exercises.
• Tutorial section walks through the entire development process, from inception to deployment and beyond.
• Powerful techniques for performance tuning, multi-tier development, concurrency control, and more.

In The Guru's Guide to Transact-SQL, one of the world's leading Microsoft SQL Server 7 developers has written the ideal combination of tutorial and reference, bringing together all the information and skills developers need to create outstanding database applications. Beginners and intermediate developers will appreciate the comprehensive tutorial that walks step-by-step through building a real client/server database, from concept to deployment and beyond -- and points out key pitfalls to avoid throughout the process. Experienced users will appreciate the book's comprehensive coverage of the Transact-SQL language, from basic to advanced level; detailed ODBC database access information; expert coverage of concurrency control, and more. The book includes thorough, up-to-the-minute guidance on building multi-tier applications; SQL Server performance tuning; and other crucial issues for advanced developers. For all database developers, system administrators, and Web application developers who interact with databases in Microsoft-centric environments.

Kenneth W. Henderson is one of the industry's leading RDBMS practitioners, consulting on high-end client/server projects and specializing in VLDB implementations. His clients include the U.S. Air Force, the U.S. Navy, H&R Block, Travelers Insurance, JP Morgan, the Central Intelligence Agency, Owens-Corning, and CNA Insurance. He is author of five previous books on client/server and DBMS development.