(Rick Jelliffe) I taught a couple of full day courses last week, on XSLT and XML Schemas. The students were pretty positive banking programmers, and I only managed to disgrace myself once, when I became stroppy at a student I misheard: he was trying to be helpful, but I thought he was insanely and r
Other News
MDX in Analysis Services: Mastering Time: Change across Periods
(William Pearson) In this article and others subsequent to it, we will focus on time considerations in our MDX queries, and how we can successfully report change over time, as well as to accumulate those changes to present the precise snapshots, trends and other time-based metrics so dearly apprecia
DB2 Web Server applications on Linux with Kylix 3 (and WebSnap)
(Bob Swart) This article shows how to build a Web server application using Kylix 3, exposing the IBM DB2 UDB SAMPLE database on the Web.
Reuse Tiles and Simplify UI
(James Holmes) JavaServer Pages (JSP) technology supports application object reuse through includes, which allow other files (including other JSPs) to be sourced into a JSP file either at compile time or dynamically at application runtime. This is great for abstracting common elements of pages such
Parlez-Vous DB2 For LUW? (Part 2)
(Robert Catterall) In last quarter’s DB2 DBA column, I took you on the first leg of a tour of DB2 UDB for Linux, Unix, and Windows (LUW) conducted with mainframe DBAs in mind, but open to anyone interested in DB2 technology. That part of the tour focused on system aspects of DB2 for LUW, includi
SQL Server: Enterprise vs. Standard
(Rahul Sharma) For those implementing production servers using SQL, purchasing either the standard or the enterprise edition of SQL Server makes the most logical choice. The personal edition of SQL is for PCs and small workgroups, and the developer edition cannot be deployed since it is not meant fo
Unique and Primary Key Constraints in DB2 for OS/390 Version 7
(Cathy Lappe) It was another one of those Sunday night DB2 application implementations, complete with coffee, donuts, chocolate and dumps. My partner, Charles, was braving the cold to fetch some pizza and soft drinks for us as it was already beginning to look like a longer evening than we expected.
.NET Tools for Working with XML
(Peter G. Aitken) .NET provides a powerful set of classes for working with XML directly. This article provides an overview of the most important of these classes, and some examples of what you can do with them.
Examining SQL Server’s I/O Statistics
(Andrew Novick) Reading and writing to the disk is the heart of what any database management system does, SQL Server included. Input/Output (I/O) performance can make or break an application. This article discusses the diagnostic tools that can be used to examine SQL Server’s I/O statistics so t
Integrating Word, Excel, and InfoPath with SQL Server 2000
(Peter Kelly) Too often, an organization’s valuable data sits locked away, inaccessible to the people who could transform it into intelligence, insight, and, ultimately, competitive advantage. With the Microsoft Office System, you can use the data that resides in Microsoft SQL Server 2000 in ways th