The most comprehensive book available on th Sybase SQL Server today, this book enables readers to gain a knowledge of the programming and database administration aspects behind this popular RDBMS (relational database management system). The CD-ROM includes the Aurora Desktop, a compact SQL editor with some of the features of the full-size Aurora Script Manager.

Based on the author's vast experience with Sybase product installation and upgrade, this book presents valuable advice that could only come from a Sybase insider. Advice is given on the "best practices" for installation and upgrade from SQL Server 4.0 or SQL Server 10 to SQL Server 11. 50 illus.

A developmental guide, this book covers stored procedures and triggers, query optimization, the APT workbench, and other features that help developers build fast and efficient client/server applications. this book covers the new Sybase SQL Server 11, which has improved administration performance and enhanced networking capabilities.

Covers features of System 11, with descriptions on how to install and use Systems 10 and 11, and how to migrate from version 4X. The manual contains tips, problems, solutions and worked examples. It is intended for application developers and system adminis

Focusing on the essentials of Sybase SQL Server 11, this book/CD-ROM package is an ideal reference and workbook for both new and experienced Sybase users. It provides well-organized summaries of product features and functions plus a wealth of examples, tips, and note on how administrator actions affect system internals. The CD-ROM contains the examples and exercises from the book, along with complete System 11 technical documentation. 50 illus.

Configure, Tune, and Exploit the full Power of SYBASE® SQL Server 11 Learn the capabilities and features of Transact-SQL (Part II) Learn how to analyze query plans (Chapter 14) Back up your database and learn efficient data recovery techniques (Chapter 29) Discover how to bypass the optimizer (Chapter 16) Secure your database from data loss and unauthorized access (Chapter 27) Configure and tune your database to conform to your specific needs (Chapters 30 &31) Measure performance and use benchmarks to identify key problems (Chapter 32) The new release of SQL Server11 is packed with power, breaking many previous SYBASE SQL Server benchmarks-achieving over a 100% improvement over both SQL Server 4.9 and 10. With all this new power at your command, you need a comprehensive book to detail the best ways to program, tune, and administer your databases. SYBASE SQL Server 11 Unleashed is that book. Between its covers you'll find information on installation, Transact-SQL programming, performance tuning, measuring performance, transaction management, security, remote server management, and other key SQL Server 11 topics. Put the full potential of SQL Server 11 to work for you with SYBASE SQL Server 11 Unleashed. The companion CD-ROM includes trial software form Northern Lights Software: Northern Lights Aurora Desktop Aurora Cost Retrieval DLL Aurora Script Manager Plus trial software from other leading companies, including: Analytical Solutions, Incorporated Sylvain Faust StarWare Connectivity Software And Visible Analyst Workbench, an I-CASE tool worth $595.00! Ray Rankins currently consults and instructs on topics including SQL Server administration, performance and tuning, and client/server database application design. Since 1989, Jeffrey R. Garbus has taught thousands of programmers, systems administrators, and database designers about SYBASE administration and tuning. David Solomon writes, speaks, teaches, and consults on SYBASE SQL Server design, application, and implementation. Bennett W. McEwan is the Manager of Software Development for Northern lights Software. He has been responsible for the development of the aurora Utilities suite since February 1995.

Going beyond basic database knowledge to understanding the whys and hows behind the administration process, this book takes the reader through job responsibilities and planning to implementation and performance monitoring. Checklists are included to guide the reader through various tasks.