(Jyoti Jacob, Donald Farmer and Len Wyatt) The first phase of Project REAL included the migration of existing SQL Server 2000 DTS packages to SQL Server 2005 Integration Services (SSIS) for a large electronic retailer. One source of information for the data warehouse was from TLog files, which conta
Other News
Compiling PHP5 with mysql and mysqli Database Drivers
(John Berns) For years, the mysql library has been the standard for PHP development and a lot of great apps have been built running PHP and mysql. Now, with PHP5 there is a new database extension called mysqli that stands for “MySQL Improved.”
Using Ajax with PHP and Sajax
(Tyler Anderson) For years, the goal of creating a truly responsive Web application was hampered by one simple fact of Web development: To change the information on part of a page, a user must reload the entire page. Not anymore. Thanks to asynchronous JavaScript and XML (Ajax), we can now reque
Choosing an XML editor
(Thijs van den Broek) More and more people are working with texts and documents in XML format. With the increasing popularity of XML, the number of XML editors is also increasing and it can be difficult to choose the editor that best suits a particular user or task. The aim of this Information P
The Leap from Illusion to Fusion
(Alan R. Earls) As the great English lexicographer Samuel Johnson once noted, “A second marriage is the triumph of hope over experience.” Oracle, now well past its acquisition of Siebel and PeopleSoft/J.D. Edwards, is pinning its hopes for a successful marriage on a strategy it calls Project Fusion.
Apache, Cloudscape, and PHP on Linux
(Kevin Czap) Do you want to know how to build a PHP database application from scratch? This tutorial shows you how to install the IBM DB2 Run Time Client, which allows you to access the IBM Cloudscape database. We also install and configure the Apache Web Server to host the application and compile a
Oracle Technical Interview Questions Answered – Part2
(James F. Koopmann) The Oracle Technical Interview can be quite daunting. You never quite know what to study for and how to prepare. I am fully aware of this, as I have received many emails since my original article on interview questions was released. While these questions are only guidelines as to
The Composite UI Application Block
(Guy Starbuck) The composite UI Application Block (called “CAB” in the online community) is a new application block that is being developed by Microsoft patterns & practices and is scheduled for release shortly after the final release of .NET 2.0. The current code for the Composite UI Application Bl
A look inside the Java API for XML Processing
(William Brogden) At one time, programmers trying to process XML with Java programs had to hunt around for one or more libraries from Sun, the Apache Software Foundation, or some other source to add to their Java programming environment. However, beginning with Java 1.4, most XML processing task
Reporting Service using soap call passing XML to Data Extension
(Ken C. Len) This example uses an ASP.Net filter page to construct an xml which then is used as a parameter passed into reporting service web service call to render the report. The xml parameter is intercepted by a custom data extension DLL which is registered under reporting web service. The cu