Thursday, July 07, 2005


Sybase Survival Pack

There are a lot of great resources on Sybase, and you can see some of them among my links. But there are some utilities/documents that are so valuable that I burn them on a CD and carry a copy with me.


I have nothing against isql. But SQSH (SQL-Shell, developed by Scott Gray) allows you to edit previous statements (even far back in your history), use variables, among many other things. It's hard to use ISQL when I could be using SQSH.

2. Sybooks

Obviously I need the ultimate reference. Sybooks is the quickest and easiest way to look up error messages and commands. I always install my own copy so I don't have to rely on Internet access.

3. SybPerl

For advanced database work, it is handy to use Perl to write scripts. Because it is quick and easy to write, and can be used on every O/S. SybPerl is a set of libraries, developed by Michael Peppler, of the most common tasks.

4. Sybase Product Manuals

These are more than references (which you use Sybooks for anyway). You want the following (at least):
- The Quick Reference Guide
- The System Tables Diagram
- The Glossary (trust me!)
- The Performance and Tuning Guide
- The Reference Manuals (all 4, including building blocks, commands, procedures and tables)
- System Administration Guide
- Transact-SQL User's Guide
- Troubleshooting and Error Messages Guide
- Utility Guide

5. Various Utility Procs

Everyone has their own collection of handy utilities, procedures and scripts. If you don't, you can start building your library based on those of others. I heartily recommend starting with Ed Barlow and Todd Boss and take it from there. You'll keep most of your library on a memory stick because you'll be constantly tweaking them, but your core procedures belong on the disk.

I'm interested in hearing what you felt I may have left out. Please leave comments!

Comments: Post a Comment

<< Home

This page is powered by Blogger. Isn't yours?