This page is a holding area for some of the information I have regarding Sybase Database Administration. Primarily this information will be useful to Operational DBAs: DBA tasked with installation, configuration, maintenance, and tuning of Sybase servers. You'll find almost every maintenance script you could need, a very useful proactive monitoring system (Swatch-based), a host of SQL-Backtrack integrated utilities, custom stored procedures, and the like.

• Job Postings for Sybase DBAs: new job 9/2/05
• 3rd Party Software packages
• Setting ODBC to MS Access, SQL Server, etc
• Ad-Hoc scripts w/ Code examples
• Additional stored procedures
• Auditing
• Data element naming standards
• Deadlock Diagnosis
• Divide by Zero
• My personal Sybase FAQ
• Identities and Sequential Keys
• Integrating Powerbuilder Apps to Sybase
• Integrating Web Objects Apps to Sybase
• Integrating WWW apps to Sybase
• Keys and Referential Integrity
• List of Post-server Creation things todo
• Oracle Cheatsheet
• Oracle FAQ (my personal FAQ/howto list)
• Sybase over Oracle
• RDBMS Vendor Marketshare data
• RAID Disks and Sybase
• Raw vs Flat files and Asynch I/O
• Security Issues in Sybase
• Spaces and Null behavior
• SQL Backtrack overview
• SQSH isql replacement
• Sybase Version differences
• Stored Procedure/Update Stats
• Configuring Tempdb for Performance?
• Troubleshooting Performance issues
• Update Statistics/sp_recompile and Stored Proc maintenance
• Upgrade Options; pros and cons
• WWW links

  ---

• Carl Kayser's Utility Procs

  ---

• Database Backups
• Nightly/Perpetual jobs
• Other DBA How-Tos/Tasks
• Swatch Monitoring
• sp_thresholdaction
• Transaction dumps
• Weekly Jobs: DR, Dbccs, Index Maintenance

visits since 11/6/01 (all my counters got reset)