(Cameron O’Rourke) Do your users complain about a slow-running application that you have tried to tune but just can’t make run fast enough? Perhaps you need to take a hard look at the amount of processing your application does while the user is waiting. Could some of it be done in the background?

(Lois Levin) There are several ways to create a DBMS table from a SAS dataset. This paper will discuss the SAS methods that may be used to perform loads or updates, a comparison of times elapsed, and the INSERTBUFF option and the BULKLOAD option that can be used to perform multiple row inserts and

(Marcel Gagné) One of the sad facts about our relentless journey forward in the world of computers and software is that we sometimes find ourselves abandoning old data. We move from one word processing office package to another, only to discover that our old documents can no longer be opened. Th

RowSets, represented by the javax.sql.RowSet interface, is a JavaBean compliant component that encapsulates database access including the result, or in short an object which encapsulates a set of rows. Outside of encapsulation, a RowSet object can also be used for the following: –As a JavaBean c

(Arup Nanda) In the previous two installments of this series, I introduced you to the concept of Fine-Grained Auditing (FGA) used to track select statements in Oracle9i Database and up. I also explained how to use the feature in complex environments such as within a web application via application c

(Jim Czuprynski) The previous article in this series presented some actual examples of how to use the supplied DRM packages to create new resource plans, resource consumer groups and resource directives that bind them together. The concluding article in this series will discuss the creation of more

(Mike Lehmann) The first article of this series looked at the APIs necessary to wrap a Java class so that it could send and receive SOAP messages, by taking a Java class, EmpImpl.java, containing a JDBC database query of an employee table, and publishing and consuming it, using JAX-RPC. Now we focus

(Steve Callan) In this second article about SQL functions, we will look at 11 SQL-related functions commonly used in statistics: count, sum, average, standard deviation, variance and covariance (standard deviation and variance have three each; covariance has two).

(Carol Francum) The following is a sample trigger for using DDE to access an MS Excel spreadsheet. (R)

(Jim Czuprynski) The previous article in this series presented some actual examples of how to use the supplied DRM packages to create new resource plans, resource consumer groups and resource directives that bind them together. The concluding article in this series will discuss the creation of more