(Roman Rehak) Developers love database programming tips, tricks, and workarounds—especially those that slash development time or boost application performance. Here’s a collection of such nuggets for developing SQL Server applications.
Other News
Using XML Data Islands in Mozilla
(Thad Hoffman) One handy feature of Internet Explorer is the ability to use data islands to link data to html controls on a page. This feature is not readily built into Mozilla, but one can easily mimic this behaviour to build cross-browser web applications.
Document Transformation System from Papers to XML Data Based on Pivot XML Document Method
(Yasuto Ishitani) This paper proposes a new method for document transformation using OCR to generate various XML documents from printed documents. The proposed method adopts a hierarchical transformation strategy based on a pivot XML document. Firstly, document elements such as title, authors,
Creating and Linking LOBs in a Data Application for Microsoft .Net using DB2 Universal Database
(Sonali Surange) Using a sample data-bound, forms-based application, learn how to manipulate LOBs. It’s easy with the DB2 UDB Add-Ins for Visual Studio .NET.
Relationships Should NOT Be Natural!
(Peter Petroski) Using naturally occurring data can have negative impact on database performance. We should restrict ourselves to using cold, hard, sequential numbers, and forget about those warm, comfortable relationships with data that are so familiar.
Creating an Oracle JDeveloper Application Migration Assistant Search Rules File
Oracle JDeveloper Application Migration Assistant (AMA) is a new tool developed by the Migration Technologies Group at Oracle to simplify the process of migrating applications to the Oracle platform. AMA provides simple code navigation and progress reporting to guide you through an application migra
Migrate DB2 UDB applications to a partitioned database
(Bill Wilkins) Using a partitioned database allows you to maximize the scalability and capacity of DB2 UDB for Linux, Unix, and Windows. This article discusses what DB2 partitioning is, outlines the benefits and costs of using it, and helps you decide whether or not to use a partitioned database
Multiple Temporary Tablespaces in Oracle 10g
(James Koopmann) When a users executes a SQL statement that requires sorting or does some sort of database maintenance that requires the creation of temporary segments, it is the temporary tablespace that assists in that sorting or holding of those temporary segments. If we did not have an area desi
Implementing CRUD operations using Stored Procedures: Part 2
(Andrew Novick) In database terms, CRUD stands for the four essential database operations: Create, Read, Update and Delete. To create a high performance system, these four operations should be implemented by stored procedures, each procedure implementing one of the four operations. This is the secon
Get started with XPath
(Bertrand Portier) This tutorial introduces XPath and covers most aspects of it. It is aimed at people who do not know XPath or want a refresher. If you plan to use XSLT, you should take this tutorial first. You will learn: What XPath is, the syntax and semantics of the XPath language, how to us