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
Author: SSWUG Research
Manipulating Oracle Files with UTL_FILE
(James F. Koopmann) Take hold of your alert log with the use of a few new subprograms in the UTL_FILE package.
ASP.NET 2.0 and VS 2005: You win some, you lose some
(Rick Stahl) ASP.NET 2.0 and Visual Studio 2005 have been out for several months now, and many preople have had a chance to use the product in a day-to-day environment. Rick Strahl takes stock of the major changes and provides a personal perspective on some of the highs and lows.
XML on the iSeries
(G. Kelly) This time, I thought I’d have a look at XML on the iSeries. XML is fast becoming the standard for sharing data between different systems and knowledge of XML is vital to any IT professional. Our initial introduction to it was when we first installed WebSphere Studio Application Developer.
Database Skills Availability: Critical to Your Selection of Database
(Howard Fosdick) This white paper analyzes IBM DB2 Universal Database (DB2 UDB) from the standpoint of acquiring the skills required to install, use, manage and maintain the product. Some sections directly compare DB2 UDB to Oracle and Microsoft SQL Server. Others delve into DB2 itself and how IBM
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.
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
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
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
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