Sybase management, tutorials, scripts, coding, programming and tips for database administrators

Sybase

Managing Data Growth with Enterprise-class Databases 01/27

Compliance isn’t the only reason to retain large data sets; better historical business reference and real-time analysis, all require access to large volumes of data to gain better business insights. Read on to learn more.

Operational Scalability and Security with Sybase Adaptive Server Enterprise 12/19

Robert Schneider defines the elements that comprise operational scalability, and then provide concrete examples of how Sybase Adaptive Server Enterprise (ASE) augments operational scalability via minimizing downtime, sustaining heavy workloads, and supplying enterprise-grade security.

Thoughts on Improving DBA Productivity 11/18

Lockwood Lyon offers ideas for how database administrators can react less, think more and find lasting solutions.

Sybase ASE Application Development and Big Data 11/15

Sybase ASE can now work with unstructured data and very large data volumes.

Why You'll Want to Upgrade to Sybase ASE 15.7 10/21

Sybase ASE 15.7 has a bunch of new features you may want to consider, including improved performance, scalability and security.

Delivering High Performance with Zero Administration 02/11
Advances in self-management capabilities are making it possible to maximize performance and prescribe changes and ongoing maintenance tasks with fewer demands on IT staff.

Using Dynamic SQL with Sybase Replication Server 11/24
Manish Negandhi explains how dynamic SQL works with Sybase Replication Server and discusses various methods of setting up dynamic SQL with Sybase Replication Server, including a step-by-step example.

New Paradigms to Overcome the Data Bottleneck in Next-Generation Transactional Applications 09/09
The effectiveness of meeting the needs of the next-generation transactional applications will depend on the ability to support the memory-based, data virtualization layer and the level of integration of this layer with the backend systems. Read on to learn the challenges with traditional transactional systems.

Best Practices for a SYBASE ASE Cluster Edition Proof of Concept 06/11
You've taken a quick look, and decided that Sybase ASE Cluster Edition is right for you. Managing the POC requires a great deal of forethought and planning. Jeffrey Garbus shares some best practices to get you started.

Sybase ASE 15.5 -- The Need for Speed 05/26
The slogan "Bigger, Better, Faster" was always the driving force behind the database technology evolution. The latest release of Sybase ASE 15.5 is no exception.

Using Sybase ASE 15.5 In-memory Databases 05/07
This article investigates how the newly-available In-memory Database (IMDB) and Relaxed Durability Database (RDDB) in Sybase ASE 15.5 offer new techniques for supporting performance-intensive applications while not mandating any deviations from traditional Sybase development practices.

New Mission-Critical Features of Sybase ASE 15.5 04/06
Robert Schneider spotlights capabilities present in Sybase Adaptive Server Enterprise (ASE) 15.5, paying particular attention to the new enhancements that help support better performance (via lower latency and very high transactional throughput), augment efficiency, and increased availability.

Using the Sybase ASE Resource Governor 03/02
The Sybase ASE Resource Governor provides you with a mechanism to limit the resources a given process may request or acquire. If you have very heavy resource drains, it may be that adding this tiny bit of overhead can reduce whatever is currently stressing your system.

In-Memory Database option for Sybase Adaptive Server Enterprise 02/02
In-memory database (IMDB) is a technique used to place an entire database - data, logs, and all - in cache. This capability enables you to treat memory-resident data the same way you treat any other ASE data. Plus, it's quick, easy, and integrated. Read on to learn more.

Sybase ASE 15: Very Large Storage Systems 12/08
Sybase, with the release of Adaptive Server Enterprise 15, has effectively removed size limitations from databases and servers. This article discusses old structure, new structure, and practical limitations.