(Allan W. Tham) This article serves as a skill transfer for existing MySQL database administrators to learn about DB2 Express-C edition for backup and recovery. You may already be familiar with the way databases are backed up and restored in MySQL; this article highlights the features and functions
Author: SSWUG Research
Search WebSphere Portal Document Manager using WebSphere Information Integrator OmniFind Edition
(Janet Lee) An enterprise search system provides extensive capabilities for searching any number of structured and unstructured data sources with a single point of access. The search components installed with WebSphere Information Integrator OmniFind Edition (OmniFind) can collect diverse enterprise
What is ‘RSS’ in Plain English and Do I Need It?
(Barbara White) RSS (Real Simple Syndication) is the talk around the net these days because of its many benefits. However many people are not really clear exactly what RSS is?
Microsoft-Specific XML files in Windows (Part I)
(Ed Tittel) You can learn a lot about XML and Windows by executing the following command sequence on any modern Windows (2000 or newer) desktop or server machine: cd c:dir *.xml /s >> xmlfiles.txt (R)
Tools for Your .NET Space
(Christian Shay) You’re working on some C# or VB.NET routines that manipulate data you’re retrieving from Oracle Database. You need to access the database to edit and debug some stored procedures, modify some data in a table, change the structure of a table or view, or perform one of countless other
Multiple MySQL Vulnerabilities
(Sophos) Several vulnerabilities have been reported in the MySQL database manager, which could be exploited by attackers to compromise a vulnerable system or obtain sensitive information.
You can enable the lock pages in memory permissions to prevent SQL Server 2005 64-bit buffer pool memory from being paged out of physical memory
Under certain circumstances, the working set of the Microsoft SQL Server 2005 64-bit process may be paged out by Microsoft Windows. This behavior may cause a decrease in SQL Server 64-bit performance. Microsoft has found an issue that may cause the SQL Server 2005 64-bit working set to be trimmed.
WebSphere Replication Server Using Q Replication High Availability Scenarios for the AIX Platform
(Nagraj Alur, Steffen Herold, Huey Kim, Makiko Tsuchida and Mark Wiman) This IBM Redbook provides detailed instructions and scripts on managing failover and switchback in a bidirectional Q replication environment for the AIX platform. (pdf)
Introduction to Basic SQL, Part 3 – Complex Joins and Sub-queries
(Lewis R Cunningham) In my previous article, I covered SQL Joins with two tables. Today, I will cover joining tables with three or more tables and using sub-queries to join. I’ll also throw in some details about the UNION clause and show other places a sub-query might be used.
Reaching the Mobile Market with SMS.ac and xPML
(Ray Rischpater) The last five years has seen a revolution in mobile application development as carriers around the globe have embraced developers in an effort to raise the average revenue per subscriber (ARPU). It’s an exciting fact that, as developers, we can now tap carriers to distribute mobile