(Edd Dumbill) Jeff Barr, Amazon’s web services evangelist, explained to XML 2003 attendees the decisions facing Amazon in opening up their systems for public use via web services. Barr’s case study, delivered to a full room, formed part of the product presentations track on the first day of the conf
Other News
Implementing Error Handling with Stored Procedures
(Erland Sommarskog) Error handling in stored procedures is a very tedious task, because T-SQL offers no exception mechanism, or any On Error Goto. All you have is the global variable @@error which you need to check after each statement for a non-zero value to be perfectly safe. If you call a stored
The Need for Speed: Speeding up DB2 UDB Using Sampling
(Peter J. Haas) The vast amount of data in warehouses and on the web poses a major challenge for users who want to run BI or OLAP queries, execute advanced analytical, mining, and statistical algorithms or interactively explore their data. Most of these tasks simply do not scale to the hundreds of t
SQL Server: Calculating Running Totals, Subtotals and Grand Total Without a Cursor
(Gregory A. Larsen) If you have ever had the need to show detailed data of individual transactions and also keep a running total, subtotals, and grand total columns at the same time, but were not exactly sure how to tackle the problem then this article might help. In this article I will show you a f
Microsoft Plans Jan. 27 Coming Out For Reporting Services
(Barbara Darrow) Reporting Services for SQL Server 2000 will make its official debut on a Jan. 27 Webcast, according to a Microsoft spokeswoman. The company had been trying to get the database add-in out by year’s end. Last June, Microsoft changed course on reporting services, which were to be a
24×7 DB2 applications tips for good design, part 2
(Predrag Jovanovic) Without full concurrency there is really no on-line application, let alone a 24×7 application. Concurrency means that many different processes with fully secure data integrity can process the data, and every request will be correctly processed. How do you ensure full concurre
Example 127 (Insert/Update/Select with DB2 BLOB in stream mode)
This example demonstrates INSERT, UPDATE, and SELECT statements with the DB2 BLOB datatype in the stream mode.
Build Superior Java Applications with Oracle Application Server 10g TopLink
Building Java applications that use relational databases is perhaps the single most underestimated challenge in enterprise development today. More projects are delayed, under featured and difficult to maintain because of this underestimation. The problem lies with the use of fundamentally different
XSLT Tutorial — Free
In our XSLT tutorial you will learn what XSLT is. You will learn how to use XSLT to transform XML documents into other XML formats, like XHTML.
Working XML: Map files into SOAP requests, Part 1
(Benoit Marchal) How many times have you witnessed this scenario? Developer: “So the quantity is always stored in the OQTY field?” Administrator: “That’s right. Just pick it up from there.” Developer: (Later) “Could you help me out? These lines have no quantity?” Administrator: “Oh, yeah