Jump To : Database Administration

Jump To : Database Development

Administration of Adaptive Server Enterprise

Review: Sybase Resources at the DBA-Sybase Web Site

This article reviews a website, www.dba-sybase.com, which provides resources for Sybase DBAs through the format of case studies from a working DBA.


Cross-Platform Migrations: the sybmigrate utility

Using the sybmigrate utility to migrate databases across platforms.

Review: Podcast on "The Art of Performance & Tuning: Tips and Tricks"

This article reviews a podcast from Sybase in their P&T series.


Installing the dbschema utility on Windows

This utility extracts the database and server schemas into one or more scripts. The article provides instructions for installing the utility on a Windows machine.

Review: Podcast on "The Art of Performance & Tuning: Monitoring Practices and Tools"

This article reviews a podcast from Sybase in their P&T series.


Which Scripting Language for Sybase Administration on Windows

This paper considers five scripting options available to automate the administration of Sybase database servers on Windows.

Review: Podcast on "The Art of Performance & Tuning: General Best Practices"

This article reviews the first ever podcast from Sybase covering Adaptive Server Enterprise.


Editions of Adaptive Server Enterprise

Alongside the standard Enterprise Edition of Adaptive Server Enterpise, there are three other editions including two that are free. This article describes the limitations imposed on these three editions, and where to get hold of the free versions.

Database Development

Performance Tuning for Database Developers: General Principles

This article provides an overview of general principles to follow when performance tuning database applications running on Sybase Adaptive Server Enterprise.

Performance Tuning for Database Developers: Transact-SQL

Transact-SQL offers more than one way to perform many tasks, and some techniques offer better performance than others. Here are some tricks of the trade for writing high performing T-SQL.