(Sundip Pradhan and Serge Rielau) Complex applications or batch processing can execute hundreds of SQL procedures and potentially thousands of SQL statements, difficult to tune using traditional monitoring methods. This article introduces a Java-based GUI tool for use with DB2® Universal Databas
Other News
Creating an In-Memory Database Using XML and XPath — Part 1
(Niall Ginsbourg) Many articles have been written about how to send an Extensible Markup Language (XML) file and an associated Extensible Stylesheet Language (XSL) file to Web clients to reduce processing load on the server. Unfortunately, in the real world this isn’t going to solve many problem
Build Your Own RAC Cluster on Linux and FireWire
(Jeffrey Hunter) One of the most efficient ways to become familiar with Oracle Real Application Clusters (RAC) technology is to have access to an actual Oracle RAC cluster. In learning this new technology, you will soon start to realize the benefits Oracle RAC has to offer like fault tolerance,
Web Services Programming Tips and Tricks: Use collection types with SOAP and JAX-RPC
(Andre Tost and Tony Cowan) This article introduces a couple of techniques that you can use to build interoperable Web services that take and return object collections. This is the first of a series of articles covering this subject. Future articles will cover more detailed scenarios.
An IBM DB2 Universal Database Stinger Feature Preview: Enhanced Savepoints
(Roman B. Melnyk and Paul C. Zikopoulos) This article is another in a series that introduces some of the key features in DB2 UDB “Stinger,” and includes “work-through” examples that you can use with the open beta today. In this article, we will introduce enhanced savepoint support.
Production Releases on to Multiple Databases – Part 2
( Muthusamy Anantha Kumar) In the previous article, we discussed how to implement SQL production changes to multiple databases on the same server. In part two we will discuss implementing SQL changes to multiple databases on more than one server. The following steps explain how to apply similar c
FIX: A CHECKDB statement reports corruption after SQL Server transfers sql_variant data in SQL Server 2000
A DBCC CHECKDB statement may report consistency errors in your database when all the following conditions are true: –SQL Server loads data into a column that is a sql_variant data type. –The data originates in another column that is a sql_variant data type and at some point the data is sen
Oracle Tip: Understand the difference between star and snowflake schemas in OLAP
At the core of data warehouse applications and OLAP (online analytical processing) is a specialized schema that relaxes the rules of Third Normal Form RDBMS schemas in favor of faster analysis and processing of large amounts of data. It’s important to understand the difference between these kinds of
From XML to SMIL
(John E. Simpson) How do I create a SMIL text region using XML input? I am new to XSLT and SMIL, but I am attempting to create a SMIL presentation based on an XML document, using XSLT. Can anyone tell me how to take the text contained in my XML document, and output it to a region of my SMIL […]
Buried Treasure in Your Backyard
(Brian Lawton) It’s been almost 4 years since SQL Server 2000 hit the street. With it, Microsoft unleashed a powerful but often underutilized toolset. Think for a moment about your own organization. Are you doing anything more creative with your SQL Server software than running an occasional backup