(Double Xia) The PHP Data Objects (PDO) extension provides a lightweight, convenient means for accessing databases in PHP. However, you must use a database-specific PDO driver to access a database server. Currently there is no PDO driver for the IBM U2 data servers, Uni Data and UniVerse. In this ar
Other News
SelectViews: Compliance, SQL Server on Vista, the SSWUGdex and more.
Video Programming for IT Professionals
SQL Statement Generator
(Chris Hambleton) The SQL Statement Generator is a Windows application that loads a DataTable from the specified query and then generates INSERT, UPDATE, or DELETE SQL statements based upon the type of SQL command and the selected columns of the DataTable.
MySQL 4.0 has reached the final stage of its lifecycle
(Kaj Arnö) MySQL 4.0 has now reached the final stage of its active development life cycle. As I noted on 12 July 2006 when announcing the MySQL Lifecycle Policy, keeping legacy versions of our software alive is expensive and time-consuming. While we know that database administrators hate to upgrade
Add IBM OmniFind Yahoo! Edition to your Web site
(Todd Leyba) Learn how you can quickly and easily integrate a freely downloadable search engine into your Web site. This article describes four methods to do this, using IBM OmniFind Yahoo! Edition search functionality. The methods range from directly linking to the OmniFind search results page, to
Oracle RAC Administration – Part 10:The RAC DBA
(Tarry Singh) Since my last article, quite a few developments have taken place. Oracle has not only continued its onslaught on Red Hat but also opened up its own version of Enterprise Linux for download. Larry Ellison did mention in one of his older interviews that buying Red Hat would not add much
Decoding the Mysteries of .NET 2.0 Configuration
(Jon Rista) One of the wonderful features of .NET has been its XML configuration features. In the days of .NET 1.x, common application settings, database connection strings, ASP.NET web server configuration, and basic custom configuration data could be stored in a .config file. Custom configuration
A Beginner’s Recipe for a Service-Oriented Architecture
(Paul C. Zikopoulos) Every vendor has a service-oriented architecture (SOA) story; they just might not realize it yet, partly because the SOA terminology can be confusing to the uninitiated.
Pitfalls of Oracle’s Automatic SGA Management
(Raj Thukral) Of late, Oracle has had the tendency to automate a lot of the usual DBA tasks.
DB2 9 table partitioning
(Paul Read and Richard Hewitt) This tutorial is designed to demonstrate the functionality of range partitioning in DB2 9. Participants will receive the hands-on experience of using the features of Range Partitioning with DB2 tables. Table partitioning is a data organization scheme in which table dat