Sybase Books

Sybase 15.0 Replication Server Administration

Saroj Kapoor Bagai, Jagan Bandi Reddy

Amazon Price: $29.67 List Price: $44.95 Usually ships in 24 hours By: Wordware Publishing, Inc. Amazon Marketplace: 13 new & used starting at $28.08

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Computer Science -> General AAS
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> SQL -> Sybase

Editorial Review:

Sybase 15.0 Replication Server Administration addresses the needs of a wide range of database professionals, explaining to both beginners and experts how to administer Sybase's newest Replication Server release. This book examines all the necessary knowledge, background information, and conceptual frameworks to get started on installing and administering Sybase Replication Server, and explores the world of contemporary cross-platform compatible Sybase Replication Server administration.

Implementing Database Security and Auditing: Includes Examples for Oracle, SQL Server, DB2 UDB, Sybase

Ron Ben Natan

Amazon Price: $57.55 List Price: $63.95 Usually ships in 24 hours By: Digital Press Amazon Marketplace: 13 new & used starting at $41.99

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Home Computing -> Internet -> General AAS
Subjects -> Computers & Internet -> Business & Culture -> Privacy
Subjects -> Computers & Internet -> Certification Central -> Exams -> Security+

Customer Reviews:
Total reviews: 10 Average rating: 5.0 of 5

Editorial Review:

This book is about database security and auditing. You will learn many methods and techniques that will be helpful in securing, monitoring and auditing database environments. It covers diverse topics that include all aspects of database security and auditing - including network security for databases, authentication and authorization issues, links and replication, database Trojans, etc. You will also learn of vulnerabilities and attacks that exist within various database environments or that have been used to attack databases (and that have since been fixed). These will often be explained to an "internals" level. There are many sections which outline the "anatomy of an attack" - before delving into the details of how to combat such an attack. Equally important, you will learn about the database auditing landscape - both from a business and regulatory requirements perspective as well as from a technical implementation perspective.

* Useful to the database administrator and/or security administrator - regardless of the precise database vendor (or vendors) that you are using within your organization.
* Has a large number of examples - examples that pertain to Oracle, SQL Server, DB2, Sybase and even MySQL..
* Many of the techniques you will see in this book will never be described in a manual or a book that is devoted to a certain database product.
* Addressing complex issues must take into account more than just the database and focusing on capabilities that are provided only by the database vendor is not always enough. This book offers a broader view of the database environment - which is not dependent on the database platform - a view that is important to ensure good database security.

Administrator's Guide to Sybase ASE 15

Jeffrey R. Garbus, Ashish Gupta

By: BPB Publications Amazon Marketplace: 2 new & used starting at $48.78

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> SQL -> Sybase
Subjects -> Computers & Internet -> Software -> General

The Official New Features Guide to Sybase ASE 15

Brian Taylor, Carrie King Taylor, Naresh Adurty, Steve Bradley

Amazon Price: $29.67 List Price: $44.95 Usually ships in 24 hours By: Wordware Publishing, Inc. Amazon Marketplace: 27 new & used starting at $11.94

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> SQL -> Sybase
Subjects -> Computers & Internet -> Databases -> General

Customer Reviews:
Total reviews: 1 Average rating: 5.0 of 5

Editorial Review:

Sybase Adaptive Server Enterprise 15 is a high-performance, mission-critical database management system designed to meet the increasing demands of large databases and high-transaction volumes, while providing a cost-effective database management system. The Official New Features Guide to Sybase ASE 15 focuses on the many enhancements in Sybase ASE 15 including semantic partitions, computed columns, functional indexes, and scrollable cursors.

With this book: * Learn about the enhancements to ASE 15, how the new features can increase your efficiency and productivity, and how these features integrate with existing systems. * Understand how semantic partitions decrease the complexities of data management. * Find out how scrollable cursors and computed columns can ease the development process. * Learn how the optimizer toolset and QP Metrics improve monitoring and diagnostic efforts. * Provide the ability to ensure customer compliance through the use of Sybase Software Asset Management. * Test your knowledge with the included Sybase certification practice exam.

Sybase SQL Server 11 Unleashed

Ray Rankins

List Price: $59.99 By: Sams Amazon Marketplace: 14 new & used starting at $4.72

Buy at Amazon.com

Browse similar items by category:
Subjects -> Business & Investing -> Industries & Professions -> MIS
Subjects -> Computers & Internet -> Computer Science -> Software Engineering -> Information Systems
Subjects -> Computers & Internet -> Databases -> Database Management Systems

Customer Reviews:
Total reviews: 14 Average rating: 5.0 of 5

Very good but a few things are missing 5 out of 5 stars.
7 of 7 people found this review helpful.

This is an excellent Sybase book (probably the best one on the topic), however I still have to go to sybooks.sybase.com for certain things. For example, sp_changedbowner (to change a database owner) isn't mentioned anywhere.

The ONLY Sybase book around 5 out of 5 stars.
7 of 7 people found this review helpful.

This book is copyrighted 1996 but don't let that fool you. It is still the best book on Sybase ASE available. Of course this might say more about the efficacy of Sybase than the book, but we aren't reviewing RDBMs here.

There are a few things that are lacking in this book but if you are just starting out with Sybase, either coming from another RDBMs or starting from scratch, this is it. A second revision would be most welcome as would a 'Sybase on Linux Unleashed'.

To sum it up, if you want to use Sybase, buy this book.

Editorial Review:

The new release of SQL Server 11 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.

SYBASE TRANSACT SQL GUIDELINES BEST PRACTICES

Mich Talebzadeh, Ryan, Thomas Putnam

Amazon Price: $42.73 List Price: $45.00 Usually ships in 24 hours By: ISOSF Software Amazon Marketplace: 19 new & used starting at $32.00

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> SQL -> Sybase
Subjects -> Computers & Internet -> Databases -> SQL -> General

Customer Reviews:
Total reviews: 15 Average rating: 4.5 of 5

voluminous and uneven 3 out of 5 stars.
6 of 6 people found this review helpful.

Sybase Transact SQL Programming Guidelines and Best Practices A Practitioners Approach through Example. (Mich Talebzadeh and Ryan Thomas Putnam)

Like its title, this is a long book; it encompasses 32 chapters and 9 appendices in 750 pages. Despite its title, it is intended for database designers and administrators as well as programmers. The authors appear to be consultants and, judging by their examples, work primarily in the financial arena. The book covers a wide range of Sybase features and includes some functionality as recent as ASE 12.5.2.

The first five chapters briefly cover batches, indexes, fragmentation, search arguments, and, to a limited degree (e.g., only one form of the case statement is listed), best practices. Chapter six addresses tempdb in detail. A short chapter on sort operations is followed by a long one on query tuning. Considerable coverage on reading showplan output is provided. Next are cursors, including a welcome section on alternatives (although the read-only example does not follow their best practice of checking @@SQLSTATUS after the last fetch), joins (but not outer joins), and isolation levels. The next three chapters address locking issues, followed by stored procedure and trigger chapters. After a detour to showplan, optimizer hints are discussed. The various datatypes are listed followed by control-of-flow logic, remote procedure calls, the execute immediate statement (mentioned with disfavor), and key generation (both sequential and random). Functions used with various datatypes are next. Code examples for computing medians, modes, means, and variances are presented. (However, the claim that "calculating any nth percentile is very easy within ASE" would seem to pale in comparison with builtin functions in other DBMSs.) Next the authors cover data purging/archiving, login triggers, and fine grain access control (with another trashing of dynamic SQL). Their techniques of error handling and exception reporting comprise the final chapter. If you are not exhausted by now, you can continue with the appendices on language fundamentals, Transact SQL compilation, variables, functions (again!), global variables, set commands, the authors' favored views (voluminous), sending mail, and determining fragmentation.

Obviously, this book contains a lot of material. What mainly separates this book from others is the authors' presentation of their specialized SQL and UNIX shell code. The chapters on statistical measures, error handling, and exception reporting as well as the code on determining index fragmentation are also not easily found elsewhere. Conversely, some of the chapters (on Query Tuning and Datatypes) and appendices (Functions, Global Variables, and Set Commands) basically appear to be cut-and-pasted from the Sybase documentation. They also appear to have some redundancy.

Other detriments appear to be an above-average number of technical and grammatical errors. For example, the clause on page 44 should be "group by op_services_run_id", not "group by count (op_services_run_id)". "Shared level locks do prevent others from reading ..." on page 251 is one of several obvious errors. The authors indicate that a second edition will be more carefully proofread.

Some of the best practices appear dubious to my subjective eyes. The group by clause is split onto two lines as is every column name and value in an insert statement (e.g., page 338). The authors favor views and disfavor dynamic SQL. The latter preference basically leads them into code parameterization at the shell level. The lengthy Korn shell in Appendix I demonstrates how to determine fragmentation from the UNIX level. The reviewer has not used this script but it appears as if it could be done just as well with dynamic SQL and "sp_" stored procedures.

If you want to have a single "generic reference book" instead of the Sybase manuals (Transact-SQL Guide, Reference Manuals, and Performance & Tuning Guides) and can recognize some obvious mistakes, then this text may fit your needs.

Editorial Review:

Sybase Transact SQL - Software Technology

Sybase Architecture and Administration

John Kirkwood

List Price: $82.00 By: Prentice Hall PTR Amazon Marketplace: 26 new & used starting at $0.47

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> SQL -> Sybase
Subjects -> Computers & Internet -> Databases -> General

Customer Reviews:
Total reviews: 1 Average rating: 1.0 of 5

sybase Architecture and Administration 1 out of 5 stars.
6 of 7 people found this review helpful.

This book seems to be aimed at 'beginer' level users. Even for beginers, as it is based on version 10, it is pretty outdated now.... I would not go out and buy it.

I have read his other books as well...like the "Rep server admin", but that is a much better book in comparison.

The Official Guide: Sybase ASE 12.5 Performance and Tuning (Jeffrey Garbus' Official Sybase Ase 12.5 Library)

Jeff Garbus

Amazon Price: $37.77 List Price: $59.95 Usually ships in 24 hours By: Wordware Publishing, Inc. Amazon Marketplace: 24 new & used starting at $29.97

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Home Computing -> Internet -> General AAS
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> SQL -> Sybase

Customer Reviews:
Total reviews: 4 Average rating: 3.0 of 5

When is a 2K page > 2048 bytes? 3 out of 5 stars.
8 of 17 people found this review helpful.

Come on guys.... "Each chapter has passed through the hands of at least five experienced database administrators." [in Preface]
and I only have to get to page 12 to find none of you can explain the true page sizes for 2K APL & DOL pages......

Could the remaining chapters pass through your hands again after the editors had their chance? Please don't be like the so called Oracle book writers - you are better than that. Sure it is rather picky, but can I trust the rest of the information?

Editorial Review:

Once your database system is up and running, you need to keep it functioning smoothly. Designed for the DBA working to maximize the performance of a Sybase server, Sybase ASE 12.5 Performance and Tuning provides a guide to this important process. From benchmarking your system and optimizing stored procedures to indexing and using sp_sysmon to monitor your system, the authors thoroughly explain how to tune your server for maximum performance.

Topics include defining performance, understanding the I/O system, using the query optimizer, managing memory, and processing queries. Additionally, the authors discuss application design, deadlocks and locking schemes, performance metrics, and auditing features, along with providing tips for solving problems that can bog down a system.

This book is a must for those who are responsible for maximizing server performance.

The companion CD-ROM contains ASE 12.5 NT Developer’s Edition.

Inside the Minds: The Software Business - CEOs from Sybase, Inc., Business Objects, Quark & More on Designing, Developing & Managing a Software Team/Company

Aspatore Books

Amazon Price: $27.95 List Price: $27.95 Usually ships in 24 hours By: Aspatore Books Amazon Marketplace: 20 new & used starting at $18.99

Buy at Amazon.com

Browse similar items by category:
Subjects -> Business & Investing -> Economics -> General AAS
Subjects -> Business & Investing -> Skills -> Communications
Subjects -> Business & Investing -> General

Editorial Review:

Inside the Minds: The Software Business is an authoritative, insider's perspective on the ins and outs of the software industry and the future of the business, on a global scale. Featuring CEOs, Presidents, and Chairman all representing some of the top software companies across the world, this book provides a broad, yet comprehensive overview of the current shape and future state of this dynamic industry. As they raise critical points around the essentiality of meeting and exceeding customer needs and constantly striving for innovation, these authorities offer practical and adaptable strategies for managing a successful software company – large and small alike - and keeping up to date with the latest technological advances. From the processes involved in developing new products and growing one's business, to the effects of consolidation and an ever-changing marketplace, these leaders articulate the finer points around the industry now, and what will hold true into the future. The different niches represented and the breadth of perspectives presented enable readers to get inside some of the great strategic minds of today, as experts explore in detail what it takes to secure long-term success in this ever-evolving industry.

The Sybase SQL Server Survival Guide

Jim Panttaja, Mary Panttaja, Judy Bowman

List Price: $36.95 By: Wiley Amazon Marketplace: 13 new & used starting at $2.81

Buy at Amazon.com

Browse similar items by category:
Subjects -> Computers & Internet -> Databases -> Database Management Systems
Subjects -> Computers & Internet -> Databases -> SQL -> Sybase
Subjects -> Computers & Internet -> Databases -> SQL -> General

Customer Reviews:
Total reviews: 3 Average rating: 2.5 of 5

Editorial Review:

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.