The Sybase SQL Server Survival Guide - Softcover

Panttaja, Jim; Panttaja, Mary; Bowman, Judy

Softcover

ISBN 10: 0471127450 ISBN 13: 9780471127451

Publisher: Wiley, 1996

Synopsis

A complete, hands-on guide for database programmers and developers

"In the past, the developer needed access to a great collection of experience and folklore to be successful with SQL Server. The goal of this book is to provide the lessons that we have learned...to help you avoid some of the common (and not so common) mistakes that affect most projects." —the Authors

If you are a database developer or programmer working with Sybase System 11 SQL Server, this book can save you many frustrating hours of trial and error while schooling you in hard-to-find techniques for streamlining the development process. Acting as your private tutors, Jim and Mary Panttaja, founders of one of the nation's most prestigious client/server computing and relational database consulting groups, and Judy Bowman, an SQL educator, supply you with a wealth of tips and tricks for developing powerful business applications with Sybase SQL Server. Examining both underlying theory and day-to-day operations, The Sybase SQL Server Survival Guide gives you:

• Practical guidance on client/server application architecture, locking, transaction management, concurrency control, and other key technical issues
• Expert tips on database design, index selection, tuning, code generation, and many more common (and uncommon) problems
• Comprehensive directions on getting the most out of new System 11 features like named caches, variable I/O, LRU and MRU cache strategy, and heap table partitioning

A gold mine of valuable tricks and tips on everything from administration and performance tuning to application partitioning and troubleshooting, this book is certain to become one of the most-used volumes in your working library.

About this title

About the Author

JIM PANTTAJA is a founding partner in Panttaja Consulting Group, Inc. He has 20 years of experience in computer software. His main areas of expertise are database system performance evaluation, tuning, and training.

ARY PANTTAJA is a founding partner in Panttaja Consulting Group, Inc. Her areas of expertise are project planning, application architecture, solution design, and technical appropriateness.

JUDY BOWMAN is a well-known SQL and Sybase expert and computer book author.

"In the past, the developer needed access to a great collection of experience and folklore to be successful with SQL Server. The goal of this book is to provide the lessons that we have learned...to help you avoid some of the common (and not so common) mistakes that affect most projects." —the Authors

If you are a database developer or programmer working with Sybase System 11 SQL Server, this book can save you many frustrating hours of trial and error while schooling you in hard-to-find techniques for streamlining the development process. Acting as your private tutors, Jim and Mary Panttaja, founders of one of the nation's most prestigious client/server computing and relational database consulting groups, and Judy Bowman, an SQL educator, supply you with a wealth of tips and tricks for developing powerful business applications with Sybase SQL Server. Examining both underlying theory and day-to-day operations, The Sybase SQL Server Survival Guide gives you:

• Practical guidance on client/server application architecture, locking, transaction management, concurrency control, and other key technical issues
• Expert tips on database design, index selection, tuning, code generation, and many more common (and uncommon) problems
• Comprehensive directions on getting the most out of new System 11 features like named caches, variable I/O, LRU and MRU cache strategy, and heap table partitioning

A gold mine of valuable tricks and tips on everything from administration and performance tuning to application partitioning and troubleshooting, this book is certain to become one of the most-used volumes in your working library.

Edition details

• Publisher: Wiley
• Publication date: 1996
• Language: English
• ISBN 10: 0471127450
• ISBN 13: 9780471127451
• Binding: Paperback
• Edition number: 1
• Number of pages: 359