Thursday, July 07, 2005
Sybase Survival Pack
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.
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.
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!