(Ziran Sun) Back in the days of classic ASP, if you were building a database-driven web site, your choice was either to invest a lot of money to get a copy of Microsoft SQL Server (or some other enterprise-ready database) or invest a lot of time finding a way to deal with the performance and scalabi
Other News
Cross language support in SQL Server 2000
This article discusses cross language support for Microsoft SQL Server 2000.
New HTTP Endpoints Create SQL Server 2005 Web Services
(Peter DeBetta) SQL Server 2000 offers some capabilities for returning XML output via HTTP using SQLXML—and, of course, SQLXML supports Web services creation. Although not rocket science, setting up, configuring, and using Web services in SQL Server 2000 does require a little effort (see the SQLXML
Java Database Interaction Mechanism Using Oracle Reference Cursors
(Ravi Kumar Buragapu) This document describes on a unique mechanism and process that enable to make use of Oracle references cursors in Java Database programming in developing highly scalable business applications with greater performance. (pdf)
FIX: A pooled connection is not disposed by Microsoft .NET Managed Provider for Oracle when an exception occurs
OracleConnection objects that experience errors because sessions or connections are dropped are returned to the connection pool when the Connection.Close method is called. Then, the OracleConnection objects are reused. This may cause unexpected behavior.
How To Upgrade Or Migrate Oracle With (Almost) No Downtime
By attending this webcast, delegates will gain an understanding of how to upgrade their Oracle databases with minimal downtime, using Quest Software’s solutions. Attend this webcast and discover: –How to achieve minimal downtime even when upgrading hardware or moving to a new operating system
XSLT Object Relational Mapping
(Mark Porter) This article describes a technique for using XSLT to map between relational and object representations of data.
The Power and Magic of LPG
(Mike Cain and Rob Bestgen) With the availability of V5R3 i5/OS and DB2 UDB for iSeries, the SQL Query Engine now supports a powerful strategy for minimizing query input/output (I/O) and maximizing query performance. This new strategy appears as magic, given the Query Optimizer’s ability to rewrite
IBM Exec Defends Proprietary Middleware on Linux
(Michael Vizard) One of the paradoxes of the industry is that while IBM is an ardent supporter of Linux as an open-source operating system, it has a more proprietary approach to the middleware given its history with Websphere and other products. But IBM argues that as open source continues to evolve
Managing XML Data
(Thom Robbins) Last week I had lunch with the application manager of a local customer that just completed their enterprise rollout of Office 2003. We had decided to meet and discuss possible ways his team could begin to utilize this deployment. As we sat down he explained that he had been talking to