(Naveen Karamchetti) During the development of complex maps using the BizTalk Mapper tool, one encounters several situations where custom mapping would be required in order to complete a transformation. This article will explain how to perform custom XSLT transformations using the BizTalk Mapper too
Author: SSWUG Research
Rapid J2EE Development with Oracle ADF
(Michael Klaene) In a push toward simplified J2EE, vendors have been unveiling rapid application development (RAD) tools at a furious pace. Today, for example, most integrated development environments (IDEs) provide wizards to generate the mundane and repetitive framework code necessary when buildin
ASP.NET Outlook-Like Time Field
(Steven Berkovitz) The IT side of my company is almost completely service based, mostly involving on-site technicians. We have an internal e-Business portal that we use to track services rendered to the clients. The complaint I received most often from our technicians was how annoying it was to ente
Running MySQL queries on multiple servers
(Mark Alexander Bain) You may know how to use SQL to extract data from a table in a MySQL database, and how to run a query that combines data from more than one table. But what about multiple databases? Or even multiple databases on multiple servers?
System Tables and Catalog Views
(Muthusamy Anantha Kumar) When a new version is released or when existing software is upgraded there is always a learning curve and getting used to new ways of doing things. This article demonstrates how to use SQL Server 2005’s catalog views in comparison with using system tables in SQL Server 2000
OLAP SQL Part 1 – Rollup
(Chris Eaton) If you haven’t noticed by now I post a lot of stuff on what I find to be interesting SQL. I like to find ways to do more in the DB2 engine with a single call. Often folks don’t have the time to learn about all the abilities that DB2 SQL has available so over the next few […]
An Interview with Jonathan Robie — The co-inventor of XQuery
(Ivan Pedruzzi) Jonathan Robie is one of the inventors of XQuery. He’s been involved with the XML Query Working Group since the beginning, and has been an editor since the first documents were published by the W3C. Jonathan is the XQuery Technology Lead for DataDirect XQuery, a high-performance, emb
Process Portals: A New Way to See Business
(Alan Joch) Knowing their business’s key metrics was vital for Texas Industries (TXI), the growing Dallas, Texas, building materials supplier. With 100 locations and 2,800 employees across Texas, California, and Louisiana, TXI needed to keep a tight rein on business processes for sales, scheduling,
Dealing with images in content management systems, Part 2
(Tom Crane) Regardless of whether the user uploaded a new raw image or picked a thumbnail, we have now supplied the control with information about the image’s width and height, and what the server ID is (either newly generated or inferred from the thumbnail).
Generic Code in ADO.net 2.0
A majority of applications today use a database at the back-end. In application software, database systems have become indispensable. As there are many open and closed source database systems available, the development team has to make a choice as to the database system that they will use in their a