By Paul Festa – The World Wide Web Consortium (W3C) on Tuesday issued VoiceXML 2.0 as a candidate recommendation, the penultimate stage in the consortium’s approval process.
Author: SSWUG Research
Report: Rapid programming, XML, security skills top Q4 IT pay
By THOMAS HOFFMAN – Rapid application development (RAD), security and XML skills generated the top IT pay in the fourth quarter, according to a new report from New Canaan, Conn.-based Foote Partners LLC.
Truncate tables using PL/SQL
By Kevin Shidler – This tip truncates data from tables using PL/SQL for Oracle8i. It first disables all foreign key constraints that would cause the “ORA-02266: unique/primary keys in table referenced by enabled foreign keys” error, truncates the tables, and then re-enables all the foreign keys.
Table Functions and Cursor Expressions
Steven Feuerstein introduces cursor expressions and shows how they can be used with table functions in this article, cowritten with Bryn Llewellyn. Get all of your PL/SQL questions answered with Oracle PL/SQL Programming, 3rd Edition.
SP3: To Install or Not to Install?
By Brian Moran – Microsoft released SQL Server 2000 Service Pack 3 (SP3) on January 17, raising the inevitable question, “To install or not to install?” Brian Moran is aggressive about applying service packs, find out why.
Learn About SQL Server Disaster Recovery from Greg Robidoux of Edgewood Solutions
by Brad M. McGehee – Learn the basics of SQL Server disaster recovery from a leading industry expert in this exclusive interview.
SQL Server Optimization Tips for Designing Tables
Alexander Chigrik offers 15 optimization tips for ensuring that you’ve constructed your SQL Server tables to perform in the most efficient manner possible.
Slammer Worm Raises Bigger Security Questions
By Dennis Fisher – The security researcher whose code was used as a template for the Slammer worm is now reconsidering his position on releasing sample exploit code. David Litchfield, co-founder of Next Generation Security Software Ltd., in Surrey, England, said in a post to the BugTraq maili
Apache release Web Services Invocation Framework 2.0
The Apache Web Services Invocation Framework team announced the first open release of their Apache WSIF API.
Tip: SAX and document order
By Howard Katz – This tip focuses on document order, SAX, and something I call document order indices, or DOIs for short. I’ll start with a short discussion of document order, explaining what it is, where it’s useful in an XML context, and why it’s important. I’ll then present some simple SAX code t