(John Smiley) This is the first in a series of guides that provide all the steps for installing the major components of Oracle 10g software on Linux. All three of the certified English-language distributions of Linux are covered in detail (Asianux is not covered), and the articles assume that inexpe
Author: SSWUG Research
Part 2: Simplify performance management and tuning with DB2 Performance Expert
(Werner Schuetz) Part 1 of this article introduced the DB2 Performance Expert (DB2 PE), a tool that simplifies the tasks of monitoring and administering your DB2 UDB servers. Now, Part 2 shows you a number of practical scenarios, demonstrating how to use the tool to analyze factors which directl
Handling Simple XML Using T-SQL
(Eli Leiba) This article describes how to traverse a simple XML file that has only 2 attributes (name and value, like a dictionary). And get the results in a single column in SQL SERVER result set. (R)
How to call web services with REST instead of SOAP
(Jeff Web) With names like SOAP and REST, you’d expect a couple cute jokes here. Perish the thought; I promised code in my last post and code you shall have. The VB/VBA tools and samples from Microsoft demonstrate calling web services through SOAP interfaces. For example, the Office Web Services
BUG: Position() and Last() XPath Functions Are Ignored When You Use Them as XSLT Function Arguments
The position() and last() XPath functions are ignored when you use them directly as XSLT function (standard, script, and extension function) arguments in XPath query expressions that are used in XSLT style sheets.
The SQL of OLAP
(Michael Gonzales) When considering online analytic processing (OLAP), architects often focus on issues such as which dimensions to include, what facts are relevant, how often to refresh the data contents, and so on. Among these issues, the OLAP language is often overlooked. And of all the OLAP-cent
PeopleSoft ties knot with IBM
(Martin LaMonica) PeopleSoft will develop its future business applications to work with IBM’s infrastructure software and programming tools, as part of a broad technology and marketing agreement between the two companies.
IBM DB2 UDB and SteelEye LifeKeeper for Linux- A High Availability Database Solution
(Andy Beaton) This paper provides an introduction and sample configuration instructions for running IBM DB2 Universal Database (DB2 UDB) on a cluster of Linux servers, with high availability capabilities provided by SteelEye LifeKeeper for Linux. The purpose of high availability software is to p
Minding Memory
(Tom Davidson and Prakash Sundaresan) Starting with SQL Server 7.0, a central goal of the SQL Server development team has been to produce an easy-to-use system that requires little care for daily operations. To meet this goal, the team designed SQL Server to be a self-tuning system that dynam
Using the XML Features of the Access 2003 Object Model
(Frank Rice) Microsoft Office 2003 adds a number of significant features for working with XML data. This article explores the XML-related objects, methods, and properties for Microsoft Office Access 2003. Detailed information on these new members is provided as well as code samples illustrating thei