By Thomas Davidson – Take advantage of query recompilation to optimize your SQL Server performance.
Community
Retrieve Rows Set by Set from the Database—Without Duplicates
Learn how to retrieve rows set by set from an Oracle database without getting previously obtained rows in subsequent sets. Boris Milrud demonstrates how to use packages as holders for session-persistent data.
DSN less Database Connections
DSN less connections don’t require creation of system level DSNs for connecting to databases and provide an alternative to DSNs. We will now see how to connect to a database via ASP using Connection String in place of DSN name.
Ellison: No profit warning here
By Wylie Wong – Oracle Chief Executive Larry Ellison on Wednesday said the database giant will meet Wall Street estimates for its fourth-quarter earnings, ending speculation that the company might have to announce a profit warning this week.
Introduction to Relational Databases – Part 1: Theoretical Foundation
By Tore Bostrup – This is the first of a two-part article that will provide an introduction to relational databases and the SQL language. This first part describes some of the key elements of the technology with an emphasis on database normalization. The second part will describe a less theoretical
New OASIS Standards Approved
Three OASIS Committee Specifications, Directory Services Markup Language (DSML) v2, ebXML Registry Service (RS) v2, and ebXML Registry Information Model (RIM) v2, have passed final approval by the OASIS membership at-large to gain official status as OASIS Standards. To reach this milestone, each of
Analyzing XML Schemas with the Schema Infoset Model
By Shane Curcuru – As the use of schemas grows, the need for tools to manipulate schemas grows. The new Schema Infoset Model provides a complete modeling of schemas themselves, including the concrete representations as well as the abstract relationships within a schema or a set of schemas. This arti
An Overview of MSXML 4.0
by Steven Livingstone – In this article we will look at the latest XML parser from Microsoft, MSXML 4.0. Microsoft has taken a lot of criticism in the past over its adoption of non-standard schema and XSL drafts, which happened most often in early parser releases and even version 3.0 to a lesser ext
Oracle develops 9i software for Linux
By Mike Ricciuti – Oracle on Wednesday boosted its support for the Linux operating system with a new version of its database software. The software maker said that it has developed a version of its 9i database software that can run across multiple Linux servers in a configuration called clust
Analysts antsy about Oracle
By Larry Dignan – Oracle’s fiscal year ended with a thud, raising the specter of “significant employee reductions,” according to Wall Street analysts.Oracle had to resort to heavy discounting in the final weeks of the quarter, and analysts are betting that the company will take a revenue hit