(Bob Watkins) Oracle’s analytic functions provide a clean way to do gap checking. These functions allow you to see the value in an upcoming row or previous row, while still using the full set-oriented processing of SQL.
Author: SSWUG Research
Managing Many-to-Many Relationships with PL/pgSQL
(David E. Wheeler) A common pattern when managing the relationship between object-oriented applications and databases is the many-to-many relationship. Object-relational mappers usually manage these relationships as collections of objects, wherein one class has an accessor that returns a collection
Problem Symptoms in WebSphere for z/OS and Their Resolution
(Rica Weller, Cleberson Calefi, Kiet Nguyen, Robyn Nostalgi and Rajesh Pericherla) WebSphere for z/OS is a complex product made up of many components, similar to the human body. And, like the human body, WebSphere for z/OS can experience problems that need to be diagnosed and corrected. (R)
More on Rebinds and DB2 Version 8
(Willie Favero) So, you listened. You saved all of your V7 EXPLAIN data so you could compare it to the EXPLAIN output from your Version 8 rebinds. Your plan (no pun intended) should be to have both the old and new access paths (plan table rows) available so you can compare them. Of course, one essen
Track database object dependencies and analyze the potential impact of schema changes with SQL Dependency Tracker
SQL Server is being adopted by an ever wider user base. The upgrade to SQL Server 2005 has delivered a great deal more functionality and extensibility, and this has resulted in many more and larger companies rolling out the database platform right across their organization.
XML full-text search in DB2
(Holger Seubert and Sabine Perathoner-Tschaffler) With the support of natively storing XML documents, IBM DB2 9 takes an evolutionary step towards a hybrid database system. XQuery, a new primary language in DB2, allows for optimally working with XML. However, XML also often contains large portions o
The Simplest CRUD Operations for Lookup Tables in ASP.NET
(Jagadish Chaterjee) This article introduces you to implementing the fastest way to include CRUD operations for lookup tables in ASP.NET.
Windows Workflow: The Base Activity Library
(scott) The base activity library in Windows Workflow contains general-purpose activities for constructing workflows. There are activities for control flow, transaction management, local communication, web services, and more. These activities appear on the toolbox window of the workflow designer. So
Advanced XML Processing with StAX in ColdFusion
(Jim Collins) When MX was released, the Xerxes XML parser was state-of-the-art. Java XML processing has advanced significantly since then. This article will discuss these new developments and show how you, the developer, can leverage them from ColdFusion. Some experience with creating and using Java
Managing SQL Server 2005 Peer-to-Peer Replication
(David Lindquist) The Microsoft corporate Web sites rely heavily on databases, which power such high-traffic destinations as Microsoft Update, Download Center, Communities, TechNet, and MSDN. Microsoft.com operations has a team of 17 engineers, the SQL Server operations team, that manages these data