(William Pearson) In our previous article, Mastering OLAP Reporting: Percent of Total – Two Perspectives, we examined two approaches to meeting a common business requirement, the generation of percent of total values, within the integrated Microsoft Business Intelligence solution – or, more specific
Other News
Automatic data type conversion in SQL Server 7 vs. 2000
(Serdar Yegulalp) SQL Server 7 and SQL Server 2000 have many differences, but some of them are far less obvious than others. One of the most important “hidden” differences is how data types automatically are converted in certain expressions. If you transport expressions to SQL Server 2000 that were
Oracle researcher announces high-risk flaws
(Shawna McAlearney) Concerned with the dangers posed by multiple vulnerabilities left unpatched by Oracle, a security researcher has gone public with information on six flaws — three high-risk — and recommends workarounds. (R)
Sorcerer of OO – Part 4
(Lewis R Cunningham) In Part 1 of this series, we talked about how Oracle objects compare to Java and how to create Oracle objects. In Part 2, we covered object comparison and type inheritance. And in Part 3, we covered polymorphism and type evolution. Today, I’m covering the creation of Object Tabl
Asked and Answered
(Robert Catterall) I want to use stored procedures as the communication mechanism to a mainframe, but I have no experience with them. So we have a lot of questions about the best way to implement stored procedures. For example, what should the logical unit of work be? Our front-end is processing bil
Surviving Common DB2 Performance Problems
Battling performance problems and tuning DB2 subsystems, databases, and applications is a constant chore for DB2 professionals. But performance tuning tasks can be simplified with the right knowledge, preparation, and tools. This white paper discusses how to prepare for some of the most common perfo
Modern Web Reporting
(Doug Wallace and Joel Aufgang) Equity One is a publicly traded real estate investment trust that principally acquires, develops, and manages neighborhood and community shopping centers around the United States. Early in 2004, Equity One approached Agile.Net and asked us to help them create a soluti
UML Tools Offer More Control, Not Less
(Vance McCarthy) As devs debate the merits and demerits of modeling, UMLs and other abstraction tools, Integration Developer News is talking to end users about their “good, bad and ugly” experiences. Our latest interview focuses on a firm that began as skeptics and ended up surprised to find UML too
Zend Core for IBM – A Guided Tour for PHP Developers
(Grant Hutchison and Stewart Nickolas) Have you considered setting up a PHP 5 on your Linux server, but not had the time to learn how? This article will help guide you through the installation of a PHP 5 environment using the industry’s first integrated PHP environment that includes the IBM Cloudsca
An Innovative Technique for Creating Reusuable Page Templates in ASP.NET 1.x
(Steve Stchur) Code reusuability is (or at least should be) one of the major goals of any good object-oriented programmer. Reusuable code cuts development time and also minimizes the chances of introducing new bugs into an application. Fortunately, the ASP.NET framework has made code reusuability ea