Last updated: 07 August 2014
Site Map
 
Welcome to www.sypron.nl, a web site dedicated to the Sybase products ASE, Replication Server and IQ.
Most content on this web site has been created by Rob Verschoor, a Sybase Certified DBA for Sybase ASE, Sybase IQ and Sybase Replication Server. Some material has kindly been contributed by other authors as indicated.

The information on this web site is copyrighted material, available free of charge. Please be aware of the applicable copyright issues, the legal disclaimer, and some restrictions.

Contents: (bold = most popular)



What's new at www.sypron.nl (August 2014):
  • Yes, it's been quiet here for a while. That's because I've been rather busy in my day job at SAP/Sybase with this project...
  • The links to the free downloads of ASE and IQ have been updated to point to the new locations at sap.com.


Sybase books by Rob Verschoor
The Complete Sybase ASE Quick Reference Guide; 6th 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" - 6th edition -- an indispensable resource for any ASE DBA or developer, covering all commands, functions and system stored procs in ASE. The 6th edition is updated for version 15.7 ESD#3 (SAP Business Suite runs on ASE 15.7)
Available now!
 
"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.
Available now!
  "The Complete Sybase Replication Server Quick Reference Guide" - 3rd edition, updated for RS 15.7.1 -- an essential companion for every RepServer DBA.
Available now!
    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.
Available now!
   


A quick introduction to Sybase ASE

If you're new to Sybase ASE, here is some info about ASE to get you started:

Tips & Tricks & Documentation
  • Granting SA-commands to non-SA users: it may not be in the books, but it is possible! This shows how to allow ordinary users to execute commands like kill, sp_sysmon and sp_showplan without giving them sa_role ... (includes downloadable code)


Background Documentation
  • Everything you wanted to know about login triggers (a new feature in ASE 12.5)
  • ASE Replicator: a new feature in ASE 12.5.0.1 which can be used to implement small replication systems.


Sybase IQ


Replication Server


ASE Tools
  • sybinit4ever - an ASCII-only Unix tool for ASE 12.5/12.0/11.9/11.5 server creation; runs on all Unix platforms, including Linux.
  • A page with details about all dbccdb faults; handy for DBAs running ASE pre-12.5.0.3, where sp_dbcc_help_fault is not yet available. .
  • sp_exec_table, a handy stored procedure that lets you execute SQL based on the contents of a column in a table.
  • sp_license, a stored procedure showing exactly which licensable options you're running.
  • sp_recreate, a stored procedure to drop and recreate triggers in a single command, without re-entering the SQL source code.
  • SQL-to-XML tool for ASE - a simple tool to present data in an ASE table or view as XML; includes a downloadable stored procedure.


Miscellaneous Topics
  • Query Filter - a Unix tool to find "Queries from Hell" before they hang up your server (for ASE 11.0.3; it hasn't been updated for later versions; it may still be inspiring, though...)


About this site

This web site is maintained by Rob Verschoor, a free-lance Sybase ASE consultant (check out my CV/Resume and my certifications) who also wrote most of the documentation and software on this site. Sypron B.V. (short for "Solving Your Problems Now") is Rob's company -- hence the name www.sypron.nl; check out some customers.

In 2001, Rob received the International Sybase User Group (ISUG) Outstanding Achievement Award -- details & picture are here.

Contact Rob Verschoor at rob@sypron.nl. If you're a recruiter, please read this first.



Support this site!

All information on this web site is freely available to the Sybase community. It is still possible to keep this web site free of ad banners and popups (except a few about this site itself), although the ever-increasing volume of traffic (or rather, the associated costs) may require that to change at some point.
If you find this web site useful, and you'd like it to continue and remain ad-free, you can support this web site in two ways:
  • Link to www.sypron.nl from your web site, and recommend it to others.
Many thanks in advance for your support!


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