By Don MacVittie – Simple Object Access Protocol takes Web services to the next level by letting applications communicate. Network Computing comes clean on the technology.
Author: SSWUG Research
Scripts for hot backup and restore
Robert Hanrahan) This procedure generates two scripts that do a hot backup and restore of the database. It is a full backup of the database datafiles, redolog, init, and control files. You can run this script at database open and it will generate 2 files: (R)
What’s in a Condition?
Oracle9i includes support for the SQL92 join syntax. Find out why it’s important to have the choice to make a condition a join condition in this article by Jonathan Gennick, author of Oracle SQL*Plus Pocket Reference, 2nd Edition.
How to troubleshoot replication problems
In this article, Alexander Chigrik explains some problems that you can have whenyou set up replication. He also tells you how you can resolve these problems.
SQL LiteSpeed 2.6 – SQL Server Backup Just Got Faster
Software Spotlight by Brad M. McGehee – Wouldn’t it be great if there was some way to not only reduce the size of SQL Server backups, but to also speed them up. As a matter of fact, I am not the only person to have this problem. The good people at DBAssociates, in Melbourne, Australia, also had this
Avoiding the Autoclose and Autoshrink Options
In the Microsoft SQL Server 2000 Resource Kit, I read about a procedure that checks all databases for options that you should avoid using. I understand why I should avoid using options such as offline, DBO-use only, statistics off, truncate log on checkpoint, and so on. However, the inclusion of two
What is XQuery?
by Per Bothner – The W3C is finalizing the XQuery specification, aiming for a final release in late 2002. XQuery is a powerful and convenient language designed for processing XML data. That means not only files in XML format, but also other data including databases whose structure — nested, named t
The Web’s future: XHTML 2.0
By Nicholas Chase – Over the years, HTML has only become bigger, never smaller, because new versions had to maintain backward compatibility. That’s about to change. On 5 August 2002, the first working draft of XHTML 2.0 was released and the big news is that backward compatibility has been dropped; t
Printing from XML: An Introduction to XSL-FO
by Dave Pawson – One of the issues many users face when introduced to the production of print from XML is that of page layout. Without having the page layout right, its unlikely that much progress will be made. By way of introducing the W3C XSL Formatting Objects recommendation, I want to present a
Tip: Using generators
Generators are a very powerful new language feature of Python 2.2. In this tip, Uche Ogbuji presents a set of techniques for using generators for fast and lucid XML processing patterns in Python.