By John Taschek – Oracle launched a vicious attack on Microsoft’s Exchange at the recent OpenWorld conference. But Exchange is both too easy and too slippery a target: No matter how many viruses, security alerts, maintenance issues or general complaints come in, Exchange is still the most popular en
Author: SSWUG Research
Secure import/export user
By Ed Schalk – This tip is designed to increase the security of imports/exports during batch processing of backups. It avoids the security problem of putting passwords in script files for privileged users (such as system). This tip has been tested on Oracle 7.3.3, 8.0.5 and 8.1.6.
XML for Data: Extend XSLT’s functionality with EXSLT
This column provides a quick overview of the EXSLT standardized extensions to XSLT 1.0. It identifies some of the more important functionality provided by the EXSLT extensions, and includes some guidelines as to their use.
Customizing Dimension Security
By Russ Whitney – When you want to secure selected data, you have options other than Analysis Services. Here’s a customized, flexible way to manage dimension-level security.
Retrieve Table Metadata
by Roman Rehak – Take advantage of undocumented stored procedures to output SQL Server table metadata your code can use.
Second Wind for Database Market?
By Erika Morphy – The noise level has gotten louder in the corporate database market over the last several months. Analysts have been predicting that a growth spurt is due, and the vendors are positioning themselves for such an event: IBM’s (NYSE: IBM) DB2, Oracle’s (Nasdaq: ORCL) 9i and Microsoft’s
Book Review: SQL Server Security Distilled
There are not many books out there that deal with SQL Server security. Fortunately, Curlingstone recently published this book, which is entirely dedicated to SQL Server security.
From XML-RPC to SOAP: A Migration Guide
by Rich Salz – As you might expect from the name, XML-RPC is a way of using XML to send classic Remote Procedure Calls (RPC) over the net. XML-RPC’s use of XML is very simple. It doesn’t use namespaces. It doesn’t even use attributes.
JavaCC, parse trees, and the XQuery grammar, Part 2
By Howard Katz – Part 1 of this article took an introductory look at grammars, parsers, and BNF. It then introduced JavaCC, a popular parser generator. Part 2 shows you how to modify the sample code in Part 1 so that you can use an additional tool, JJTree, to build a parse tree representation of the
ZapThink: Native XML Data Storage Will Evolve
By Clint Boulton – With the promise of another year around the corner, research firms are caught between wrapping up what has come before and looking ahead to what will be. Analysts at XML and Web services consultancy ZapThink made the prediction that the native XML database (NXD) niche no longer ex