(Murali Vivekanandan) Enterprise JavaBeans (EJB) are the building blocks of Java Platform, Enterprise Edition (Java EE) applications, and the EJB Query Language (EJB QL) allows you to write queries without any knowledge of the relational schema governing the entity beans. This tutorial explains core
Author: SSWUG Research
Inversion of Control (IoC) in XAML
(Vincent-Philippe Lauzon) The code presented here allows the use of XAML to implement the Inversion of Control pattern (IoC, also known as Dependency Injection).
Using EXPLAIN EXTENDED to see view query rewrites
(Guy Harrison) At the MySQL Mini Conference in Sydney this week we discussed how to use EXPLAIN EXTENDED to view the rewrites undertaken by the MySQL optimizer. IN particular, to see if MySQL performs a merge of the query into the view definition, or if it creates a temporary table.
Parsing XML As Query Object In Coldfusion
(Ben Cortese) I work in the financial industry as a developer and not that the financial industry has any greater implementation of XML than any other, but web applications that utilize back office processing for loan applications, or new account opening processes, or retail internet banking applica
Interesting V8 SQL Change
(Willie Favero) We spend a lot of time talking about the really neat stuff like multi-row FETCH & INSERT and such because they give you some significant CPU back when you change your applications to take advantage of them. However, DB2 for z/OS Version 8 had a lot of SQL added and enhanced. So today
BMC Recovery Manager for DB2 UDB Recoverable Load Made Simple
In the complex world of global business, every database operation needs to be done very quickly to cope with constant data changes. There are many ways to perform database operations quickly, but most are very complex. Is there anybbody who makes these complex operations simple, to help DBAs get the
ASP: Really this easy? Yes! (Part 2)
(Alex Homer and Dave Sussman) Just as you are leaning back and admiring your handiwork, the phone rings again. This time, it is the senior developer at AdventureWorks Trading Inc.––and he is not a happy fellow. His team has spent months building an object-oriented business and data access layer, and
Automate the process of trimming table data in SQL Server 2005
(Arthur Fuller) A friend and colleague recently faced an interesting problem. Each month he receives a huge amount of data from a client, which he then must massage before it’s usable. The tables contain millions of rows, and the structure of the tables may vary from month to month. To make matters
MySQL – No Index Used With ORDER BY + LIMIT and DISTINCT
(Alex Gorbachev) This is actually a follow up on my previous post. Developers tried to rewrite all statements and even overdid it. As we say in Russia – “teach fool how to pray and he will break his forehead”.
An emerging XML Web services security infrastructure
(Ed Tittel) Anybody who’s been following application development trends for any time knows that Web Services is fast becoming the veritable “hot seat” of the development world. It’s where the action (and the money) is, and has become a line of business if not an outright obsession for everybody from