(Lucas Jellema) One of the components in the ADF Faces library you may not make use of on a daily base is the . In this article, I will give you an example of how to apply this component – as it is slightly more complex than you may expect at first glance (or at least than I expected at […]
Author: SSWUG Research
Managing content in a rich media world
(Dan Goodin) For years, directors at the Dallas Museum of Art faced a daunting problem that threatened to stifle the growth of the century-old organisation. The prolific use of computer-generated content was requiring them to store ever more videos, audio clips, and digital images relating to the mu
Make .NET 1.1 and 2.0 apps work on Windows Vista
(Brian Eastwood) There was a bit of hullabaloo recently when Microsoft announced that Visual Studio 2005 was the only version of VS that would be supported in the Windows Vista operating system. Contributor Mike Gunderloy covered all the bases in Visual Studio vs. Vista: What’s going on here? (R)
Error handling in SQL Server 2005
(Muthusamy Anantha Kumar) In SQL Server 2005, error handling was made easy. This article illustrates various methods of handling errors using the TRY and CATCH command and various ERROR_ functions.
New JDBC SQL/XML Features Improve XML Data Handling
(Oliver Kaljuvee) The new version of the Java Database Connectivity API (JDBC 4) is getting a major face-lift with many great new features. Perhaps the most important update is the support for the XML data type, defined by the SQL 2003 standard. While storing XML in the database and having your appl
MySQL Can’t Use Index With Uncorrelated IN Subquery
(Alex Gorbachev) Today is the first time I had to look at MySQL performance. Tiny database as web application back-end was having significant performance issues with spikes of CPU workload. After identifying problematic queries, I found a pile of statements using IN subqueries.
Migrating/upgrading Oracle database from Unix to Linux
(Brian Peasland) I want to migrate an Oracle 7.3 Unix database to Oracle10g on RedHat Linux without losing any data. How to migrate the database? Please tell me the steps. (R)
DB2 Symposium 2007 in Chicago, IL
The DB2 Symposium is a multi-day training event. You have a daily choice of three full-day, in-depth seminars. All sessions are done by the best quality trainers in the DB2 market. You can join us for one, two, or three days. You only pay for what you find interesting! No waste of time or money. If
SQL Tracing in Self Service Applications (CRM) within Oracle Applications 11i
(Gerwin Hendriksen) In a lot of cases it is very interesting to be able to trace Self Service Applications (CRM) in Oracle Applications 11i. Most of the time it is very hard to understand what is going on in such a session and in that case it might be very handy to get the SQL behind it. To do this
Using SQL for IIS Logs Part 2
(Don Schlichting) The previous article began with the benefits of utilizing Microsoft SQL Server for Internet Information Service (IIS) web log analysis. While there are many third party packages on the market for web log analysis, sometimes you may need highly specific information derived from the