|Last updated: 03 September 2006
Tips, Tricks & Recipes for Sybase ASE|
2nd edition (updated for ASE 15.0)
Scope & Contents
"Tips, Tricks & Recipes for Sybase ASE" describes many perhaps-not-so-obvious ways of using ASE features to increase the usefulness and productivity of ASE. Many of these tips & tricks have not been published or presented before.
This book provides a wealth of practically useful information for all DBAs and developers working with Sybase ASE. It includes suggestions and workarounds to help reduce downtime and improve productivity and performance. For various topics, an explanation of related ASE internals is included.
The table of contents can be found here (2ndedition; PDF format; ~225 Kb)
Here are just a few examples of the sort of thing described in "Tips, Tricks & Recipes for Sybase ASE" :
- How to determine the clock time corresponding to a particular value in a timestamp column;
- How to avoid that a shutdown with nowait leads to identity gaps, even in pre-12.0 (and without using the two-table design technique I've described before).
- How to dynamically toggle the ignore_dup_key option for an index;
- How an ANSI outer join can implement some functionality much more efficiently than a classic T-SQL outer join;
- How to test for the existence of a specific global variable or a built-in function from T-SQL;
About the author
- How to perform a shutdown with nowait without knowing the sa password;
This book is written by Rob Verschoor, Certified DBA for ASE 12.5/12.0, and author of the successful ASE book "The Complete Sybase ASE Quick Reference Guide"
(please note that "Tips, Tricks & Recipes for Sybase ASE" is not a quick reference guide, but a full-size book).
Those who are familiar with Rob's work will know what to expect: thought-provoking, out-of-the-box thinking and innovative applications of ASE features, but always geared towards practical usefulness.
What makes this book different?
Unlike many other books about ASE, "Tips, Tricks & Recipes for Sybase ASE" does not just discuss existing ASE functionality. Instead, this book goes one step further and explores new dimensions of ASE features.
From seasoned DBAs to experienced developers, this book will be a source of inspiration for everyone working with Sybase ASE.
Where to buy ?
"Tips, Tricks & Recipes for Sybase ASE" can be ordered through this web site only (with secure credit card payment). Orders from all countries are accepted. Information on price, discounts, shipping, etc. is here.
Within The Netherlands only, direct ordering is also possible.
Currently, there are no plans to distribute the book through other channels, so it will not be possible to buy it at your local bookstore. Also, you won't be able to get it via Amazon (they accept only USA-based distributors).
Reviews & comments
A review of this book (from the ISUG Technical Journal) is here (PDF). Another review (from the PowerBuilder Developer's Journal) is here.
Below are some comments from readers about "Tips, Tricks & Recipes for Sybase ASE".
To see how Sybase CEO John Chen likes this book, go here.
"If you're watching over Sybase ASE servers, this book is a keeper! It
provides practical insight and expertise to DBAs of any skill level while
challenging your understanding of several topics. I know you'll learn
something new and useful ... I did!"
San Francisco Bay Area, CA (USA)
"I have been reading your book 'Tips, Tricks & Recipes...' for three days without pause (only for sleeping) and found it to be very interesting and useful.
Although official Sybase manuals are excellent, your book is one 'wonderful patch installed on top of ASE official manuals' covering many holes and misunderstandings in them. It is worth of every cent spent to it."
"I really like your "tips & tricks" book. I've been using Sybase for a long time now (since 4.2) but I've learned a lot from your book. Many thanks."
Washington, DC (USA)
"I can safely say this [book] is one of the best investments I've ever made in terms of technical book purchases. Congratulations, because this is going to be an essential tool and a classic in the sybworld."
Chicago, IL (USA)
"This particular work by Rob complements the recent "The Complete Sybase ASE Quick Reference Guide"
quite nicely. It is a concise masterpiece that brings together all 'syb-functionality' under
one-roof. The amount of analysis per command is staggering as the work not only shows you
'best practice' methods but also the justification behind it. There are so many ways to manage
your ASE server and it is outlined VERY WELL in this work. In my opinion this will become
the ASE-HOLY GRAIL."
Investec Bank, Treasury
Johannesburg (South Africa)
"This book is great for suggestions, tips and tricks and background info and not only
*usable* but also *readable* like a (good) novel.
It is an invaluable aid in knowing what you are doing and what the
implications are for your environment.
Keep this book next to Rob's 'ASE Quick Reference Guide'. The ASE Quick
Reference Guide is really great for being very concise, but due to it's
nature, it does not come with too much background info."
Naaldwijk (The Netherlands)
"This is one of those books that won't gather dust on your bookshelf.
After 'The Complete Sybase ASE Quick Reference Guide', this is one of
most practical books I ever used. Thanks Rob, for a book like that."
Rainer Schlichter (freelance DBA)
"Your book is tremendously useful, and not just for Sybase.
I also have some [Microsoft] SQL Servers, and I've already used some of your tips and tricks there too.
I warmly recommend this book to ASE DBAs and SQL Server DBAs alike."
New York City, NY (USA)
(Please note that the above statements
represent the opinions of these individual DBAs, and not of their employers)