(Stuart Frost and Mark Theissen) The topic of data security breaches is increasingly in the daily headlines. We have all seen the headlines about data theft incidents from companies such as CardSystems Solutions, ChoicePoint and several educational institutions. In addition, companies such as Bank
Other News
Oracle Critical Patch Update
A Critical Patch Update is a collection of patches for multiple security vulnerabilities. It also includes non-security fixes that are required (because of interdependencies) by those security patches
IDC: Oracle Builds Comprehensive SOA Platform
Discover how a well-constructed, standards-based SOA can empower your business environment with a flexible infrastructure and processing environment. Efficiencies in the design, implementation, and operation of SOA-based systems can allow organizations to adapt far more readily to a changing environ
Making Complex Data Simple: Transforming Your Data Transformation
(Joseph Schwartz) Business integration initiatives always start with an elegant premise: as data is the lifeblood of the real-time enterprise, efficient integration will make data flow more easily throughout corporate and partner systems, thus enabling quicker response times to new opportunities and
Connecting and prepared statements with the mysqli extension
(Ian Gilfillan) Change is afoot in the PHP/MySQL world. In quite a short space of time, we have moved from MySQL 3.23.x and PHP 4.x, to PHP 5.x and MySQL 4.1.x and now 5.0.x. I have written about some of changes in new versions of PHP, as well as in MySQL. The more grown-up a platform becomes, the m
Practical Solution to SQL Server Performance Monitoring
(Serhiy Snisarenko) The list of common DBA tasks includes setting up a server performance base line and comparing the performance of two or more servers. We often have to do this urgently when our customer calls and expects us to identify and remove a performance bottleneck right away. The following
Fetching New Features
(Willie Favero) One of the coolest features in DB2 for z/OS version 8 turns an old programming rule on its head. For years, we taught DB2 application programmers not to use arrays (with the exception of the indicator variable). DB2 version 8 changes that with multirow FETCH and INSERT.
Permissions on an XML Schema Collection
As described in the topic, Managing XML Schema Collections on the Server, you can create an XML schema collection and use it to type variables, parameters, and columns of xml type.
SQL Server Replication
(Mike Chapple) SQL Server replication allows database administrators to distribute data to various servers throughout an organization.
A Practical Guide to Migrating From Oracle to MySQL
With the rapid growth of MySQL in the database market, many corporations, government agencies, educational institutions, and others have begun to migrate away from their expensive and proprietary databases. Of course, a migration from any database is not something to be taken lightly, and so countle