(Alan Zeichick) It’s been two years since the introduction of .NET, and Microsoft Corp.’s new platform is well on the way toward dominating the Windows environment. Even so, there’s a tough road ahead of it—especially since Java usage also is expanding.
Other News
Trigger basics in DB2 and OS/390
(Craig Mullins) TableA is a high transaction table. TableB is essentially a copy of TableA with indexes for reporting. I want to create an insert/update trigger on TableA to replicate the change to TableB. I’m worried about performance. Mainly, will TableA be locked up until the commit on TableB
How To Access an Oracle Database Using RDO
With Visual Basic 5.0 and higher Enterprise edition, you have the ability to connect to an Oracle database through a DSN-Less connection, execute a stored procedure using parameters, and get return values from that stored procedure. The example in this article illustrates all of this functionality.
An Overview in Combining XML Data With XSL Within ASP
(Derrald Farnsworth-Livingston) XML (eXtensible Markup Language) and XSL (Extensible Stylesheet Language) have been created from the necessity of having a structured, defined method of exchanging data. By utilizing XML information that can be pulled from other sources is changing the way we exchange
Oracle Response Files – Part 2
(Steve Callan) Part One of Oracle Response Files covered the basics of using a response file and provided an example of how to install Developer Suite on a Windows PC. In Part Two, we will go into more detail about the components of response files. This part will also discuss some related topics as
Tuning Up ADO.NET Connection Pooling in ASP.NET Applications
(Dmitri Khanine) Opening a database connection is a resource intensive and time consuming operation. Connection pooling increases the performance of Web applications by reusing active database connections instead of creating a new connection with every request. Connection pool manager maintains
Simplifying EJB Development with EJB 3.0
(Debu Panda) Enterprise JavaBeans (EJB) was introduced for building distributed components. When it arrived it came with a promise to solve all issues and complexities of CORBA. EJB being the heart of J2EE went through several major revisions and got fattened with many features. Early on, most of th
Working with Image Objects in InfoPath 2003 and SQL Server 2000
(Anup Kafle) You can use features in Microsoft Office InfoPath 2003 Service Pack (SP) 1 to work more efficiently with image objects and other data. Learn how to use BLOB data types to work with data stored in a Microsoft SQL Server 2000 database from an InfoPath form. InfoPath 2003 provides a ro
Introduction to MSSQL Server 2000 Analysis Services: Partitioning a Cube in Analysis Services – An Introduction
(William Pearson) We have touched upon partitions over the life of the Introduction to MSSQL Server 2000 Analysis Services series, as well as within other series at Database Journal. We recently discussed partitioning more specifically within our article Basic Storage Design, within which we introdu
SQL Server 2000 Report Pack for Financial Reporting
The SQL Server 2000 Report Pack for Financial Reporting is a set of six Microsoft SQL Server 2000 Reporting Services reports that work with a sample financial database called FinSampleDB. With the Report Pack, you have the choice of using the sample reports either as-is or as templates for design