(Eran Chinthaka) The implementation and invocation of asynchronous Web services is important to application development. UIs, which expose functionalities of Web services, have become increasingly interactive. As a result, asynchronous invocations and implementations have become more useful and effe
Other News
See how simple it is to create a fading form in VB.NET
(Irina Medvinskaya) While core functionality and usability of the application is always one of the most important aspects, various visual effects may improve the way users feel about a particular application. Even though you may be able to implement purely cosmetic features in an application, it’s i
A Visual Explanation of SQL Joins
(Jeff Atwood) I thought Ligaya Turmelle’s post on SQL joins was a great primer for novice developers. Since SQL joins appear to be set-based, the use of Venn diagrams to explain them seems, at first blush, to be a natural fit. However, like the commenters to her post, I found that the Venn diagrams
Passing Arrays in SQL Parameters using XML Data Type in SQL Server 2005
(Vincent-Philippe Lauzon) Passing arrays of values as SQL parameters has always been troublesome in T-SQL. In SQL Server 2005, the XML data type can help simulate arrays.
Efficient PL/SQL Coding
(Arup Nanda) Since its inception, PL/SQL has been the language of choice for programming in Oracle Database. Over a period of time, we have seen the language evolve into a comprehensive development platform by virtue of more and more functionality that requires less coding. Oracle Database 11g makes
How to Create a Web Server Farm Cache
(Dina Fleet Berry) Dynamic database-driven web sites are required if your site has large quantities of data to upload, manage, and serve back to your customers. However, IT departments typically say this creates too big a load for the database — hence many people keep the files on the hard drive al
Introduction to AS400 Programming Using .NET
(Nidal Arabi) This article is just a humble introduction to programming AS400 DB2. I did some research and found really no complete article on how to approach the AS400 machine using the .NET platform. There are really no big issues here, but I will tackle the basic foundations of creating a code fi
Sharepoint Interview questions
(Murali Bejjanki) Adoption of the SharePoint platofrm is growing rapidly and for every new deployment there is a requirement for staff to support and maintain it. Identifying the necessary skills in potential new recruits for individuals who have not had sufficient experience with this relatively ne
DB2 for i5/OS: User-Defined Servers to the Rescue
(Scott Forstie) DB2 for i5/OS customers are seeing an ever increasing use of SQL Server Mode. When trying to make sense of all the QSQSRVR jobs in the QSYSWRK subsystem, you might quickly come to the conclusion that it is nearly impossible to approach the question from the perspective of server jobs
Update XML in DB2 9.5
(Matthias Nicola and Uttam Jain) One of the most significant new features in IBM DB2 9.5 for Linux, Unix and Windows is the XML update functionality. The previous version, DB2 9, introduced pureXML support for storing and indexing of XML data and querying it with the SQL/XML and XQuery languages. Mo