By Prashant Dahalkar – There are situations where you may have to rethink queries to tackle complex problems. Here is one of them. We had a table in a SQL Server database called NAMELINK where no primary key was defined. The structure was as follows:
Author: SSWUG Research
Oracle to enhance channel strategy
By Ben Tudor – Oracle has increased its number of partners by more than 20 per cent and has almost doubled its sales through the channel. The firm has also boosted its channel programme by adding incentives for its partners.
Oracle 9i (9.0.1) installation on Red Hat Linux 7.2
Installation of Oracle 9i server on Redhat 7.2 is the same as on Redhat 7.1, except for some really strange behaviour I experienced when the Database configuration assistant (dbca) was invoked, both as part of installation and later when I tried to invoke it manually. This combination is not certifi
SOAP Builders @ Sun Microsystems, Inc.
SOAP Builders is a loosely organized forum of SOAP vendors working towards a testbed for interoperability testing between SOAP implementations. Interoperability is demonstrated by implementing a canonical set of tests that are collectively defined by the participants in the forum. Vendors prepare te
Web Services Solutions Directory
A comprehensive listing of XML Web services tool vendors and their product offerings.
Under deadline, power provider implements critical Web service
By Eric B. Parizo – Even when Entergy and its fellow energy providers began using comma-separated values (CSV) files a few years ago to submit their orders to one another, it was still nearly impossible to record, with complete accuracy, where electricity was coming from and going to and who should
Managing Processes for External Procedures in Oracle 8i/9i
In his first article, Ajay Gurshahani details the use of External Routines in Oracle 8i/9i, which are helpful in eliminating the need for using CGIs and also make it possible to create dynamic libraries and call them from PL/SQL.
Oracle Basics: Querying an Oracle Database
by Joe Lax – Oracle’s SQL*Plus is no SQL Server Query Analyzer, but with a little practice you’ll get the hang of it.
Security and Parameterization
By Russ Whitney – Analysis applications frequently contain confidential information. Here’s a scalable way to use MDX to determine which users can access sensitive information.
Microsoft SQL Server Audit
ClearData Consulting offers a one-day audit of your Microsoft SQL Servers to ensure secure, efficient systems. Our consultants will come on-site to monitor your system, perform system tests and interview your staff to look for possible ways to improve in the following areas: