By Alorie Gilbert – Oracle intends to focus on its latest software at its upcoming AppsWorld conference, but many customers are hoping the database giant will spend some time explaining its plans for supporting an aging product.
Author: SSWUG Research
Beware the XML blob
By Salvatore Salamone – If today’s XML data usage trend were made into a science-fiction movie, XML could star as the new “Blob.” But instead of aiming to destroy a large city, this XML blob aims to engulf the world’s corporate networks and smother everything in its path.
Converting RELAX NG to XSD
By James Clark – These are the slides for a talk given at the XML 2002 conference in Baltimore. They have been combined into a single HTML file. The talk was designed to assess how well RELAX NG can be made to work as a mechanism for creating W3C XML Schemas.
Native Compilation, CASE, and Dynamic Bulk Binding
Steven Feuerstein continues his exploration of new PL/SQL features in Oracle 9i with this article, cowritten with Bryn Llewellyn, and based on Bryn’s Oracle Corporation white paper originally presented at Oracle OpenWorld 2001 in San Francisco. Make the most of PL/SQL with Oracle PL/SQL Programming,
Practicing Recovery
Brian Moran talks more about his conversation with escalation engineer Bob Ward and the thoughts he shared about three common problems that many database customers bring to PSS.
SQL Server backup and restore, part 1: The basics
By Greg Robidoux – This document analyzes the various options available for your backup and recovery process with SQL Server 2000. The next part of the series will present best practices and tips.
Importing an XML file
You can import an XML file into SQL Server in several ways. Here are three approaches:
A Security Roadmap
by Morris Lewis – Find out about SQL Server security in this chapter except from SQL Server Security Distilled from Curlingstone Publishing. Find out more about this book from Amazon.com.
Using and Building Query Analyzer Templates
SQL Server 2000’s Query Analyzer (QA) is greatly enhanced over SQL Server 7.0’s QA and specifically offers an enhancement, QA templates, that can increase your productivity in developing code. This article from Gregory Larsen shows you how to use and write your own Query Analyzer templates.
Script to include users in the PRODUCT_USER_PROFILE table
By Fred Duran – This script generates a script that includes users in the table PRODUCT_USER_PROFILE table. In this way you can avoid entering them with SQL*PLUS. This tip is useful because DBAs can disable certain SQL and SQL*Plus commands on a user. It thus provides product-level security that sup