(Murray White) Before we can discuss the technologies and Best Practices that will improve business software in 2005, architects and developers need to recognize a simple, often painful truth: Software development creates negative value. It’s only when software is put into production that it can
Other News
Comparing XSLT and XQuery
(J. David Eisenberg) XSLT has been the main XML technology for transformations for some time now, but it’s not the only player in the game. Although XQuery is designed for retrieving and interpreting information, it is also, according to the specification, “flexible enough to query a broad spectrum
Using Oracle’s Heterogeneous Services
(Scott Stephens) Oracle’s Heterogeneous Services layer is a way for an Oracle database server to access data on external, non-Oracle databases transparently using Oracle. For example, you can configure Heterogeneous Services and SQL*Net to access a Microsoft Access database through ODBC or OLE DB.
Apache and the Internet (Sample Chapter)
(Peter Wainwright) This chapter is an introduction to both Apache and the concepts that underlie it; that is, the Hypertext Transfer Protocol (HTTP) and the basics of networking and the Internet. It’s aimed at those totally new to Apache and Web servers in general. This chapter is introductory in na
How To Ensure the CEO & PHP Enjoy Love at First Sight
(Robert Peake) I firmly believe that the biggest obstacle to PHP becoming widely accepted in the Enterprise is not a lack of useful features, obscure faults within the PHP4 parser, or any other esoteric technical detail. One of the main reasons PHP projects get a bad repuation is that often PHP proj
RACF, Started Tasks and System Privileges
(Michael Cairns) As a Resource Access Control Facility (RACF) security administrator and occasional systems programmer, I’m often asked why a job, started task, or user ID has lost access, stopped working or won’t start when it was “working perfectly yesterday” and the customer “changed nothing.”
Prevent Twinkling Measures via Single Grain Fact Tables
(Todd Schraml) When creating a star schema, the most important concept is fashioning each fact to contain a single grain. Without an enforced single grain, the fact will need to support measures that twinkle in and out of existence as data from the fact is summarized to varying levels. The grain
Trace Messages Part III: Ending Sessions and Adding Metrics
(Andrew Novick) The current theme is about application trace messages. The previous two articles (Part I and Part II) described the AppSession and the AppSessionTrace tables and the stored procedures that insert and update their rows.
Using 64-Bit Virtual Storage and Large Real Storage to Improve Performance and Availability in DB2 for z/OS
(Jeffrey Berger) Version 8 of DB2 for z/OS now supports 64-bit storage in the DBM1 address space in order to provide some virtual storage constraint relief (VSCR). Likewise the IRLM address space now supports 64-bit storage. The 64-bit storage exploitation in Version 8 provides for performance a
Microsoft SQL Server 2005 Analysis Services – Unified Dimensional Model (UDM). Can you get your head round it? If you do BI, you’ll need to!
(Mat Stephen) There are very many, and from my own professional perspective, too many (I’ve got to try and learn all this stuff) new features in SQL 2005. Some of them can be described as ‘catch up’ features and some of them might be described as ‘tick in the box’ features. There is one that is wh