(Phlip) XPath is a complex query language that provides substantial benefits. It treats XML as a database, permitting queries as powerful as SQL SELECT. This post shows how to use a nifty visual explorer, XPath Checker, to write aggressive and accurate queries. Then we install these queries into tes
Other News
Using JMS connection pooling with WebSphere Application Server and WebSphere MQ, Part 1
(Paul Titheridge) Creating connections from WebSphere Application Server to a Java Message Service (JMS) provider such as WebSphere MQ is costly in terms of both time and processor requirements. To improve performance, WebSphere Application Server maintains a pool of free connections that can be giv
.NET Building Blocks: Build a RichTextBox-Based Syntax-Highlighting Editor and IDE
(Michael Sorens) How difficult do you think it would be to create a SQL tool like Query Analyzer or SqlServer Management Studio? How about a programming and execution framework for VBScript? Or how about a dual code-and-WYSIWYG editor for HTML—or a development IDE for creating and testing XSLT trans
RMAN Disk to Disk Backup Methods
(James Koopmann) There are three distinct options available for an installer of an Oracle database. Those available storage options for database files are File Systems, Oracle’s Automatic Storage Management (ASM), or Raw Devices. Each of these storage options are defined further in the Installation
FIX: A Service Broker endpoint stops passing messages in a database mirroring session of SQL Server 2005
In a database mirroring session of Microsoft SQL Server 2005, a Service Broker endpoint stops passing messages from the initiating service to the target service. This problem occurs periodically and with increasing frequency.
5.1.20 Gotcha – The MySQL Error Log
(Ronald) While using the latest MySQL 5.1.20 yesterday I came across another situation that was not expected as with previous editions of MySQL. The background is experimenting with DRBD. When I configured MySQL to startup with a /etc/my.cnf file with data on a DRBD partition I got a failed startup
DB2 9 and Microsoft Excel 2007 Part 3: Building Your Own Queries…
(Paul Zikopoulos) In my last two articles on Microsoft Excel 2007 (Excel 2007) and DB2 I showed you how to get DB2 data into your worksheets and work with that data with some of the new advanced and very powerful features that are new in Excel 2007; at the same time, I’ve been introducing you to the
Using the New ASP.NET ListView Control
(Dan Wahlin) ASP.NET 3.5 introduces a new control called the ListView that allows developers to have 100% control over the HTML markup that is generated while still providing paging, inserting, updating, and deleting support. To me the ListView control is a nice blend between the GridView and Repeat
Partitioning in Oracle Database 11g
Oracle Partitioning, first introduced in Oracle 8.0 in 1997, is one of the most important and successful functionalities of the Oracle database, improving the performance, manageability, and availability for tens of thousands of applications. Oracle Database 11g introduces the 8th generation of pa
Handling Windows Forms Data Binding Errors
(Jon Kruger) Data binding is great, but one thing that newbies do not know is that data binding will eat exceptions and never tell you – unless you know what events to listen to.