Last updated: 14 July 2012
Sybase-related books
 
Here's a list of some books that might be useful when you're using Sybase ASE.

Sybase books by Rob Verschoor
First, here are some books written and published by myself, which have generally been well-received:
The Complete Sybase ASE Quick Reference Guide; 5th edition  
The Complete Sybase IQ Quick Reference Guide; 1st edition
  The Complete Sybase Replication Server Quick Reference Guide; 3rd edition
"The Complete Sybase ASE Quick Reference Guide" - 5th edition -- an indispensable resource for any ASE DBA or developer, covering all commands, functions and system stored procedures in ASE. The 5th edition is updated for versions 12.5.4, 15.0.3 and ASE Cluster Edition.  
"The Complete Sybase IQ Quick Reference Guide" - 1st edition -- a must-have for every IQ DBA or developer, covering all commands, options, startup switches and background info you may need in practice. Covers IQ 15.0 - 15.4.
  "The Complete Sybase Replication Server Quick Reference Guide" - 3rd edition -- an essential companion for every RepServer DBA. Updated for RS versions 15.1 - 15.7.1.
    Tips, Tricks & Recipes for Sybase ASE; 2nd edition    
    "Tips, Tricks & Recipes for Sybase ASE" - 2nd edition -- a unique book full of handy tips & tricks to make the most of ASE. The 2nd edition is fully reviewed and updated for ASE 15.0, with 80 pages of new material.    


Free stuff
All Sybase ASE manuals (as well as all other Sybase product documentation) can be downloaded from the Sybase website as PDF documents. The ASE documentation is located at http://sybooks.sybase.com/nav/summary.do?prod=9938&lang=en&prodName=Adaptive+Server+Enterprise. When printed, you have an exact copy of the printed manual, including the illustrations and index.
I especially recommend the following ASE manuals:
  • Transact-SQL User's Guide (a good overview of ASE's T-SQL language)
  • System Administration Guide (covers the DBA stuff)
  • Reference Manual (all commands, all system stored procedures, and more...)
  • Performance & Tuning Guide (everything about P&T)
To download these manuals, go to http://sybooks.sybase.com/nav/summary.do?prod=9938&lang=en&prodName=Adaptive+Server+Enterprise; in the "Core documentation set, choose your ASE version. You will then see a list of available manuals; to download a manual, click on the corresponding PDF icon.
(Note: Replication Server manuals can be downloaded from http://sybooks.sybase.com/nav/summary.do?prod=9614&lang=en&prodName=Replication+Server in the same way as above)



Other commercial publications
There are also some commercial publications - here's some stuff from my bookshelf (in no particular order):
  • The Official New Features Guide to Sybase ASE 15
    by Taylor et al
    ISBN 1-59822-004-7

    Published in 2006. The authors are DBAs at a large Sybase customer in the USA.

  • Sybase Transact SQL Programming
    Guidelines and Best Practices

    by Talebzadeh/Putnam
    ISBN 0-9759693-0-7

    Published in 2004.

  • The Official Guide: Sybase ASE 12.5 Performance and Tuning
    by Garbus/Miner/DuPlessis/Chang/Malchi
    Wordware Publishing
    ISBN 1-55622-908-9

    A recent (2003) book by Jeff Garbus c.s.; this book covers the essentials of the some P&T topics in ASE. Note that it covers up to 12.5 GA; the performance-related enhancements in 12.5.0.3 (such as the MDA tables and tempdb enhancements) are not included.

    More information about this book is here.

  • The Official Guide: Administrator's Guide to Sybase ASE 12.5
    by Garbus/Chang
    Wordware Publishing
    ISBN 1-55622-307-2

    This is one of the few books that are up-to-date with recent ASE releases; it covers the standard ASE DBA topics, and also some (but not all) of the new features in ASE 12.5.
    Also, the book contains an appendix with some certification test questions (though these questions are about ASE 12.0 and earlier versions; there are no questions about 12.5-specific features).
    More information about this book is here.

  • Sybase ASE 12.5 High Availability
    by Garbus/Tyrrell
    Wordware Publishing
    ISBN 1-55622-909-7

    This book covers the HA functionality in ASE 12.0 and later. It also contains some chapters about OpenSwitch and the Warm Standby feature of Sybase Replication Server.
    More information about this book is here.


  • Sybase Replication Server, an Administrator's Guide
    by Kirkwood/Arkle
    ISBN 0-9537155-0-7

    This book is a useful book for any DBA working with Sybase Replication Server, covering up to RepServer version 11.5. It does not cover replication to/from other databases than ASE. http://www.pagelink.demon.co.uk/.



  • Sybase SQL Server 11 Unleashed
    by Rankins/Garbus/Solomon/McEwan
    SAMS Publishing
    ISBN 0-67230909-2

    Sybase SQL Server 11 DBA Survival Guide
    by Garbus/Solomon/Tretter/Rankins
    SAMS publishing
    ISBN 0-67230888-6

    These are probably the two most-used Sybase books. I think the DBA book is especially useful, as it looks at many ASE issues from a DBA viewpoint. It also contains some sample questions for the ASE certification exams (for details about certification exams, go here ).


  • Sybase Performance Tuning
    by Roy/Sugiyama
    Prentice Hall
    ISBN 0-13442997-4

    This book basically covers the same sort of stuff as the ASE Performance & Tuning Guide, but is a bit easier to read: it contains more explanations and backgrounds and is less hard-core than the P&T Guide. Covers only up to ASE 11.0.x


  • SQL Puzzles & Answers
    by Joe Celko
    Morgan Kaufmann Publishers
    ISBN 1-55860453-7

    SQL for Smarties: Advanced SQL Programming
    by Joe Celko
    Morgan Kaufmann Publishers
    ISBN 1-55860323-9

    While not Sybase-specific, Joe Celko's books are great reading: in my experience, you'll always find some approach or trick you hadn't thought of before. Highly recommended.


  • Official Sybase Internals
    by John Kirkwood
    International Thompson Publishing/Sybase Press
    ISBN 1-85032334-8

    Most of the material in this book is also in Sybase's freely downloadable ASE Performance & Tuning Guide (see above). While covering less topics than the P&T Guide, Kirkwood's book takes a more practical approach. Note that it covers only up to ASE version 11.0, not counting the very brief appendix about ASE 11.5 features.


  • Transact-SQL Programming
    by Kline/Gould/Zanevsky
    O'Reilly & Associates
    ISBN 1-56592-401-0

    Covers T-SQL up to ASE 11.5, as well as MS-SQLServer 6.5/7.0. A useful book, though -- IMO -- experienced T-SQL programmers probably won't find a lot of new information here; therefore it's probably most useful for those looking for an introduction to T-SQL.
    Note that this book is mainly about T-SQL itself; it covers only the most common of the system stored procedures (those starting with "sp_", such as "sp_helpdb").

     
  • Optimizing Transact-SQL: Advanced Programming Techniques
    by Rozenshtein/Abramovich/Birger
    SQL Forum Press
    ISBN 0-96498120-3

    Covering point-characteristic functions (those expressions like "(1-abs(sign(x-10)))"), I used this book a lot in the past. However, since ASE supports the CASE expression in version 11.5 and later, this material has become somewhat obsolete. Nevertheless, it's interesting to see what complicated things you can do with a SELECT statement.

 
 This document is located at www.sypron.nl/sybbooks.html