By Rick Whiting – Although optimistic that business will improve through the rest of the fiscal year, Oracle execs were cautious in setting expectations.
Author: SSWUG Research
Oracle9i Database on HP Superdome Delivers Best Oracle Performance Result
Oracle recently announced a record-breaking Oracle9i Database Release 2 TPC-C benchmark result for Online Transaction Processing (OLTP), running on the HP Superdome Server. This new result significantly outperforms the competition.
Brother, Can You Spare a DIME?
by Rich Salz – Last month we talked about the reasons for associating attachments with SOAP messages, and we looked at the initial SOAP Messages with Attachments (SwA) note. This month we look at Direct Internet Message Encapsulation (DIME), a binary message format; and we’ll also look briefly at th
IBM’s Web Services Security Answer Lies with Tivoli
By Jim Wagner – IBM will release new software in its Web services suite of applications early next year to address the problem of data security, officials announced Wednesday.<br><br>The Tivoli Access Manager is scheduled for release in the first quarter of 2003, in what officials said would "provid
Validating XML Against Multiple Schemas using the XmlValidatingReader
The XmlValidatingReader provides an API for validating XML documents against XSD schemas. In many cases a single XML instance document may be validated against a single XSD schema.
Weekly Review: Oracle’s Modest Proposal
In this week’s commentary: For technology vendors market leadership means marketshare, so it’s no surprise to see Oracle claim standards leadership in Web services orchestration.
Print Object Dependencies Recursively
by Ahbaid Gaffoor – Using the procedure below, you can examine the database to provide a listing of objects dependent on the supplied object. This is recursive, so you get a tree of dependencies as your output. Here is the procedure. Note that you should create it as SYS with a publicly executable s
Additional Criteria in the JOIN Clause
Have you ever seen a SELECT statement joining two tables that had something like and Field = Value in the JOIN clause? Did you, like me, ask yourself, “Why did they put that in the JOIN instead of in the WHERE clause?” What difference does it make? Well recently I found out that I needed this functi
ASPReport Enterprise General Info
ASPReport is a data driven, web reporting solution for Microsoft SQL Server. Imagine the ability to leverage off an existing database and begin offering your users literally hundreds of reports in a few minutes rather than months.
Implementing full text search in T-SQL stored procedures
By Eli Leiba – Enabling full text search in T-SQL is not as popular as doing it with the Enterprise Manager, but is still worthwhile. Here are the T-SQL steps to take in order to implement FTS in T-SQL.