(Wally Terhune) Database and system administrators who are responsible for a UniData system that has the Recoverable File System (RFS) feature enabled will find this article most helpful. All RFS status and error messages are recorded in the $UDTBIN/sm.log file. You will find examples to help you fi
Author: SSWUG Research
The auto update statistics option, the auto create statistics option, and the Parallelism setting are turned off in the SQL Server 2000 or SQL Server 2005 database instance
This article discusses why the auto create statistics option, the auto update statistics option, and the Parallelism setting are turned off in the Microsoft SQL Server 2000 or Microsoft SQL Server 2005 database instance that hosts the Microsoft BizTalk Server 2004 BizTalkMsgBoxDB database or the Mic
Release the full potential of MySQL with these 10 power tips
(Mellonfire) MySQL is easy to learn and use, and comes with extensive documentation—two factors that have contributed a great deal to its popularity. However, given the speed at which the MySQL code base evolves, even veteran MySQL users are sometimes pleasantly surprised to discover hitherto-unexpe
Interactive Sorting Within Reporting Services
(William Pearson) A common request within the implementation of enterprise reporting systems is to endow the reports of our users with interactive features. While we have spent a great deal of time upon parameterization in general (even discussing parameterized sorting in Black Belt Components: Ad H
Oracle Under Pressure
(Kristen Kenedy) Solution providers, along with their vendor partners, are pressuring Oracle executives to reduce software licensing costs for multicore processors.
User-defined Interfaces in PHP 5: Introduction to Core Concepts
(Alejandro Gervasio) PHP5 takes users increasingly in the direction of object-oriented programming. The Standard PHP Library (SPL) is a new item that helps developers both with the creation of OOP applications and the maintenance of standardization. The SPL enables developers to work with user-defin
Cursors and embedded SQL
(Phil Factor) The development foot soldiers in the IT army are required to have two arrows in their quiver: fluency with the procedural language currently in fashion and a measure of skill in database programming.
Improving concurrency by knowing your application (Part 2)
(Chris Eaton) In addition to the DB2_SKIPINSERTED registry variable I discussed in my last posting IBM delivered the DB2 _EVALUNCOMMITTED feature in 8.1.4. By setting this registry variable to ON, DB2 will examine rows that are currently locked as the result of a currently uncommitted transaction.
Application Auto Update in VB.NET
(Eduardo Oliveira) This code enables an application to update itself when there is a new version available. The auto update is transparent to the user and checks for new updates every time the user launches the program. This code was written to be used in a controlled environment (intranet) and is n
Staying Power!
(Stephen Swoyer) Common Business Oriented Language and Assembler rule today’s mainframe shops, but enterprise codejockeys have more application development options than ever. Even programmers who have little or no mainframe experience can write C, C++ or Java code on Windows and Linux systems and re