By Michael Otey – Microsoft offers a lot of functionality as free downloads, including the latest SQL Server 2000 XML functionality. If you ignore these updates, you’re leaving money on the table.
Other News
Trimming a string in versions before 8i
By Keshav Chennakeshav – In many data manipulation and querying scenarios, you may need to trim a string. To do this in Oracle, LTRIM and RTRIM are available. Here is a utility function that combines the two. Note: this function is a standard feature of Oracle 8i and higher. So it will be of use for
Display Session Information
by Jayant Kulkarni – Displaying session information is a regular task for a DBA. DBAs have been using information from v$session and v$process to find out relevant information about a process in order to kill a session, such as finding the UNIX id associated with the process, identifying more detail
Validate XML Against Multiple Schemas
by Dan Wahlin – This sample application demonstrates how you can validate three different sections of an XML instance document against three different XML schemas, all within different target namespaces. The application leverages the XmlSchemaCollection class along with the XmlValidatingReader to pe
XML for Web Developers – in 500 words or less!
Recently, Andrew Watt (author of the book Sams Teach Yourself XML in 10 Minutes) started an interesting discussion thread on XML-DEV mailing list. The topic was to describe XML in 500 words or less to an “ordinary” Web developer (who has no formal Computer Science training).
Generating XML and HTML using XQuery
Often perceived mainly as a query language, XQuery can actually be used to generate XML and HTML. Per Bothner provides a worked example, and compares XQuery with XSLT.
Case-Sensitive Comparisons
How can I program a case-sensitive comparison of a user-typed password on a case-insensitive SQL Server 7.0 instance?
SQL Server Hardware Resource Planning
by Robert H Chin – Planning on getting new SQL Server hardware, this article might provide some help.
A Set-Based Way To Find Specific Rows
I have a table that includes a single-column primary key called IdValue. Given a particular value for IdValue, I want to find the table rows that are immediately before and after my target value (assuming the result set is sorted by IdValue). How can I avoid using cursors and get the result I want w
Oracle plan exposes Java rift
By Martin LaMonica – In a move that has exposed a growing schism in the Java community, an Oracle proposal to bridge Java development tools moved ahead with approval from competing Java companies.