(Roger Sanders) In the first column of this series, I described how information stored in a database’s transaction log files is used to return a database to a consistent and usable state after a system failure or program abend occurs. In the most recent column, I explained how backup images used wit
Other News
CTE and Hierarchical XML Result
(Davide Mauri) Finally i’ve managed to have a hierarchical xml result from a CTE Query. I’ve discovered that SQL Server 2005 cannot do this natively, so at the end i’ve create a .NET Stored Procedure that takes the XML as it cames out from the CTE and produces a hierarchical one.
Rockwell Collins taps XML security appliance for services foundation
(Colleen Frye) When you’re a defense contractor like Rockwell Collins, security is an overarching theme. So when this global manufacturer of aviation electronics for commercial and government customers set out to speed its business-to-business communications by utilizing XML Web services, it chose a
Jumpstart Functionality: Attach an XML Schema in Word 2003
(Laurie Rowell) The first time I heard of XML, someone explained it to me as a language for the web that allowed developers to customize their terms, almost creating a new language as they went. “This is never going to work,” I told a colleague, displaying that knowledge of the technological marketp
TechTip: PREPARE to DECLARE
(Mike Faust) With the broad use of embedded SQL statements, sometimes it’s easy to overlook things that can substantially improve their performance. A great example of this is the use of prepared SQL statements in your embedded SQL code. Prepared statements improve performance by doing a portion
Lock avoidance in DB2 UDB V8
(Werner Schuetz) During a table or index scan, DB2 Universal Database (DB2 UDB) normally locks each row that is scanned before determining whether the row qualifies for the query. Gain an understanding of how row locking works in DB2 UDB, and learn how you may be able to improve concurrency of scans
What Is Open Source
(Dan Woods) Open source usually refers to software that is released with source code under a license that ensures that derivative works will also be available as source code, protects certain rights of the original authors, and prohibits restrictions on how the software can be used or who can use it
Tracking the progress of long-running queries
(Manish Upadhyay) Sometimes there are some batch jobs or long-running queries in the database, which may take a while to complete. This query will show the status of the query (how much of it is completed). In other words, this may be viewed as a “progress bar” for the query. It has been tested on 9
Oracle Locks Up ‘Federated’ App Server
(Clint Boulton) Refusing to rest after announcing a $5.8 billion merger deal with rival Siebel Systems, Oracle debuted its Security Developer Tools, software that can be used to grant or deny users access to information on computers.
Scheduling a SQL update statement
(Kent Milligan) I need to run a SQL update statement after hours, and it would be nice to schedule it. I saw your posting about the RUNSQLSTM command, but I’ve had no success with it. I tried saving my command in the STRSQL run, which it saved to a QSQLSESS file, but I still could not use that in th