This tutorial shows you how to build asynchronous applications using DB2, WebSphere MQ and WebSphere Application Developer. (R)
Other News
SQL Building Blocks and Server Settings
(Deac Lancaster) This chapter covers the building blocks available to the database designer and database user to create and modify database objects and data. The SQL Data Types will be covered along with data representation as literals (constants) and expressions. Also covered are methods to display
A Quick Introduction to SQL Server Management Objects (SMO)
(Darshan Singh) SQL Server 2005 introduces new and improved features for both, developers and database administrators. Developers now can write stored procedures using any of the managed .NET language, work with XML and XQuery, Web services-enable their T-SQL code, create scalable asynchronous messa
How to Identify Non-Active SQL Server Indexes
(Luis Martin) As a DBA, it is our regular task to review our databases and see if there is any way we can boost their performance. While adding new or better indexes to a database is one of the primary ways we can boost performance, an often forgotten way to help boost database performance is to rem
Taming the Wild West, Part 2
(Michael Dougherty) Part 1 of this series explained how corporate portals and intranet sites sprang up in a fairly lawless environment. Corporate overseers rode into town in the late 1990s, but governed mostly at the local (departmental) level. Today, Web content management (WCM) systems provide
Developing Faces
(Chris Schalk) Building enterprise J2EE Web applications has always been a bit of an art. Although J2EE provides more-than-adequate foundational technologies for building scalable enterprise Web applications, it previously lacked a high-level API to glue these technologies together and provide a sin
Taming DB2 Performance Issues
(Craig S. Mullins) One of the biggest problems faced by companies today is keeping applications running at peak efficiency. It can be a never-ending task to diligently keep collecting, examining, and reacting to performance-oriented statistics. This is certainly the case for DBAs charged with mainta
INFO: MTS/IIS Interoperability with IBM DB2, Using Two-Phase Commit Through MSDTC/XA
Any transactional Microsoft Transaction Server (MTS) activity (in other words, a transactional MTS component or Internet Information Server [IIS] Active Server Page) calls upon Microsoft Distributed Transaction Coordinator (MSDTC) to initiate an OLE TX transaction, which is a two-phase commit protoc
Building Practical Solutions with EXSLT.NET
(Oleg Tkachenko) This article shows how to make XML programming easier and to boost your productivity using XSLT and XPath extensions, provided by the EXSLT.NET library
ADO.NET: Generate XML with data from SQL Server
This sample illustrates how to produce XML from SQL Server using two different techniques. The first uses the ExecuteXmlReader method of SqlCommand to get an XmlTextReader, which is then populated into a DataSet using the ReadXml method of the DataSet class. The second uses the SqlDataAdapter to ext