(Uche Ogbuji) A recent conference on XML in the financial services industry was an occasion for sober reflection on XML in the real world. Is XML finding its way into practical solutions? What best practices are guiding the adoption of XML? In this column, Uche Ogbuji ponders XML through the prism o
Other News
HA: How Affordable? (High-Availability)
(Jeff Spicer) System downtime is expensive—very expensive, depending on your business. In some industries when a critical system or application fails or is taken offline, the cost can run millions of dollars per hour—and that’s just in lost sales or transactions and doesn’t take into account damage
Microsoft SQL Server Survival Guide
(Gregory A. Larsen) I don’t know if you are like me but I like to have document and coding examples to help me manage applications and Microsoft SQL Server. I am not sure what I would do without good documentation and a few code examples to help me maintain my SQL Server environment. Microsoft has d
A Practical Guide to Data Warehousing in Oracle, Part 2
(Dave Aldridge) Some of the major differences from OLTP systems that you will encounter in data warehousing are the types of tables. The Oracle Data Warehousing Guide names and describes two major table types – facts, and dimensions, and if you were not sure of the difference, it would be worthwh
Just the Stats, Ma’am
(Robert Catterall) Statistics reports can reveal surprising facts about the subsystem you thought you knew well. I wrote a column last year about the wealth of performance and tuning information available in DB2 monitor accounting reports. I promised to similarly cover statistics reports, which
DB2 Command Line Processor Tips and Tricks
(Paul C. Zikopoulos and Roman B. Melnyk) If you are an experienced database administrator (DBA) you likely use a mix of graphical user interface (GUI) tools and the IBM DB2 Universal Database (DB2 UDB) command line processor (DB2 CLP) to accomplish your day-to-day tasks. In some cases, the differenc
Oracle9i SOAP Vulnerability Found
(Lisa Vaas) Oracle Corp. last week revealed that a potential security vulnerability has been discovered in its Oracle9i Application Server and Oracle9i Database Server.
Generate .NET XML Documentation With NDoc
(Chris Cyvas) Systems documentation is one of those tasks that often suffers during the completion of a project. It’s frequently pushed to the end of the development cycle, if it appears at all, in order to minimize redundant work. However, with XML Documentation support in C# and VB.NET, and th
Chapter 13 Thirty best practices for integrating Web services
(Thomas Erl) If you know that Web services will be a strategic part of your enterprise, then you need to start somewhere. A single application project, for instance, provides a low-risk opportunity for taking that first step. You will be able to integrate Web services to a limited extent and in a co
Replicating spatial data in DB2 UDB
(Knut Stolze) This article describes an approach for using the existing replication facilities in DB2 UDB to replicate spatial data by transforming it to an external representation based on LOBs, and replicating those LOBs. Sample setup program included.