(Mark Brunelli) Oracle unveiled its new Information Lifecycle Management Assistant, a free tool for the growing number of Oracle Database users who want to do a better job of cost-effectively complying with data-retention regulations such as the Sarbanes-Oxley Act. (R)
Author: SSWUG Research
Breaking the DB2 Platform Barrier
(Jim Wankowski) Are you supporting DB2 on multiple platforms? The author covers the key architectural and administrative differences between DB2 for Linux/Unix/Windows and DB2 for z/OS in this Quest white paper. (R)
Move SQL Tuning Sets between Oracle instances
(Bob Watkins) SQL Tuning Sets (STS) are a part of Oracle 10g’s SQL Tuning Advisor feature. Each tuning set contains one or more SQL statements, plus the context information needed to interpret them correctly. A tuning set is used as input to the SQL Tuning Advisor, which examines the statements and
The Seven Deadly Sins of AJAX application development
(Scott Robinson) The AJAX bandwagon is a good place to be. It takes you to faster, more efficient, more dynamic apps. But it also has pitfalls all its own. (R)
XML for PHP developers, Part 1: The 15 minute PHP with XML starter
(Cliff Morgan) This first article of a three-part series introduces PHP5’s XML implementation and help those relatively new to using XML with PHP to read, parse, and manipulate, and write a short and uncomplicated XML file using the DOM and SimpleXML in a PHP environment.
OAXAL: Open Architecture for XML Authoring and Localization
(Andrzej Zydron) XML is now acknowledged as the best format for authoring technical documentation. Its wide support, extensible nature, separation of form and content, and ability to publish in a wide variety of output formats such as PDF, HTML, and RTF make it a natural choice. In addition, the cos
More DB2 LUW SQL Scripts
You can use this SQL to generate the SQL statements for truncating the tables in a schema.
Subqueries: the new strategy for ‘NULL IN (SELECT …)’
(Sergey Petrunia) I hope this is my last post about this topic. It seems we’ve resolved all of the issues and I’ll now describe the user-visible consequences.
SQL Server Error Handling Workbench
(Grant Fritchey) Error handling in SQL Server breaks down into two very distinct situations: you’re handling errors because you’re in SQL Server 2005 or you’re not handling errors because you’re in SQL Server 2000. What’s worse, not all errors in SQL Server, either version, can be handled. I’ll s
Real-world Apache Derby, Part 4: Wrapping up: Tracking SOX compliance
(Dave Warner) So far, this series has covered the basics of storing and retrieving data in Apache Derby using SQL. This tutorial shows you how to use this knowledge in a straightforward way. In the previous tutorial, you developed a framework that allows you to store and manage Sarbanes-Oxley Act (S