The Trilogy Completes: "The Complete Sybase IQ Quick Reference Guide"

    By: Mr. Adrian Bridgwater on Dec 12, 2011

    Hot off the press this month is a new book written by Rob Verschoor entitled "The Complete Sybase IQ Quick Reference Guide". Verschoor himself is a certified DBA for RepServer and ASE, a certified DBA for IQ and already author of the popular ASE books "Tips, Tricks & Recipes for Sybase ASE" and of "The Complete Sybase ASE Quick Reference Guide" and "The Complete Sybase Replication Server Quick Reference Guide".

    Those who are familiar with Rob's other “quickref” guides for ASE and RepServer will know what to expect: a complete, detailed, well-organised quick reference guide, aimed at maximum practical usefulness.

    After some great feedback resulting from features in ISUG Technical Journal over the last eighteen months, Rob is also pleased to see that his quickref guides for ASE (first edition in 2001) and Replication Server (first ed. in 2004) have become pretty much what we have to call “indispensable books” that most DBAs have a copy of. 

    The trilogy is complete

    With this latest quickref guide for IQ, the trilogy is complete in that all of the top-3 Sybase products are now covered. The book’s cover is described as “violently pink” – and this is because the author and publisher wanted a color that combined well with the purple ASE and green RepServer quickref guides already published.  

    ... and, so says Rob himself, “I don't like boring colours ;-) …!”

    Here’s some soundbites from the book's own cover:

    “Sybase IQ was the first commercially successful column-oriented analytics database. Over the years, IQ has matured into a powerful and versatile analytics platform with a wide range of options, statements and features, which, however, are not always easy to remember. This Quick Reference Guide will help you out, containing all IQ commands, options and stored procedures you might need in practice. Whether you are a DBA or a developer, this book provides the answers you're looking for.”

    Book introduction text:

    "When will you write a quick reference for IQ ?" This is perhaps the question I have been asked most frequently since publishing my quick reference guides for Sybase ASE and Sybase Replication Server. Finally, here it is."

    “When IQ was originally created in the early 1990's (named Expressway before being acquired by Sybase), storing data in a column-oriented manner was a very novel and innovative concept, and I'm sure it must have looked distinctly odd in some people's eyes. Keep in mind that in those days "Analytics" was not part of the ICT vocabulary, and "Business Intelligence" was something you said about a person rather than software.”

    “Sybase recognized the potential of this concept before the rest of the database world, and Sybase IQ became the first commercially successful column-oriented analytics database. Over the years, IQ has matured into a powerful and versatile analytics platform, providing real-life features that set IQ apart from today's various column database start-ups.”

    “For example, IQ can perform high-volume real-time data loading while minimally impacting ongoing concurrent query activity. With that maturity comes a wide range of options, statements and features. Add the fact that Sybase IQ also uses some -but not all- aspects of SQL Anywhere's functionality, and it will be no surprise that many IQ users have some trouble remembering all details. This IQ Quick Reference Guide aims to help you out by providing all IQ commands, options, stored procedures and background information you might need in practice, carefully indexed for quick and efficient lookup.”

    In Rob’s own words we will end this blog with an upbeat comment -- whether you are a DBA or a developer working with Sybase IQ, this book will be your companion.

    For details click here:

    ISBN 978-90-806117-0-2 Price: € 20.95 (excl. shipping)

    Released: December 12, 2011, 3:39 am | Updated: March 22, 2014, 6:44 pm
    Keywords: IQ News | ASE | Rob Verschoor | Sybase IQ




    Copyright © 2014 ISUG-TECH. All Rights Reserved
    All material, files, logos and trademarks within this site are copyright their respective organizations

    Terms of Service - Privacy Policy - Contact the Help Desk