|Last updated: 18 March 2013
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 (March 2013):
Fixed an integer-overflow bug in sp_mda_diskIO (thanks to Rick Skoroszewski for highlighting the bug).
Sybase books by Rob Verschoor
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)
Everything you wanted to know about
(a new feature in ASE 12.5)
a new feature in ASE 220.127.116.11 which can be used to implement small replication systems.
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-18.104.22.168, 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.
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
In 2001, Rob received the International Sybase User Group (ISUG) Outstanding Achievement Award -- details & picture are here.
Contact Rob Verschoor at firstname.lastname@example.org.
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:
Many thanks in advance for your support!
- Link to www.sypron.nl from your web site, and recommend it to others.