- Unsupported platforms:Open Server and SDK do not support HP-UX PA-RISC and Mac OS.

- In Adaptive Server 15.7, the maximum offset of a variable-length column for a data-only-locked (DOL) row has been expanded to 32767 bytes, which allows an Adaptive Server configured with a logical-page size greater than 8K to support wide, variable-length, DOL rows.- Bulk-Library and bcp handling of nonmaterialized columnsBulk-Library is enhanced to handle nonmaterialized columns in Adaptive Server 15.7. With this enhancement, you can only use Bulk-Library and bcp version 15.7 and later to bulk-copy-in data into Adaptive Server tables that are altered and contain nonmaterialized columns. Adaptive Server will raise an error when earlier versions of bcp are used to bulk-copy-in data into nonmaterialized columns.

Strong Password Encryption—protects the database from external intrusion and hacking

Single Sign-on & Login Profiles—makes it easier to manage large numbers of users and simplifies end-user access to the system

Ease of Application Development

Efficient Management of Large Objects—inline management of large objects as well as enhanced application development features such as large objects as parameters to stored procedures.

Enhanced Application Language Capabilities—many improved TransactSQL&™ language features to increase productivity of application developers as well as support for a variety of popular languages such as Python, PHP and Perl.

An Enterprise-Class DB for ISV applications —enhanced business-critical performance for ISV applications out of the box, enabling ISVs to easily write and port their applications to ASE 15.7.

1. Dealing with large data sets. This includes better management of large objects, as well as enhancements to operational, storage, and data management tasks. With the costs of today’s high-end SANs, data compression may pay for the whole project.

2. Performance and scalability. New features here include better management of dynamic queries (I know that one is going to make friends) as well as a variety of ways to compress data, and better kernel integration for parallel processing performance.

3. More ease of maintenance. ASE 15.7 supports fully recoverable DDL commands such as select into, alter table, and reorg rebuild. In addition, you can now shrink log space, diagnostic support has taken a major step forward, and alter table statements can now be performed without copying data (how about that for speed of internal application upgrades?).

4. Application and developer productivity, including a variety of transact-sql enhancements.