(Kevin Tatroe, Rasmus Lerdorf and Peter MacIntyre) Picking up where we left off last week in our discussion of databases and PHP, we’ll talk about connecting, issuing a query, and more.
Other News
Understanding Isolation Levels in Transaction
(Sanjit Sil) The level at which a transaction is ready to accept inconsistent data is termed as isolation level. A transaction is a set of operations that must either succeed or fail as a unit. The goal of a transaction is to ensure that data is always in a valid, consistent state. To know more abou
Reading and Writing XML using XLinq
(Mahesh Chand) XLinq is the name for API to work with XML in next version of .NET with the power of LINQ. It provides functionality to read, write, and manipulate XML documents. XLinq lets you run SQL like queries on XML documents.
Compilers Demystified: Function Pointers in Visual Basic 6.0
(Bornish) The purpose of this investigation is to enable applications written in VB6 to use function pointers. Other advantages may be discovered, such as embedding native code in VB applications, thus extending the world of possibilities without the need of external DLLs. For the sake of keeping th
Using SQL Backup
(William Brewer) This article describes a proprietary third-party SQL Server backup tool, namely Red Gate’s SQL Backup. I am not an employee of Red Gate, but I have been using the tool for several years, like it, and recommend it to my clients. I state this in order to set the correct expectations f
How Not to Use Shell Commands
(Alex Gorbachev) Here are a few nice typos that had quite disastrous consequences.
solidDB 6 In-Memory Database Proof-of-Concept Integration with IBM DB2
Many advanced new applications and services demand extremely fast, always-on access to data under high throughput conditions. The solidDB 6 in-memory capability can extend IBM DB2 into these high performance applications, using advanced techniques that optimize performance for SQL tables that can fi
Using SQL Server Table-Valued User-defined Functions with Exchange Web Services
(Jim Kleewein and Ray Dixon) The SQL Server Tables and Exchange Web Services sample demonstrates a powerful integration of Microsoft Exchange Server 2007 and Microsoft SQL Server 2005 features. This integration enables you to provide data from both Microsoft Exchange and SQL Server to client applic
Control null data in Oracle using the ORDER BY clause
(Bob Watkins) NULL data, which is sometimes called “absent” data, can be difficult to work with in relational databases. When a query contains the ORDER BY clause to sort the output, NULL data will sort to the bottom if the sort is in ascending order (ASC) and to the top if the sort is in descending
Optimization Service Center fixpak 1 available
(Willie Favero) If you’ve downloaded Optimization Service Center (OSC) for DB2 9 for z/OS, you should go out a pick up the first fixpack. Fixpack 1 has a number of requested improvements. OSC is extremely new and the only way to experience its true value is to make sure all maintenance is performed