(Parthasarathy Mandayam) You already know that stored procedures offer enormous benefits over direct SELECT statements. But one of the things you tend to have to sacrifice when you replace a simple SELECT with a stored procedure is direct control over the resultset.
Other News
Output Caching with PHP
(Alejandro Gervasio) Dynamic Web pages take longer to load than static ones, which forces visitors to your site to wait — and we all know they won’t wait for very long. Output caching is a powerful technique you can use to shorten that wait and keep them from leaving.
SQL Injection Attacks by Example – Introduction
(Stephen J. Friedl) A customer asked that we check out his intranet site, which was used by the company’s employees and customers. This was part of a larger security review, and though we’d not actually used SQL injection to penetrate a network before, we were pretty familiar with the general concep
Utilizing XML documents in BizTalk 2004 orchestrations
(Scott Robinson) BizTalk Server 2004 makes its very strong bid for mid-range ERP platform legitimacy largely on the basis of ingenious leveraging of XML technology. The implementation of XML transport as the BTS2K4 workhorse is elegant and efficient; its utilization in pipelines is robust and the sc
Data Mining Reloaded
(Alexei Bocharov and Jesper Lind) The two main functions of data mining are classification and prediction (or forecasting). Data mining helps you make sense of those countless gigabytes of raw data stored in databases by finding important patterns and rules present in the data or derived from it. An
MySQL 3 to 4 Migration in the Real World
(Blane Warrene) There are all manner of whitepapers and architecture documents on the features and benefits of migrating from MySQL 3 to MySQL 4. Sometimes, the best case is to see it done on the front lines of a real Web business.
Software Infrastructure Bottlenecks in J2EE
(Deepak Goel) Scalability is one of the most important non-functional requirements of a system. But there could be several bottlenecks within a system, which might prevent it from being scalable. In this article, we try to analyze the case in which the software infrastructure becomes a bottleneck, l
DB2 Content Manager for z/OS Installation Verification and Troubleshooting
In this document, we discuss how to verify that your IBM DB2 Content Manager for z/OS installation is successful and how to troubleshoot a common installation problem.
Analysts: Project Fusion Is the Death Knell for PeopleSoft Apps
(Lisa Vaas) During Oracle Corp.’s heartfelt and lengthy launch of the combined Oracle-PeopleSoft Inc. company on Tuesday, CEO Larry Ellison posed the upcoming Project Fusion as the product suite that will melt all the goodness from all the combined suites into one Internet standards-based Java platf
Experience with WindwardReports XML Serializing Engine
(pmareschal) N.S.I. (www.nsi-sa.be) is a value-added reseller that builds solution for customer. It always tries to find the shortest path to their customer’s problems. WindwardReports software libraries helped them solving this particular challenge faster.