UKSUG 2003 Events

January date Postponed - we will advise when we are able to reschedule "Logging and Database recovery" - Instructor Judy Grant 17.30 - 20.30 hrs at Sybase, 63 St Mary's Axe, London EC3A 8NR Tel: 020 7285 4000

Venue Map

Register Here

Events held in the last 12 months, for which many of the slides are available to download in the "members only" area

TechSelect* 2002 The UKSUG Technical Conference, AGM & Partner Expo 5 December, Hilton London Kensington Hotel

Tuesday 10 Sept 2002 "The Basics of Performance & Tuning" By: Peter Collard, Senior Consultant DBA This evening session is designed for DBA's & Developers who have NOT attended any of the Sybase Performance and Tuning courses. Topics covered will include: Indexes, the Optimiser, Locking, Cursors and Stored Procedures.

Monday 2 September 2002 "Perl for Sybase DBAs" By: Michael Peppler A refresher course on using perl to handle common DBA tasks. Starting with the basics of using Perl to interact with Sybase databases we willcover common errors and dangerous coding techniques, Tips for writing maintainable scripts and programs, and end with advanced Sybperl and DBI/DBD::Sybase features such as RPCs, text and image handling and asynchronous programing.

Tuessday 11 June 2002 "ASE: Tips, Tricks & Funny Features" By: Rob Verschoor - Author of 'The Complete Sybase ASE Quick Reference Guide' This mind-expanding, thought-provoking presentation takes an unconventional look at ASE. We'll discuss some unexpected applications of documented ASE features, as well as some undocumented ones. We'll also pay attention to some of the lesser-known new features in recent ASE releases. This presenation will be useful for any ASE DBA, developer or consultant. "How to Automate Your DB Administration" - By: Ed Barlow - Author of 'Ed Barlow's Sybase Toolkit'

Thursday 30 May 2002 - ISUG Innovation Tour 2002 "ASE 12.5 Technical Review and Preview of ASE 15.0" By: Stefan Karlsson, Staff Software Engineer, Sybase USA This ASE session presents the state and feature set of current ASE releases and discusses the short and long term roadmaps. "Leveraging Sybase Integration capabilities - with a focus on databases" By: Javier Cuerva, Technical Architect for Sybase EBD Engineering, Sybase USA ASE is the cornerstone for expoiting the integration capabilities of EAServer, PowerBuilder, PowerDesigner and Portal. This session will educate you on how to take advantage of these capabilities for Enterprise Application Integration, and also interact with ERP and CRM applications as well as business process automation.

21 March 2002 "Reconfiguring for System Administration Tasks" - Judie Grant, Sybase Education This Masterclass will look at how to tune command options and server configuration parameters associated with the bcp (in) utility and the create index command and to improve your performance of these standard administrative tasks. The evening will be split into 3 sections: Section 1: Review buffer management in data caches - creating named caches, buffer pools, wash point, and so on. This background helps to understand the effects of tuning command options and configuration parameters associated with bulk copying data in and creating indexes. Section 2: Specific techniques to improve create index performance including: Enable large I/O * Configure the number of sort buffers * create index . . . with sorted_data * Decrease the buffer wash area size * Use parallel worker processes Section 3: Ways to improve bcp (in) performance: * Fast bcp * bcp options: -n (native mode) -b (batch size) -A (packet size) * Configure the number of pre-allocated extents * Increase the buffer wash area size * Use parallel user connections

Tuesday 22nd January 2002 "Myths & Legends of ASE - The Optimizer" An evolutionary review of changes to the optimizer over the last few versions and in depth discussion of a number of 'myths and legends' about the optimizer. "How It Works ? Some Optimizer Internals - An In Depth Look At The Optimizer Statistics" A look into the internal workings of the optimizer and the statistics it uses to estimate the cost of any access. The optimizer's place in query processing. How it estimates selectivity, how it reads and uses the statistics to make its decisions, how it uses memory and in what order things happen while it does its work. There are several statistical values used by the optimizer. What do they mean, where do they come from and how do they affect the optimizer's cost estimates? There will be information on how to interpret the statistics in order to understand how your data and indexes are affecting the optimizer. We'll also discuss a number of optimizer related FAQs

Event To Be Booked
Name
Job title
Company
Email Address
Telephone

UKSUG Member Technical Days are free to attend for fully paid up members of the User Group. Click here if you are not currently a UKSUG member and would like to join or to renew your membership.

If you have any ideas for a presentation you would like to see at a future UKSUG event, submit here.