(Tony Marston) The development infrastructure I use to develop my web applications is described in A Development Infrastructure for PHP. This is based on the 3 Tier architecture.
Other News
Recovering from Crashes
(Guilhem Bichot) Here we discuss how to recover data after a crash in case of: –operating system crash –power failure –filesystem crash –hardware problem (hard drive, motherboard…).
Sidebar: Oracle Plans to Add BI Offerings
(Heather Havenstein) Oracle is maneuvering to bolster its business intelligence market share with new stand-alone query, reporting and analysis tools and an extension of the operational reporting in its applications suite.
Systems Programmer’s Guide to Resource Recovery Services (RRS)
(Frank Kyne, Paola Bari and Alan Murphy) This IBM Redbook gives you a broad understanding of the Resource Recovery Services (RRS) environment. RRS provides a global syncpoint manager that any resource manager on z/OS can exploit. It enables transactions to update protected resources managed by many
CICS IA Sample SQL Queries
IBM CICS Interdependency Analyzer starter set of CICS online queries is helpful for quick, relatively simple queries. However, virtually any possible query can be done by bringing to bear all the power of SQL on the DB2 database. Some customers have found that they already have DB2 information r
SQL Server 2005 Part 2 – High Availability and Scalability Enhancements – Database Mirroring
(Marcin Policht) In the first article of this series, we presented a high-level overview of SQL Server 2005 functionality, based on its most recent Beta 2 implementation. Our goal, going forward, will be to discuss each of new or improved features in more details, focusing on engineering and adminis
Using SQL statements with ASP
(Amy Cowen) For most Web builders, using databases goes no further than presenting data from Access. If you’re using ASP, however, SQL statements can supply significant and sophisticated methods to get at the data. Both ASP and SQL are powerful tools for mining information, combining data from diffe
Location, Location, Location (Keeping track of your spot in an XML data file)
(Uche Ogbuji) It is often useful to keep track of the location of some data in an XML file being processed. If you are parsing a file in order to perform sophisticated search and analysis tasks, you may want to know in which element or other such node a specific pattern was found (or even at what fi
Renaming a SQL Server
(Brian Knight) Renaming a server can be a mystery in SQL Server. The symtoms that SQL Server displays after you rename a server makes it look like you made a bad mistake. There are registry entries and system table records littered throughout your system that reflect the server’s name. In this b
An Intro to Oracle PL/SQL
This is a brief introduction to database programming with using Oracle’s procedural language – PL/SQL. You need to know Oracle basics like creating tables and simple select statements before reading this.