(Wei-Dong Zhu) This IBM Redbook deals with IBM DB2 Content Manager implementation and migration. It is aimed at architects, designers, developers, and system administrators of Content Manager systems. We cover the basic concepts needed to design and implement a Content Manager solution. This incl
Other News
Virtual Indexes in Oracle
(Amar Kumar Padhi) Virtual Indexes are another undocumented feature used by Oracle. Virtual indexes, as the name suggests are pseudo-indexes that will not behave the same way that normal indexes behave, and are meant for a very specific purpose.
Practical data binding: Who uses this stuff, anyway?
(Brett McLaughlin) While my last several articles have been useful (I hope) from the perspective of a specific implementation, my goal is to make this article down-to-earth and practical. Most of the stuff I read in books and magazines makes me wonder if the authors have actually used the things the
How To Use Excel with SQL Server Linked Servers and Distributed Queries
SQL Server supports connections to other OLE DB data sources on a persistent or an ad hoc basis. The persistent connection is known as a linked server; an ad hoc connection that is made for the sake of a single query is known as a distributed query. Microsoft Excel workbooks are one type of OLE D
Database Change Management: An Automated Approach
(Darren Fuller) In this first article of a 4 part series, Darren Fuller discusses the need for database change management and problems with current approaches. Future articles in the series will examine an automated methodology, the requirements to implement such an approach and describe the benefit
The New Bloglines Web Services
(Marc Hedlund) Bloglines announced a set of new web services APIs, allowing developers to write applications for reading RSS and Atom feeds by drawing data directly from the Bloglines databases. This is a very significant change in the landscape of RSS/Atom aggregators, the newsreading applicati
Maintain consistency between the compiled schema and the generated classes
(Olivier Le Diouris) JAX-B is the specification that implements the Java Api for XML Data Binding (JSR 31). It basically allows java programmers to deal with the content of an XML Document, without having to deal with an XML Parser’s Api.
Scanning the network for SQL Server for a range of IP addresses
(Muthusamy Anantha Kumar) In a large IT department, it can be difficult to locate where new SQL Server installations were made and how many of those SQL Servers were patched, etc. This article explains how to scan the entire network for a range of IP addresses to find which boxes have SQL Server
INF: How to Control a Member’s Unique Name
In Analysis Services a Member’s Unique Name may be different depending on the setting of the MDX Unique Name Style connection string property of the Microsoft OLE DB Provider for OLAP 8.0. This article describes the different formats of the Member’s Unique Name and when you would want to control the
DB2 SQL Procedural Language: Using Flow of Control Statements
(Drew Bradstock, Hana Curtis, Michael Gao, Zamil Janmohamed, Clara Liu, Fraser McArthur and Paul Yip)Conditional statements allow stored procedures to make decisions. They are used to define multiple branches of execution based on whether or not a condition was met.