Featured Article(s) Offline Cube Files How to report against an Analysis Services cube without a connection to the server? MS Excel provides the concept of Offline Cubes to facilitate this need. Microsoft Certified IT Pro Working on the new certification? Interested in it? You’ll want to take a look at LearnKey’s interactive Video Training – it’s a great way to […]
Other News
DB2 9 for Developers by Philip Gunning
(Susan Visser) This new book needs to be on your desk if you’re a DB2 developer or database administrator facing the task of implementing DB2 9. In it, recognized DB2 guru and top consultant Philip Gunning shows how we have integrated native XML into the DB2 engine and gives developers and DBAs a de
SOA Feature: Index XML Documents with VTD-XML
(Jimmy Zhang) Traditionally DOM or SAX-based enterprise applications have to repeat CPU-intensive XML parsing when accessing the same documents multiple times. VTD-XML 2.0 introduces a simple general-purpose XML index called VTD+XML (http://vtd-xml.sourceforge.net/persistence.html) that eliminates t
Creating Code Smith Templates
(Brian Mains) CodeSmith generates code the way you want it. It uses at template that is a mix of static text and dynamic scripts to create whatever you want it to create. The dynamic scripting in CodeSmith Studio resembles both ASP scripting tags and .NET inline ASPX code. CodeSmith Studio, as depi
DML to generate DDL and DCL- Making structural and Permission changes to multiple tables
(Leo Hsu and Regina Obe) Every once in a while you are tasked with an issue such as having to create logging fields in each of your tables or having to put like constraints on each of your tables or you need to Grant an X group or X user rights to a certain set of tables.
Index Create and Rebuild Locking Improvements in 11g (Ch Ch Ch Changes)
(Richard Foote) Although the CREATE INDEX … ONLINE and ALTER INDEX … REBUILD ONLINE options have been available for a long while, they can still introduce locking issues in highly active databases.
Table changes not automatically reflected in View
(Armando Prato) I recently added a column to one of my core system tables referenced by a reporting view. When I run the view, the added column is not appearing in my result set! What can I do?
Who says that Java applications are slow?
(Grant Hutchison) An excellent new result confirming that for Java workloads DB2 and WebSphere Application Servers on AIX result in high-performance application infrastructure.
Put an XPath Expression into a Java Application
(Leonard Anghel) Inserting an XPath Expression into a Java Application can be very useful if you need to develop a Java application that evaluates a simple XPath expression. Just a copy/paste your own XPath expression and XML document, like this:
Integrating CSS techniques into ASP.NET 2.0 applications
(Tony Patton) The struggle between the standards community and Microsoft is ongoing. There has been significant progress, as evident with the recent news of the next version of Internet Explorer moving towards compliance.