By Greg Johnson – So you’ve just migrated your Oracle8i databases in which all your various sized segments reside (which incidentally were stored in the single “USERS” Tablespace) and now you want to place them in appropriately sized Locally-Managed Tablespaces (LMT’s). Here is a brief guide to help
Other News
Microsoft adds notification services to database
Microsoft has announced the release of SQL Server Notification Services, a platform for developing and deploying database applications that enable users to subscribe to informational updates.
Telco Deploys Oracle Database Clusters
Vonage, a provider of IP-based telephone service, said Monday it has deployed new database clusters from Oracle Corp. to better support its growing customer base.Vonage implemented Oracle 9i Real Application Clusters in six weeks, beefing up the ability of its database applications to suppor
Separating Elements
By Itzik Ben-Gan – User-defined functions can help when you have to work with denormalized data, but don’t worry if you don’t have SQL Server 2000. You can also create a SQL Server 7.0 solution to this headache.
How XML Is Conquering the Internet
By Jay Lyman – The main functions of XML are inter-application communication, data integration and external application communication with outside partners.
New XPath, XSLT and XQuery drafts
The XSLT, XPath and XQuery working groups have put out a great deal of new work, including updated XSLT 2.0, XPath 2.0, XPath and XQuery Functions and Operators, XQuery 1.0, XPath and XQuery Data Model, XPath and XQuery Formal Semantics, XQuery Use Cases and more.
Validation by Instance
by Michael Fitzgerald – In this article, I will explore how you can translate an XML document into a Document Type Definition (DTD), a RELAX NG schema, and then into an W3C XML Schema (WXS) schema, in that order. I’ll do this with the aid of several open source tools, and I’ll also cover a way to va
Oracle to publish pricing, licensing policies on internet
Oracle Corp as of next week will publish its global pricing and licensing policies on the internet in a move the corporate software maker claims is the first of its kind within the industry.
Performing Oracle and SQL Server database recovery
By Mark Teter – Database recovery is something that should not be tried for the first time in a disaster situation. In fact, the best recovery plan is maintaining your environment so that you never have to perform recovery. The key to this strategy is using a comprehensive availability approach. By
Retrieving the row for the Nth largest parametric column in a parametric table
By Eli Leiba – This piece of code returns the row corresponding to the Nth largest value for a given column name in a given table.