(Martin Hubel) When I mentioned to my DBA friends that I was writing a column on IBM Content Manager, most of them had heard the name but knew little about the product. But as companies face increasing pressure to manage content as well as data, DBAs will need to know more about managing content and
Other News
Creating a SQL Server Database Programmatically (Basics)
(Mahesh Chand) SQL provides statements to create new databases and database objects. You can execute these statements from your program to create databases programmatically. In this article, you’ll see how to create a new SQL Server database and its objects such as table, stored procedures, view
Producing HTML Reports from DB2 Data – the Easy Way
(Jayesh Thakrar) HTML-based output has become a very common mechanism for feeding data and information to application users, programmers and administrators. The output can be also very conveniently integrated into Web portals. One way to obtain HTML output from IBM DB2® Universal Database™ (UDB) is
Importing XML documents to Relational Databases using Java
(Ale Gicqueau) These days, most companies across all industries use relational databases or RDBMS (Relational Databases Management Systems) to store and manage their critical business information. In fact, the three most important relational databases vendors happen to be the three most important so
Tuning Oracle Database 10g on Linux Using ASM
(Bert Scalzo) I often react to new Oracle releases the way Steve Martin did in the movie The Jerk when a new phone book arrives. I cannot help but get excited about all the new technology that Oracle routinely delivers. But, with the release of Oracle Database 10g, that enthusiasm cannot be overstat
Longhorn for Developers – A Brief Introduction
(Mahesh Chand) Before we look at Longhorn programming model, let’s take a quick look at current programming model in Windows. In Windows, we can write two types of applications – Windows based or Web based. In .NET, usually we use Windows Forms to write Windows applications and Web Forms (ASP.NET)
XML Capabilities – FOR XML Clause
With the release of SQL Server 2000, a lot more support and functionality for XML was included in the product. In this article we would target at some of the out of the box functionality that SQL Server 2000 offers us to convert our relational data as XML formatted data. Not wasting much of the time
Comparing Business Intelligence Platforms
(Thierry D’Hers and Stacy Vickery) This white paper compares the features of Microsoft® SQL Server™ 2000 Analysis Services, IBM DB2 OLAP Server 8.1, and Hyperion Essbase 6.5. As you’ll learn, Analysis Services has functionality that compares favorably against other offerings such as IBM DB2 OLAP Se
Database Recovery Using Redirected Incremental Restore
(Roman B. Melnyk) Suppose your database server is destroyed by fire. Luckily, you have a good backup strategy in place. This strategy includes remote storage of backup images and recovery logs. The set of backup images that you have at your disposal includes full database backup, online incremental
Replication Agents
A Replication Agent is a Replication Server client that retrieves information from the transaction log for a primary database and formats it for the primary Replication Server. Replication Agent detects changes to primary data and, using Log Transfer Language (LTL), which is a subset of Replicat