(Micah Dubinko) XML and the labyrinth of related technologies have gotten complicated enough that a resume-writer can no longer sum up her XML experience with short bullet points. Or can she? Members of the XML community come from diverse backgrounds and educational experiences. If you had to di
Other News
Starting with Oracle ADF
(Steve Muench) In my last column, I described how Oracle JDeveloper 10g and the Oracle Application Development Framework (ADF) give developers familiar with Oracle Forms a familiar rapid application development (RAD) environment and a powerful set of business components for quickly building J2EE app
The Cornerstone Of Crash Recovery
(Roger Sanders) How many times have you encountered the following error message: SQL0946C The transaction log for the database is full?
Architecture (Sample Chapter)
(Rick Greenwald, Robert Stackowiak and Donald Bales) If you understand the architecture of Oracle Application Server, you will have an excellent framework for understanding how the product works. Learning how the various components of Oracle Application Server interact can help you avoid many p
Selecting a SQL Server recovery model
(Greg Robidoux) SQL Server 2000 offers three recovery models for each database: Full Recovery, Simple Recovery and Bulk-Logged Recovery. The recovery models determine how much data loss is acceptable in case of a failure and what types of backup and restore functions are allowed. (R)
Creating Tables in to the Database
(Arun M.Patil) In my first article I have explained how to create new database along with database files. This second article is useful for beginner’s who are learning SQL Server 2000 database. Now you learn how to create table in database. Before creating the table you need to understand table
Using SQL against the Unified Dimension Model in Microsoft SQL Server 2005 Analysis Services
(Mat Stephen) Following Deepak’s question, asked in his comment on my previous UDM post, I quizzed our internal Yukon alias and received the following useful info regarding using SQL against a UDM; thanks to Akshai Mirchandani.
Top N rows for each X
(Rudy Limeback) I want a query for retrieving the top two recently inserted records for each id. My table has columns id, adate, and description. There are five records with id 2 and four records with id 3. I want to retrieve top two records for both id 2 and 3. I should get total four records,
Named and Non-Capturing Groups in .NET Regular Expressions
(Tom Archer) The previous article introduced the .NET Group and GroupCollection classes, explained their uses and place in the .NET regular expression class hierarchy, and gave an example of how to define and use groups to extract or isolate sub-matches of a regular expression match. This article co
Integrating DB2 Universal Database for iSeries with Microsoft ADO .NET
(Hernando Bedoya, Carlos Carminati, Lorie DuBois, Jarek Miszczyk and Ajit Mungale) Customers have been using the IBM DB2 UDB for iSeries for many years with data access technologies such as ODBC and OLE DB. Microsoft’s newest data access technology is called ADO.NET. Applications that want to use AD