Sybase, Inc.
Atlanta, Chicago, Concord, Bethesda, Dallas, Irvine, New York, Washington etc., U.S.
http://www.sybase.com/

Powering Up to ASE Interim Releases

Course will include how to download and install the current interim release version 0.1 for Adaptive Server Enterprise (ASE) 12.5. We will cover the new features associated with 0.1, including disk resize, grantable dbcc’s, the new ASE migration tool, performance enhancements to JAVA and XML, and introduce the new ASE lightweight replication feature. We will also introduce available featur......
 

This lecture covers an understanding of the architecture and functionality of the new SybMigrate Utility. This will prepare you to use and fully employ the utility when migrating a database from an existing server to a server with a larger page size. Topics covered include the Architecture and features of the Utility as well as the requirements for using the utility. A walk through the migratio......
 

Take full advantage of the power and capabilities of Sybase Adaptive Server Enterprise database software. The lecture reviews and explains parameters that can be modified to improve server performance. Other parameters are discussed providing you with a complete understanding of possible modifications through configurable parameters. Become familiar with options to a server, identify parameters......
 

Indexes are chosen by the optimizer based on information that is perceived to be true. Gain an understanding of how perception can differ from reality and the impact that it can have on query performance. Study actual benchmark statistics for such actions as creating indexes, running update statistics and executing various queries under a number of real-life circumstances. Actual statistics on ......
 

Learn to write flexible, customized Open Server Library 11 applications. Open Server allows you to develop middle tier server applications. Develop a Help Desk application that demonstrates the fundamental Open Server techniques including starting and stopping the server; getting information from the client; handling errors; and returning results to the client. Objectives Upon co......
 

Learn the new features and functionality in Open Client-Library 11. Client-Library enables you to write flexible, customized applications that communicate with Sybase SQL Server, Adaptive Server Enterprise or Open Server. Learn how to initialize the client/server environment, connect to a server, send static and dynamic requests to the server, and process the results - including normal and comp......
 

This lecture-only course presents ways you can affect the optimizer’s behavior by fooling it, cheating it, and lying to it. We’ll discuss the well-known, understood, and documented force index and forceplan options, and examine how you can affect the optimizer’s behavior by adding, modifying and deleting statistics. Have your queries get to the data with less I/O. Understand docu......
 

Available server monitoring tools typically generate reports that are server wide: you can’t easily focus on a particular database, process, or table; and monitoring tools can be expensive. You can build performance enhancement tools for your Adaptive Server Enterprise 12.5.3 and later servers, that allow you to focus on the specifics of your particular environment - database, process, obj......
 

Understand this site critical report and how best to use its information. Gain an overall view of the different reports that are generated by SP_SYSMON. Get a line-by-line analysis of what the eighteen reports are; when and how often they should be run and what each report provides. Each of the SP_SYSMON reports will be covered. Recommendations will be provided on which reports should be focuse......
 

Acquire a working knowledge of Sybase IQ through a combination of lecture presentation and hands-on laboratory exercises. Learn Sybase IQ architecture, concepts, and terminology while setting up, loading, and maintaining a Sybase IQ database. Course material also covers must-know monitoring and troubleshooting methods, as well as important technical information to increase the performance and t......
 

Linux is quickly becoming a mainstream operating system for businesses requiring the stability and reliability of Unix with the additional benefits of lower IT infrastructure and computing costs. Sybase has responded to this trend by certifying and supporting its products on Linux, including Sybase Adaptive Server Enterprise. This training course will show you how to assess an existing Unix or ......
 

Introduce the new Sybase ASE 12.5.0.1 feature ASE Replicator. Walk through the process of setting up ASE Replicator, discuss it use and limitations. Additionally, basic troubleshooting hints are covered. Who Should Attend Sybase Database Administrator’s who are planning on implementing ASE Replicator Topics Review of Replication techniques Implementing ASE Repl......
 

This course will teach ASE administrators how to read and interpret information found with the ASE system tables . Who Should Attend Database Administrators Objectives Upon completion of this course, you will be able to: Identify all major ASE System Tables Understand the function and relationship between key ASE system tables Customize existing sp_¡¯s Write......
 

Learn how memory is allocated in Adaptive Server Enterprise (ASE) 12.5 and how to use Dynamic Reconfiguration (the ability to change ASE without rebooting) to provide optimal use of available resources. Understand troubleshooting memory resource and performance issues, which configuration parameters can be reset without needing to restart ASE, analyzing the impact of dynamically changing config......
 

Learn to write partial or complete abstract query plans, understand how to tune the optimizer and 3rd party applications. This ensures that the quickest access path method can be used every time. Writing your own plan will help the system to be fully optimized whenever retrieving data. You can force the optimizer to use the proper access route even if the statistics are updated and accurate. Ab......
 

Covers tempdb performance issues and introduces the new feature of Adaptive Server Enterprise (ASE) 12.5.0.3 that allows you to create multiple tempdbs on ASE 12.5.0.3 servers. Discusses the rational behind implementing this option, steps needed to create or delete a user created tempdb, how to create and manage tempdb groups, and new stored procedure sp_tempdb with related global variables. ......
 

Gain hands-on experience with the new features of Adaptive Server Enterprise (ASE) version 12.5.2. If you are upgrading from ASE versions 12.5.0.3 and/or 12.5.1, the latest features in version 12.5.2 make ASE even easier to deploy and maintain with enhanced operational scalability to support tougher workloads with fewer resources. ASE 12.5.2 ensures highest operational efficiency and throughput......
 

Get hands-on experience with the new features of Adaptive Server Enterprise (ASE) 12.5 and Interim Release 12.5.0.1. Learn what the new features are and how to use them, study new and modified commands and troubleshooting tips, and gain valuable insight on fine-tuning considerations and upgrade issues. Course Objectives : Upon completion of this course, you will be able to: Describe the in......
 

Dynamic Archive enables you to store terabytes of historical data online in less space than traditional offline archive storage. And it still costs less than conventional archive technology! In this 3-day class, you will learn how to develop and deploy powerful Dynamic Archiving solutions using Sybase products. Participate in Developer Edition hands-on labs to discover and develop a custom L......
 

Gain an introduction to and familiarity with the implementation of Mode-2 high availability, a high availability architecture [also called distributed workloads] in which disjoint applications can run on each of the nodes of a cluster. When one node fails, the surviving node takes over its workload avoiding the "e-nightmare" of lost data access during planned or unplanned server downt......
 

Pages:- 1 2 3 4 5 6 7 8 9 10 11 12

School Index A~Z: A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z

Tips: In most cases you will get a unique submit code along with your each posting on this website. Please provide it as well as the message title if you want any assistance for editing/removal.