(Mark A. Williams) Suppose you’ve just received an e-mail detailing several IT initiatives, two of which will affect your future application development techniques. First, all applications should be designed to minimize network utilization. And second, applications that use Oracle databases must use
Other News
Returning Result Sets from SQL Server and Oracle
You may need the Result Set from a Query in your .NET or Java Code by calling a Stored Procedure. Here are some samples for SQL Server and Oracle 10g.
DB2 Intelligent Miner Tutorials
(Peter Bendel, Toni Bollinger, M. Eugenia Garcia and Stefan Warwas) These tutorials are designed to guide application designers and application developers through the process of gaining insight from data mining analysis to applying it in end user applications. Practical examples show how business
Dynamic XML with PHP
(Ben Robinson) In this article I will show how to generate dynamic XML documents with Object-Oriented PHP. Before I get started, let’s get right to the heart of this functionality. Although the code may look fancy, being packaged up inside objects and inheritance, the key elements of this functional
Quick Guide To Creating RSS Feeds
(Steven Holzner) This chapter is all about creating your own RSS feeds by using RSS creation applications. With RSS creators like NewzAlert Composer, for example, all you have to do is enter the data for your new feed and you’re set. When you’re finished creating your feed, you can also publish it a
Drupal + Oracle: Inside the OraDrup Project
(Gavriel Pedros) Imagine the following scenario: While doing research for an implementation-related project, you read a blog or article about certain open source software that is “database independent” and that should work with “any” ANSI SQL compliant database, such as Oracle Database.
IBM DB2 Content Manager Enterprise Edition setup and usage
(Burt Vialpando) Discover common tips to assist with the installation and configuration of DB2 Content Manager with Oracle 9i Database Release 2 Enterprise Edition.
Oracle RAC Administration – Part 13: Cache Coherency
(Tarry Singh) In our last article, we took a deeper and closer look at the OIFCFG command line utility. As a DBA, the performance of our RAC is crucial. Just like any other application, we need to make sure that our Oracle Database, whether a single node or a multi-node RAC, runs efficiently.
SQL to View Top Dynamic SQL Statements
(Chris Eaton) Continuing in this series of postings on new administrative views in DB2 9, I’m going to show you a view that lists the top queries in the dynamic SQL cache. The view is called SYSIBMADM.TOP_DYNAMIC_SQL. This view shows you the most frequently executed dynamic SQL statements, how many
Persisting Page State in ASP.NET 2.0
(Scott Mitchell) There are different types of state in an ASP.NET web application: page state, session state, and application state. Page state is state that is specific to a particular user’s visit to a particular page and is commonly used to remember any programmatically changed state of the page