(John Spirko) Uncover ways to properly tune your Oracle E-Business environment and learn how to detect, diagnose and resolve top areas of contention throughout the application. This Webcast delivers: • A primer on where Oracle E-Business transaction breakdowns are likely to occur (from the concur
Author: SSWUG Research
EXPLAIN Plan Workaround
(Jaromir Nemec) The general rule for performing an explain plan is that you can perform the explain plan only if you have sufficient privileges to execute the statement. It means with only read rights you cannot explain, for example, an INSERT statement or any other DML statement.
Monitoring DB2
(Philip Gunning) Regardless of how well a RDBMS performs, the monitoring of SQL statements and resources is required to ensure continued good performance and to identify problem areas. Using the information gathered, adjustments can be made to instance and database configuration parameters, physica
Correlating Application and Database Processes in DB2 V8: Basis For Enhanced Accounting and Workload Management
(Namik Hrle and Johannes Schuetzner) A precise correlation of work done in DB2 on behalf of the application process is the basis for efficient monitoring, accounting, charge-back, capacity planning and workload management. For example, systems administrators should not, in general, terminate a
Using the XML Features of the Excel 2003 Object Model
(Frank Rice) Microsoft Office Excel 2003 adds a number of significant features for working with XML data. This article explores the XML-related objects, methods, and properties for Excel 2003 and provides code samples illustrating their use. After completing this article, you will have a better
Exploring the Distributed Web-Based Application Model and Advanced Features of VoiceXML
(Jeff Kusnitz & Dr. Bruce Lucas) This article is the second in a three-part series that provides an introduction to VoiceXML, as well as SRGS, SSML, and SISR for building conversational web applications. The first installment, Building VoiceXML Dialogs, discussed building VoiceXML dialogs through bo
ADO.NET data adapters using DB2 UDB V8.2 procedures
Configuring ADO.NET data adapters to call DB2 UDB stored procedures was a complex task prior to the introduction of the DB2 Stinger technology! This tutorial walks you through the steps required to build an application that uses SQL stored procedures to select, insert, update, and delete rows from d
Information about the SQL Server edition of the MPS Reporting tool
This article describes the Microsoft SQL Server edition of the Microsoft Product Support (MPS) Reporting tool (MPSRPT_SQL.exe). The article also describes how to download, install, and use the Microsoft SQL Server edition of the MPS Reporting tool.
Track Table Fragmentation Script
(Ralph Clark) Here’s a diagnostic table and stored procedure to track the fragmentation of large tables within databases. The user passes the database name and the table name as parameters to the SP. The SP can be set up to run as a scheduled job every few hours to produce a historical trend of frag
Building Plugins with C# Part 2: Making Additions with XML
(Nathan Good) This article focuses on two tasks. First, I’ll add a new plug-in, which uses an XML file to find valid users. Second, I’ll add a new configuration section handler to the simple UI testing program, to be used for loading the plug-ins when the application starts up.