SQL Server Dataserver

Duration

• 1 Day

Prerequisites

• Progress 4GL development experience

Course Description

With SQL Server becoming more and more commonplace, it is sometimes necessary to be able to demonstrate that a Progress application can run on this platform. This one-day seminar is ideal for anyone developing or considering the development of Progress applications against a MS SQL Server database using the MS SQL Server data server. The aim of the day is to show how the data server integrates with Progress and which Progress language statements are best used with an data-server database. Key focus is placed on performance and tuning with a MS SQL Server data server. The seminar also highlights the differences between test and live environments on this platform.

Whether an experienced developer or a relative newcomer to Progress and data servers, this single day seminar should provide a valuable insight into how Progress works with other databases.

Topics

Key topics in this seminar include

• Overview of Data server technology
• Schema Holders
• Connection parameters
• Software requirements
• Data server configuration
• Terminology
• Programming considerations
  • Data Types
  • Index usage
  • Triggers and order of firing
  • Record creation and availability
  • Locking
  • Cursors
  • R-code size differences
  • Query Tuning
• Testing and testing tools

Objectives

Formal product training will enable developers to make the most of their investment in Progress. By learning from the experts, customers will be able to make best use of their investment and gain a return on that investment sooner.

This seminar will teach good principles which if applied will result in better database systems, which:

• Use the most efficient code for data server performance
• Are distributed sensibly
• Are tuned to run with a MS SQL Server database

Applicable Progress Version:

• All

Delivery Mechanism:

• Instructor Led