| 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:
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.
|
|
"The Complete Sybase Replication Server Quick Reference Guide" - 3rd edition