Using Generic Connectivity To Access Microsoft SQL Server

Saturday, March 27th, 2004 by Mark Rittman

"I am trying to link 2 databases through Business Objects to enable Bus
Obs users to run their own reports (querying data from both databases
’simultaneously’) and have reached a stumbling block because (as I’m sure
you’re aware) database links between Oracle and another database (SQL Server
in this instance) is [...]

Dennis Shasha and Philippe Bonnet On Data Warehouse Tuning

Friday, March 26th, 2004 by Mark Rittman

DBAZine are currently running
an extract from Dennis Shasha and Philippe Bonnet’s book,

"Database Tuning: Principles, Experiments, and Troubleshooting Techniques"
on data warehouse tuning and optimisation. The extract looks at how data
warehouses differ from transactional databases, and how they are tuned for
optimal performance.

Cleanly Restarting OID After A 9iAS 9.0.2 Crash

Friday, March 26th, 2004 by Mark Rittman

A problem that often seems to happen when Oracle 9iAS 9.0.2 crashes is that you can’t seem to restart OID using
OIDCTL.
For example, a situation might arise when a server is bounced without 9iAS
being shut down cleanly. When you reboot the PC, and use DCMCTL to check the
status of the OC4J instances prior to starting them, [...]

What Are The Benefits When Upgrading From Oracle 8i To 9i?

Thursday, March 25th, 2004 by Mark Rittman

One question I’m often asked is "Apart from the inclusion of Oracle OLAP
and Oracle Data Mining, what are the benefits of upgrading an Oracle 8i database
to Oracle 9i?".
Well, I recently came across an article
on this subject by Don Burleson, which is worth taking a look at to get a
high level understanding of the benefits [...]

Stephen Few On BI Dashboards

Thursday, March 25th, 2004 by Mark Rittman

“Once again, marketing alchemists have cooked up a bowl of confusion with only a few simple ingredients. Everyone in the business intelligence (BI) space is wild about dashboards, but few proponents are talking about the same thing.” writes Stephen Few for IntelligentEnterprise.com.

Website Design & Build: tymedia.co.uk