(Craig S Mullins) In my last blog entry I posted about DSNTEP2, the batch SQL program. But there is another batch SQL program named DSNTIAD that is less widely-known and used.
Other News
Creating a Simple SQL Server 2005 Notification Application: Stock Quotes
(Shyam Pather) In this chapter, you’ll see your first SQL-NS application: a stock notification service similar to those offered by many real-world stockbrokers. The application allows subscribers to enter subscriptions for stocks in which they are interested and notifies them when those stocks cross
Leverage your PostgreSQL V8.1 skills to learn DB2, Version 8.2
(Ted J. Wasserman) There has never been a better time to consider switching over to DB2. With the recent announcement of DB2 Universal Database (UDB) Express-C Edition V8.2, a fully functional, free version of DB2 for Linux, Unix, and Windows platforms (32-bit and 64-bit), more and more developers w
Performance monitoring with Enterprise Workload Manager
(CheKim Chhuor) Today, multi-tier Web applications and clusters are very common in IT environments. System administrators need to know how their Web applications are performing to satisfy established business goals or service level agreements (SLA). There are several tools to let you monitor systems
Database Design (Sample Chapter)
(Michael Kofler) The first stage in any database application is the design of the database. The design will have a great influence on the efficiency of the application, the degree of simplicity or difficulty in programming and maintenance, and the flexibility in making changes in the design. Errors
Native XML Data Storage and Retrieval
(George Feinberg) The design and implementation trade-offs within a native XML database make a significant impact on the performance, scalability and features available to applications that use it. This article focuses on the granularity of stored XML documents and indexing as two of the most critic
Index maintenance of 10G
(yas) I have read at Eric S. Emrick’s blog about the redo behaviour seen when updating a primary key column Oracle takes some special steps to prevent unique key collisions that may temporarily occur during the update. You can read what it does at Eric’s post in detail. As Eric shows, it maintains t
DACBuilder – Data Access objects generation tool based on XML and XSL templates transformation
(Dan Radu) When I started working in database programming and complex business implementations, the need for a data access framework was definitive. I started to build my own classes that accessed data objects. Of course, starting from 0, the effort was bigger and I thought that a “general” data acc
Oracle Takes Aim at Enterprise Business Intelligence Market
Oracle Corp. recently moved to stake a claim in the increasingly crowded enterprise business intelligence market with a new suite of tools and applications.
The State of Web 2.0
(Dion Hinchcliffe) Now that Web 2.0 has had its mainstream media coming-out party in both Newsweek and Slate recently (here and here), I thought I’d take some time this afternoon and try to get a real sense of the prevailing winds. Before I go further, I would ask all of you with innate dislike of