Featured Article(s) Pivoting Data With Oracle 11g’s Pivot Operator One of the new Oracle 11g features is the Pivot and Unpivot operators used to summarize rows into summarized pivot tables. This article describes how to use this feature in your Select statements Do THIS SQL Job Before THAT One Did you know you can use SQL Sentry Event Manager to […]
Other News
Interoperability Still Stumbling Block for Open Source in 2008
(Peter Galli) Enterprise customers are using open-source software more and more, but issues of interoperability are still a stumbling block to widespread adoption, say customers and open-source software vendors.
Another charting option: XML/SWF Charts
(Raymond Camden) A few weeks ago I blogged about an alternative to ColdFusion’s built in charts, Google’s Chart API. This week I discovered another alternative, XML/SWF Charts. This isn’t a free option, but they have a free license with limitations and the price for a “full” copy is only 45 bucks fo
APAR of the week: PK47922: Allow Indexability…
(Willie Favero) In an effort to make this blog a little more interesting and to possibly add a little structure, this year I am going to feature an APAR each week (I’ll try for Friday’s) that I think sounds interesting. In most cases I will be avoiding APARs that fix something that broke unless it i
xmlcatalog.net
(Anthony Coates) A few years ago now, I was a (junior) member of the OASIS Entity Resolution TC, which produced the OASIS XML Catalogs specification (HTML, PDF). XML Catalogs are used to specify simple rules for re-writing or re-directing URIs in XML documents. This work was based on the catalogues
Appending nodes in XML files with xmlpeek and xmlpoke using NAnt
(Bil Simser) I’m currently doing a major automation-overhaul to our projects, trying to streamline everything. Part of this involves doing automated deployments of the projects to a location (say a file or web server) where a QA person can come along later and with the click of a button they can jus
Rails 2.0: XML data type and DB2
(Leonardo Borges) In my new job we work with XML data natively stored on DB2. I have done some test with Rails and DB2 a few weeks ago and it’s pretty interesting, specially the easiness that Rails deals with XML.
Building the DB2 Health Monitor Sample Application for PHP, Part 2: DB2 pureXML or DOM? You decide
(Rizwan Tejpar) DB2 9 pureXML technology allows businesses to improve data integrity and avoid legacy data lock-in. It enables application developers to utilize the best storage medium for the task and eliminate the middle-tier application logic previously required to take advantage of Web services.
ASP.NET Dynamic Data and Validation Using LINQ To SQL OnPropertyChanging Partial Methods
(David Hayden) ASP.NET Dynamic Data is one of the new technologies showcased in the ASP.NET 3.5 Extensions CTP released a few weeks ago. It is all about building database-driven web applications quicker and with less effort. If you haven’t played with it yet, you can get up to speed by viewing the p
Apply the New Vista APIs to Sidebar Gadgets, Part 1
(Wei-Meng Lee) Developing Windows Vista Sidebar gadgets generally involves a lot of JavaScript programming. To make it possible for Sidebar gadgets to access the various systems’ information, Microsoft has provided a set of APIs that Sidebar gadget developers can use within their Sidebar gadgets, wh
