(Justin Whitney) With the release of IBM’s DB2 9, formerly known as Viper and currently in Release Candidate, IBM also plans to unveil the new DB2 9 Developer Workbench. Existing DB2 users will recognize the functionality as the current DB2 Development Center. But the new version, available as a fre
Author: SSWUG Research
Creating a StAX Filter for XML
(Anghel Leonard) This tip creates a StAX filter using the javax.xml.stream.StreamFilter interface. This filter accepts only characters, but you can also set the filter XML to retrieve only elements, attributes, or both.
Working with MySQL and Sessions to Serialize Objects in PHP
(Alejandro Gervasio) If you’re interested in learning how to combine objects, sessions and MySQL, this is the article that you’ve been waiting for. It’s the final part of the series “Serializing objects in PHP.” In three parts, this series goes through the fundamentals of serializing objects in PHP
See who is logged into the database
(Patricia Ashe) This is a script that was passed down to me about eight years ago from another DBA and I have passed it on to others. I use it all the time to see who is logged into the database. I use it when I have to kill an OS process for a user connected to the database or […]
A Memory Mystery
(James Edmiston) I was recently approached by one of my clients to analyze how Informix used memory on their system. The client was concerned about a potential “memory leak,” that might have occurred while some queries ran. Over time, the client needed to reboot the system more often, presumably bec
Multiple Masters Pages in ASP.NET Application
(Ashish Singhal) This article will show that how can we add multiple master pages in run time and can access their properties.
Develop proof-of-concept .NET applications, Part 2: Wire DB2 data to Windows applications
(Chenhong Xia) This is Part 2 of a tutorial series that teaches you how to create proof-of-concept applications to access relational and XML data in IBM DB2 9, using Microsoft Visual Studio .NET 2005. Part 1 explained the application specifications, database design, and how to create DB2 relational
Binary File Access in the .NET Framework
(Peter Aitken) A previous article in this series explained how to read and write text files using the .NET framework. This article covers binary files—those files that contain non-character data (graphics, numbers, and so on).
The report of ‘excessive CPU consumption’ was an exaggeration.
(Willie Favero) My attempt here was to paraphrase Mark Twain’s quote “The report of my death was an exaggeration.” However, while trying to find the correct wording I discovered that most think Mark Twain actually said something similar but quite different. But you know, this isn’t my English Litera
FIX: The transaction takes longer than expected to finish when you try to insert rows into a SQL Server 2000 database
When you try to insert rows into a Microsoft SQL Server 2000 database, one or more of the following problems may occur: • The transaction takes longer than expected to finish. • Other transactions that insert rows do not take longer than expected to finish. • Error messages that have error co