(Selim Mimaroglu) When we need to store XML in a Relational Database Management System (RDBMS) we have to think of nonnative ways to store it, since the structure of XML does not fit the flat relations of the RDBMSs. Although some RDBMS vendors support XML storage and XQuery such as Oracle 10g (rele
Author: SSWUG Research
Red Hat’s JBoss Acquisition Could Create A New Open-Source Powerhouse
(Charles Babcock) Red Hat’s $350 million purchase of JBoss, the open-source application server company has the potential to create a new open source code powerhouse, since it moves Red Hat from being just an operating system distributor to a provider of a larger software stack, particularly in middl
Best Practices in Metadata Management
(Anne Marie Smith) Literally “data about data”, metadata is a concept that is receiving increased visibility throughout the information systems communities, making the need for understanding metadata and its varied roles across the design and use of systems and the information they capture. To make
Do you know you can monitor your units of recovery (UR)?
(Willie Favero) I hope today’s topic for discussion is old news to most of you. It would be great knowing that someone paid attention in one of my IDUG or DB2 Tech Conference presentation on DSNZPARMs. However, some of you all may have just not had the opportunity to hear it yet. This entry is for y
Quick Debugger Visualizers in Visual Studio 2005
(Mike Gunderloy) Debugging in Visual Studio is a wonderful thing. You can use the tools built into the debugger to drill into the values of objects and their member variables easily. But even wonderful things can be improved, and that’s exactly what Microsoft has done with the introduction of debugg
Query DB2 XML data with XQuery
(Don Chamberlin and Cynthia M. Saracco) By now, you’ve probably heard about DB2 Viper’s new architecture, which supports both tabular and hierarchical data structures. Indeed, previous articles have summarized DB2’s new XML features, described how to create database objects and populate them with XM
Debugging an HTTP Handler (*.ashx) in ASP.NET 2.0
(Dina Fleet Berry) A handler is responsible for fulfilling requests from a browser. Requests that a browser manages are either handled by file extension (or lack thereof) or by calling the handler directly. Only one handler can be called per request. A handler does not have any HTML static text like
Executing SQL Stored Procedures from inside a Web Application Part 2
(Don Schlichting) How to pass parameters (variables) IN, OUT, and RETURN error codes from a Stored Procedure to a Web Page.
Cache In On the Enterprise Library Caching Block for .NET 2.0
(Thiru Thangarathinam) The ability to store items in memory the first time they are requested—whether data objects, pages, or parts of a page—is one of the most important factors in building high-performance, scalable applications. After storing such items in the local cache, you can improve applica
Stored procedure: Determine last database backup
(Michelle Gutzait) An experienced DBA understands the meaning of backups. Say a project manager calls you just as you are about to leave the office to spend a nice, quiet evening with your wife or husband. “Help! We just dropped our main table in production. It was a mistake! We need to recover