(Oleg Tkachenko) I mean pre-XProc XSLT pipeline – just when you need to transform an XML document by a sequence of XSLT stylesheets – output from the first transformation goes as input to the second one and so on. This is useful technique helping dramatically simplify your complex multi-stage XSLT s
Author: SSWUG Research
Oracle Debuts Application Integration Architecture
(Erika Morphy) Oracle’s new integration architecture is not a substitute or even an interim step leading to Fusion’s introduction. Rather, it is a process-centric tool, allowing customers to extend the platform to their legacy applications and otherwise manage processes that rely on several differen
Making XML/XSLT driven site using PHP
XML and XSLT technologies provides standard ways of separation of presentation and data. This article contains an example of simple php “xslt engine” for XML driven web-sites which implements caching techniques and Apache-based XML file processing.
How can you tell if an index is being used?
(Paul Randal) Whenever I’m discussing index maintenance, and specifically fragmentation, I always make a point of saying ‘Make sure the index is being used before doing anything about fragmentation’.
Changing Dimensions in Parent Child Hierarchies
(Richard Tkachuk) A changing dimension is a common issue in many OLAP applications. The problem is pretty broad: – Members moving around. For example, after a company reorganization a sales region can be moved from one area to another. – Characteristics of a dimension member change, For example,
Best practices for server ADOMD.NET stored procedures
(Mosha Pasumansky) In this article we will discuss some of the best practices around writing efficient Analysis Services stored procedures using server ADOMD.NET. These days there is plenty of information about writing efficient MDX – in books, whitepapers, blogs, forums etc. Just recently Microsoft
DATE comparisons: the scenic route
(William Robertson) Need to calculate the number of minutes between two dates? Yes, the dull way is to subtract one from the other and multiply by 1440. But why do that, when you can simply convert each date into Julian format by converting it into a string and then back to a date, and converting th
DB2 9 ‘Viper’ Named Best Database Management Solution for 2007 by the Software and Information Industry Association
IBM announced that DB2 9 “Viper” data server was named winner of the 2007 Best Database Management Solution at the Software & Information Industry Association’s (SIIA) 22nd Annual CODiE Awards. DB2 9 was one of more than 1,197 nominations this year — the most in the history of the CODiEs.
COUNT(*) vs COUNT(col)
(Peter Zaitsev) Looking at how people are using COUNT(*) and COUNT(col) it looks like most of them think they are synonyms and just using what they happen to like, while there is substantial difference in performance and even query result.
Convert A Java Web Application To ASP.NET Using JLCA
(Brian Jimerson) The typical software development cycle follows a straightforward model: gather requirements, design the application, write the code, test the software, and deploy it. Once in a while, though, a new development project is incepted simply based on the platform to which the customer wa