(Jim Wankowski) In this white paper, expert Jim Wankowski explores the progression of DB2 application development over the last three decades. He covers DB2 programming trends and solutions for maximum application performance in today’s development environment. (R)
Author: SSWUG Research
An easy way to export performance data from mysqld
(Mark Callaghan) Chip Turner has begun work on a new storage engine that makes it easy to export files as if they were database tables. Why is this good? I have written code to export data from /proc in SHOW STATUS. This makes it possible to track changes in system resource consumption, such as the
updatable views and instead of triggers
(Laurent Schneider) I am data-modeling those days. Each table has it own description table (yes, it is Java). To keep it simple, FRUIT[id,description] and MEAT[id,description] (35 of them right now). There must be one table which contains all descriptions in it GLOBAL[type,id,description]. I wish
Two Oracle PL/SQL Features You Probably Don’t Know About
(Eddie Awad) Oracle PL/SQL has a neat and little known feature called forward declaration. In this post I’m going to do a quick review of what forward declaration is, how it can be used and a situation in which forward declarations are absolutely required, mutual recursion.
Updating Tables Using a Single Updategram Message in BizTalk Server 2004 and 2006
(Naveen Karamchetti) The SQL Transport Schema Generation Wizard in BizTalk Server 2004/2006 does not permit the selection of multiple tables for updating when generating a schema for an Updategram.
Set up OLE DB source to read from View efficiently
(Runying Mao) OLE DB source adapter is one of the most commonly used components in SSIS data flow task. In this article, we will discuss a very important performance observation about this adapter.
Identity Management Using PHP, Part 1
(Michael McLaughlin) Managing secure access to Web pages and applications is a common problem. You want to enable those you trust to access data while preventing unauthorized ones from gaining access to it. In most cases, identity management is the solution to this problem.
Migrate and consolidate Access databases to SQL Server
(Michelle Gutzait) Microsoft Access is a simple development tool to use and you don’t even need a development background in order to write an Access application. There may be many departmental Access databases in your organization that have been built over the years for specific reasons. Major reaso
SOA: Providing Enterprise-Wide Information Access
(Mehdi Hatami) Most medium- to large-sized organizations face similar challenges in managing and accessing information across a heterogeneous environment. They have numerous applications running across the organization at both an enterprise and departmental level for daily business operations, decis
Bring existing data to the Semantic Web
(Wing Yung) The Semantic Web has promised a new era of easier data integration. Of course, much existing data is already out there in various formats. To convert all of it to RDF (the Semantic Web format) would be a herculean undertaking, so to expose existing data as RDF is preferable. This article