(Rich Niemiec) I’ve worked with TUSC, a major Oracle Integrator for almost two decades. Over the past 5 years, I’ve seen three major trends that seem to be molding the future of database administration. The first is the adoption of real applications clusters (RAC) and an accelerating trend toward gr
Author: SSWUG Research
Integrate unstructured content into a distributed federated system, Part 2: Develop a connector for WebSphere Information Integrator Content Edition
(Ryan Graciano) WebSphere Information Integrator Content Edition (II CE) provides a single interface to any number of content repositories and workflow systems. This single interface makes it easy for application developers to integrate all of their information sources into new or existing enterpris
IBM DB2 databases and Enterprise Core Objects (Delphi 2005)
(Bob Swart) This article shows how to use Borland Delphi 2005 and the Enterprise Core Objects (ECO) to import an IBM DB2 Universal Database (DB2 UDB) database and create a UML object model for it, which is the basis for a .NET WinForms application. The object model (called EcoSpace) uses the DB2 UDB
Develop and Test Regular Expressions with a Unit Testing Package
(Casimir Saternos) Oracle Database 10g includes a variety of new features that provide new and better ways of solving old problems. Regular expressions have been in common use among UNIX users for a long time but may not be familiar to programmers and users from other backgrounds.
The Oracle 10g Data Pump API Speeds Up the ETL Process
(Natalka Roshak) Consider the following scenario. You have a production system that needs a lot of data from other systems on hand during the day. The data sources that you get this data from return results slowly, and you’ve got network latency that results in slow extracts. Additionally, a fai
SQL Profiler: Features, functions and setup in SQL Server 2005
(Jeremy Kadlec) Trying to find the proverbial needle in the haystack of your SQL Server transactions is no small task. SQL Server Profiler not only helps you find that needle, it gives you details on all the other needles in a single interface. Profiler is truly the best native SQL Server resource t
Cache Your Data: JDBC Vs. ADO.NET
(Gal Ratner) Since the data is usually physically separated from your application you need to somehow fetch and bring it to your application before it can be displayed to users, manipulated and saved back to your data source. In this article, we will compare and contrast the use of Java and .NET to
Service-Oriented Architecture and Microsoft .NET
(John Charles) To be competitive, companies must be agile; this one has become critical for competitiveness. They constantly have to adapt their organization and environment to more and more frequent technological changes, merges and acquisitions. But technology is often expensive and difficult.
ASP.NET 2.0 (I) Enhancements to Existing Controls
(Chris Sully) This article is the first in a series looking at ASP.NET 2.0 though it follows on from my earlier overview articles on the subject. In this article we’ll start with a consideration of the enhancements to existing controls that have been introduced. Many controls have gained new propert
Kewl DB2 for z/OS Version 8 Feature Part 2b: Multi-row INSERT & FETCH Continued
(Willie Favero) Continuing on from where I left off yesterday, let’s complete the discussion about multi-row processing in DB2 V8 with a few words about multi-row INSERT. My discussion of multi-row FETCH and setting up the arrays used by multi-row processing can be found in my entry posted on Januar