(Boris Milrud) The "ORA-01555 snapshot too old" error, which causes user transactions to fail, is a nightmare for Oracle DBAs and developers. It usually occurs after queries or batch processes have been running for a long time, which means that it can cause you to lose many hours of processing.
Author: SSWUG Research
Understanding W3C Schema Complex Types
by Donald Smith – Are W3C XML Schema complex types so difficult to understand that you shouldn't even bother trying? Kohsuke Kawaguchi thinks so; or so he claimed in his recent XML.com article, in which he offered assurances that you can write complex types without understanding them. My
Converting Fixed-Width Text Records to XML
By Kurt Cagle – We're not so far removed from the databases of old. Most databases still have a specified length applied to field entries, although the exact relationship between that length and the way the database stores that information is considerably more complex than it was when databases
J2EE and .Net: Two Roads Diverge in XML
By Paul Rubens – There's little argument that XML Web services are the future of computing, which explains why Microsoft is promoting .Net — its XML Web services platform — as heavily as it is. However, .Net is not the only player to offer a platform for Web services. Sun Microsystems wil
SQL oversights, a recipe for disaster
By Chris Prosise and Saumil Udayan Shah – For many of us, Web applications have become as much a part of our daily life as the meals we eat. (Some of us even eat while we work on Web apps.) Unfortunately, just as these applications are something else that we have to cook up, they're just as susc
Use Query Name As SQL Statement Variable
Tip by Stan Zylowski – Suppose you have a shopping cart with several categories of products, and your ASP pages use SQL statements that access database queries for the different categories. Instead of creating an ASP page for each category (for example, shirts.asp, caps.asp, and so on), you can have
Top 11 Backup Tips
By Michael D. Reilly – SQL Server's powerful backup and restore capability offers reliable protection for your data. If you have an effective backup-and-restore strategy, you can sleep well at night knowing that if a problem occurs, you can recover from it with minimal downtime and minimal disru
Common XML design mistakes and how to avoid them
By Kevin Williams – This column tells how to avoid some common mistakes that even smart architects make when designing an XML solution. XML architect and author Kevin Williams offers four tips for designing flexible and high performance systems.
Modeling XML Vocabularies with UML: Part I
by Dave Carlson – The arrival of the W3C's XML Schema specification has evoked a variety of responses from software developers, system integrators, XML document analysts, authors, and designers of B2B vocabularies. Some like the richer structure and semantics that can be expressed with these new
Programming Microsoft® Access Version 2002
Book by Rick Dobson – Learn how to develop multiuser databases—and extend your solutions to SQL Server™ and the Web—with code and instruction from an Access 2002 expert. Whether you’re extending an existing database or developing a sophisticated custom solution, this detailed developer’s guid