(Kulvir Singh Bhogal) Newton’s third law states that for every action, there is an equal and opposite reaction. Don’t worry, I’m not giving you a physics lesson. In this article, I will be guiding you through the concept of cause and effect as implemented in a database application that brings togeth
Other News
OLE DB Provider for Oracle
The Microsoft OLE DB Provider for Oracle provides access to Oracle databases. Using the Microsoft OLE DB Provider for Oracle, Microsoft SQL Server distributed queries can query data in Oracle databases.
Updating XQuery
(Jason Hunter) In “X Is for XQuery” (Oracle Magazine, May/June 2003), I introduced XQuery, a technology under development by the World Wide Web Consortium (W3C) intended for querying and manipulating XML data or anything that can have an XML facade, such as a relational database. That introductory a
Raising the XML flag
(David Becker) The last time Microsoft updated its Office productivity package, one of the company’s most reliable moneymakers and one of its most mature and predictable products, the big news was the disappearance of Clippy, the animated helper customers loved to hate. This time around, XML pla
Database consultants can’t wait FOR XML
(Dan Frumin) XML has penetrated every aspect of business applications, from data interchange to presentation logic using tools like XSLT. It seems that if an application doesn’t use XML, something is missing. But none of this is enough to unseat the reigning champion of storage: the database.
Optimize SQL Server Data Access
(Roger Jennings) Moving your data-access applications to ADO.NET and XML Web services from traditional ActiveX Data Objects (ADO) and OLE DB providers presents new challenges for you and your organization’s database architects and database administrators (DBAs). The .NET Framework’s System.Data.
How to Delete SQL Server Database Duplicate Rows from a Table
(David VanDeSompele) As much as we try and prevent it, duplicate data still finds its way into corporate data systems, but the good news is that purging duplicate rows can be a relatively simple task.
Head-to-Head: Siebel vs. Oracle CRM
(Joe Outlaw) Siebel is still the undisputed CRM-application market leader when it comes to functionality. But, as market demand shifts away from pure CRM enablement and toward business-process automation, vendors with broader application footprints — like Oracle, for example — are growing in popul
Working with SQL Server Date/Time Variables: Part Two – Displaying Dates and Times in Different Formats
(Gregory A. Larsen) In my first article in this series, I discussed different aspects of entering date/time data into SQL Server DATETIME and SMALLDATE columns. This article will expand my discussion of date/time data by exploring how to use different SQL Server functions to display dates and times
Using Java with DB2 for OS/390
(Craig S. Mullins) Just about everyone has at least heard of Java and how it is going transform the world of IT. But just because you’ve heard about Java doesn’t mean you fully understand it. And even if you know a bit about Java, there is always more to discover. Let’s face it, there’s a lot of hyp