(Thiru Thangarathinam) Multiple Active Result Sets (MARS) is a new feature released with ADO.NET 2.0 that allows you to execute multiple queries or stored procedures on a single connection. The result is multiple forward-only, read-only result sets. In previous versions of ADO.NET, you could exe
Other News
Oracle 10g Availability Enhancements, Part 1: Backup and Recovery Improvements
(Jim Czuprynski) Oracle 10g offers significant enhancements that help insure the high availability of any Oracle database, especially in the arena of disaster recovery. This article – the first in a series – concentrates on several new features available for backup, restoration, and recovery of
Tuning IBM xSeries Servers for Performance
(David Watts, Gregg McKnight, Marcelo Baptista, Martha Centeno, Eduardo Ciliendo, Jean-Jacques Clar, Phillip Dundas, Brian Jeffery, Frank Pahor, Raymond Phillips and Luciano Magalhães Tomé) This IBM Redbook describes what you can do to improve and maximize the performance of your business server
XML 2004: From the Exhibition Floor
(Simon St. Laurent) XML’s ubiquity and the slowing of the standards cycle meant that there were a lot fewer vendors promising something completely new and different at the XML 2004 exposition, but a lot of projects and products have reached maturity. It was delightful to see more demos working as ex
Business Intelligence with Microsoft SQL Server Reporting Services – Part 3
(Adnan Masood) Reporting Services exposes web methods via XML web services to facilitate cross platform reports management and delivery. It’s a simple SOAP based API makes it very easy to add full functionality of reporting services in your application. It provides a set of rendering and viewing
Develop Database Web pages on Linux with DB2 and WebSphere Studio Application Developer
(Kevin Czap) This article covers Rapid Application Development of Database Web pages on Linux using IBM DB2 Universal Database (UDB) Version 8.2 along with WebSphere Studio Application Developer (Application Developer). We’ll create a database, tables, and columns and use SQL to populate and acc
Inner Joins (Equijoins)
(Mike Chapple) Inner joins (also known as equijoins) are used to contain information from a combination of two or more tables. The join condition determines which records are paired together and is specified in the WHERE clause. For example, let’s create a list of driver/vehicle match-ups where bo
Database Design (Sample Chapter)
(Michael Kofler) This chapter discusses the fundamentals of relational databases, collects the varieties of data and tables available under MySQL, offers concrete examples of MySQL database structures, shows how indexes enable more efficient table access, and, finally, offers enlightenment on concr
Product Review: Thomson Course Technology’s Oracle9i Database Performance Tuning
(Steve Callan) When it comes to IT training, how do you want to spend your hard-earned dollars? There are plenty of options, approaches, and vendors to choose from, so it helps if you have a specific or somewhat focused goal in mind before spending your money. Let’s look at some of the choices as th
SELECT DISTINCT: A SQL Case Study
(Tom Copeland) There is an understanding in the database world that using a "SELECT DISTINCT" SQL query is not a good idea, because it is essentially getting duplicate rows out of the database and then discarding them. Usually it is better to rearrange the "WHERE" clause in the query to only get the