Adaptive Server administration tasks

Administering Adaptive Server includes tasks such as:

In addition, System Administrators may have a hand in certain database design tasks, such as enforcing integrity standards. This function may overlap with the work of application designers.

Although a System Administrator concentrates on tasks that are independent of the applications running on Adaptive Server, he or she is likely to be the person with the best overview of all the applications. For this reason, a System Administrator can advise application designers about the data that already exists on Adaptive Server, make recommendations about standardizing data definitions across applications, and so on.

However, the distinction between what is specific to an application is sometimes a bit “fuzzy.” Owners of user databases will consult certain sections of this book. Similarly, System Administrators and Database Owners will use the Transact-SQL User’s Guide (especially the chapters on data definition, stored procedures, and triggers). Both System Administrators and application designers will use the Performance and Tuning Guide.