(Don Kiely) I recently spoke at several software developer user groups around the country and made this assertion, representing it as one of the fundamental truths of computing today: The fact that most people run with administrative rights on their local machine is the root cause of many or most of
Other News
Split mirror using suspended I/O in DB2 Universal Database
(Shahed Quazi) Looking for a high availability solution for IBM DB2 Universal Database (DB2 UDB)? This article provides a visual explanation of split mirror using suspended I/O for DB2 UDB for Linux, UNIX, and Windows databases and explains the details of various implementation scenarios. Learn how
FIX: The results of the query may be returned much slower than you expect when you run a query that includes a GROUP BY statement in SQL Server 2000
When you run a query against a view in Microsoft SQL Server 2000, the results of the query may be returned much slower than you expect. You may experience this problem when the following conditions are true: • The query that you run includes a GROUP BY statement. • The database on which you run
Requesting URL References to BLOB Data by Using sql:encode
In an annotated XSD schema, when an attribute (or element) is mapped to a BLOB column in Microsoft SQL Server, the data is returned in Base 64-encoded format within XML.
Oracle Exception Handling
Before executing an INSERT, UPDATE, or DELETE statement, Oracle marks an implicit savepoint (unavailable to you). If the statement fails, Oracle rolls back to the savepoint. Normally, just the failed SQL statement is rolled back, not the whole transaction. However, if the statement raises an unhandl
Import a text file to a DB2 table
(Kent Milligan) I need to “import” a text file located in the user computer, to a DB2 table in the database, what’s the best way to do this? (R)
Accessing PostgreSQL with Python and Psycopg2
(Joshua D. Drake) As an open source database, PostgreSQL has one of the largest libraries of Application Programmable Interfaces (APIs) available, letting you access it easily from various languages. One such language is Python, which happens to be one of my favorite languages; I use it for almost a
Oracle10g Release2 feature – Transparent Data Encryption
(Amarjyoti Dewri) Oracle10g Release2 has introduced a new feature called Transparent Data Encryption (TDE). TDE is beneficial for simple and easy encryption of sensitive data in table columns. Simple and easy because users or applications need not manage the encryption and decryption of data any mor
XSLT expression variables and data types
(Ed Tittel) This is the fourth segment of what was planned as an eight-part series on XML eXtensible Stylesheets Language Transformations, aka XSLT. The subject of this brief tutorial was supposed to be XSLT expressions, which employ variables and data types to seek out specific XSLT document elemen
Model-driven XML forms generation, Part 2: Generate forms targeting Web services
(Jan J. Kratky, Kevin E. Kelly, Steve Speicher and Keith Wells) Take a closer look at XML Forms Generator. Part 1 of this two-part series showed you how this alphaWorks technology uses Model Driven Development concepts with Eclipse Modeling Framework (EMF) to permit generation of forms from XML inst