(Jim Czuprynski) I won’t harp on the obvious: The ability to access recent, consistent backup files and archived redo logs is the key to recovering from and surviving a disaster. Of course, I am assuming your production database is running in ARCHIVELOG mode for maximum flexibility for recovery. Mor
Other News
IBM Wants Developers to Feel the Stinger
(Clint Boulton) IBM will unravel even more of the yarn of its forthcoming DB2 Universal Database at EclipseCon to curry support from developers. While IBM has previously announced that Stinger will help DB2 interoperate with .NET development tools, IBM will pad DB2’s Java support at the show in
SQL 2003 Standard Support in Oracle Database 10g
SQL standards have been the most popular and enduring standards in computing. Although information processing has become increasingly more sophisticated and more complex over the past decades, SQL has continually evolved to meet the growing demands. As the latest version of SQL standards, SQL 200
Snapshot Replication for the Beginner
(Andy Warren) If you haven’t already, you might want to look at the two previous articles I’ve written recently on replication (Snapshot Replication and Getting Ready to Replicate) that set the stage for this one. This week I’m going to return to snapshot replication, discussing how to do a basic im
FIX: SQLOLEDB Does Not Work with DBACCESSOR_OPTIMIZED Flag and SSPROP_ENABLEFASTLOAD
Using the Microsoft OLEDB Provider for SQL Server (SQLOLEDB) that comes with Microsoft Data Access Components (MDAC) version 2.6 or 2.6 SP1, when you set the value of the SSPROP_ENABLEFASTLOAD property to true in the SQLSERVERDATASOURCE property set, and then attempt to create an accessor with the D
Defining XML Views over Relational Data
(Ronald Bourret) The current implementations of XML over relational databases follow two strategies: –A canonical mapping, such as that described in Mapping DTDs to Databases. –A query language, such as the FOR XML EXTENDED clause in Microsoft SQL Server. The problem with the first strate
Identity fields in Oracle and SQL Server
(Evagoras Charalambous) While it may be relatively easy to create an incrementing and unique identifier inside a table in SQL Server, things get tricky with Oracle. In this article, we’ll see the differences between the two databases and offer a way of solving the problem.
Process SOAP Headers in JAX-RPC Handlers
(Kevin Jones) Java API for XML-based Remote Procedure Calls (JAX-RPC) can be used to map Web services operations onto Java method calls. I discussed this concept in a previous article (“Write and Configure JAX-RPC Handlers,” January 7, 2004) that included how to write and configure JAX-RPC-based han
Tip: Use language-specific tools for XML processing
(Uche Ogbuji) DOM and SAX are the two best known systems for XML processing, but they are really compromises across programming languages. As such, they do not take advantage of any language’s particular strengths. Often it is better to duck conventional wisdom and use special APIs that take advanta
The Ox Documentation Tool
(Michael Fitzgerald) Ox is a simple documentation tool for people who regularly work at the shell or command-prompt level. It’s a command-line Java program that accepts a keyword or term as input and then returns documentation for that term. It’s free, open source software (BSD license), and because